I developed an interactive client VB app which updates data in an ms access database. Currently the VB app connects to the database using a file share. Now the...

Hello, I am currently working on a query that uses two tables from two diffrent sources. The first table contains all of our Customers Name and Address's and...

I want to hyperlink the user guide (Word) for the database on the main menu of the front-end file. The link opens the document on my pc, but the other users...

i'm trying to figure out if there is a way to enter a variable in a field name. for example - i have a query for a report with a field month (number) and other...

Hi all; I have a table in my database that has several fields which need to be updated periodically with new information. I have successfully imported the...

My app has a table of user logon info. Certain people are assigned to be able to add/modify users, but I want to be able to hide the password of the person...

How would someone add subscripts to a report generated in MS Access? The subscripts must be numerical, i.e., 1, 2, 3, 4, 5 etc. I have the first 3 characters...

Hi, I have a field ID# in a table. The format is L#########. Can the ACCESS 97 automatically put zeros between the letter and numbers if I enter numbers only....

Can you set a default value to change with each entry. Example: a sequence of numbers that change on each entry.

I created a master copy of my database before splitting it. Once I split it I was successful in placing a copy of the frontend on each pc and relinked all the...

I have Access 2000 and I am creating a database of my inventory, one of the tables is going to be for items sold. When I mark that item sold in the main table...

Please help me ! Anybody can help me with a code to embed an ms word file into an access table ? I have ms word templates with bookmarks in my hard disk. So...

Hi, I wanted to have fields in a table that displayed different things (such as 'update') according to the date value of other fields in the database. I could...

Hi Here goes, I'm a novice, an I deleted something called Proret MSI which I found out much later what it was, when I realised my speakers weren't faulty, I...

I cannot get the built-in addins to function, I have verified that the acwzmain.mde, ACWZLIB.MDE, ACWZTOOL.MDE and utility.mde are in the correct places and...

I have the same problem as the guy below who wants to remove spaces from multiple records, except I need to do it in Access 97. I've already tried the Replace...

hi, i've made a report in Access2000 using a report with three subreports. The amounts in the subreports are summed in a field in the footer of the...

I have a combo box on a form, the info in the box is looked up from a table. My problem is I want the list to be sorted a-z but it shows up in what ever order...

I have a report with the following fields(from a query): Data Material_Code Item_Code Items Name Quantity re_done Unit_Price ...

Please help, we have an 'off the shelf' software package installed at hundreds of sites and several have called up today saying they cannot load the system and...