Hi, I wish to run modUpdate which includes an Append Query, Delete and Make Table, but the following hangs on DoCmd. I would appreciate any help. Function...

This report displays all no-shows sorted by most recent date. We need a button on the report display that when toggled will ask for a person's name and after...

Hi guys, I have been backing up my data by exporting them as Excel worksheets to a stiffy(TransferSpreadsheet). I would now like to automate the process of...

Hi i was hoping someone could give me a brief explanation, or point me at a tutorial that explains how the Count and DCount functions work. I have a report...

Is it possible to change a public boolean value in a module (e.g. blOK as boolean, blOK = True), close the database, reopen and have the boolean value in the...

Hi Group, I am using Access97 on WinXP platform. I have a form frmAttendances on which there is a control fldDate. Basically I display a list of people and if...

I have two tables. One on CATS the other on CONTACTS. In the contacts table their is a "FULL NAME" field. I need to use this in a form where I pull up the...

Hello, i want to add a receipt printing capability to my developed programs. are there receipt printers available that are treated like an ordinary printer....

I have two calendars on my form. How can i make it so that when the user clicks a command button it checks to see if the first calendar date is greater than...

I run the shipping department at work and would like to know if it is possible to configure access to print a delivery ticket, packing list and a box label...

When i click on mmy command button an error message comes up telling me that i can only reference a control if it has focus. How can i fix that? Here is the...

Using Access 2000, I want to create a table containing a list of products (product code #, product name, description, price, etc..) and Export it into a Pipe...

Our database has two tables... one is a Directory table with the contact information for each student we work with. On ID # as primary key. The 2nd table,...

I created a query to pull records based on dates. I then added a button to my switchboard to run the query. I would like to have a box pop up after the button...

Beginning user of Office 97 on a Windows 98se machine. I am entering new data on a table and when I hit the Enter key to go to the next row, all the data I...

Hi, I have used the lookup wizard in a form to select a field that is in another table but I only want it showing up once, not mutiple times as in the...

I'm using Access 2000 and would like to build an expression that would calculate an expiration date based on the date I enter in a date field. I would enter...

I get a message, "link text out of memory" after trying to open a large ascii text file. First, it take at least 40 minutes to processes then gives me the...

Is there another way of opening a form in ms access beside docmd.openform "frmName"???

I'm using MS Access as my front-end and MySQL as my back- end. I have queries named qry1, qry2 and qry3 and two (2) tables named tbl1 and tbl2. In qry1, I get...