I have created a database with all the functionalities in it. I am now interested in creating a username and password to allow administrative staff to access...

Hi, I took over a project and recenly converted the database from ACCESS 97/SQL 7 to MS ACCESS XP/SQL Sever 2000. The database object is use is DAO....

I've made an Access 97 application which will be used by multiple users. I set the start-up properties very restrictively so as not to allow the database...

Hi, One of my clients has a machine which has Microsoft Office 2003 Standard installed. We need to add Access 2003 to this machine. Do I need to purchase the...

In a database, there are several items in a single row that may or may not be listed as yes/no in a checkbox format. When I transfer the information from...

I am just learning Access and have set up a database which works fine except that the field I have set up to keep notes in keeps truncating the data. I set it...

I am migrating from Access 97 to Access 2003. I converted an access 97 file to Access 03 db. the size of the Access 97 file was 7,778KB where as the converted...

Hi, I need some help here, no matter what I do I can not close the FS form. On my FS For I have on single text box (tlogin) and I am using the Enter event...

I have two tables and a form: Table 1 Id products pkg size customer addr city state zip Table 2 (set up as query) Id product pkg...

I had a form that was working fine but I had included the wrong table, when I corrected the error neither the quiery that the form runs off or the for will run...

In anticipation of my various Access deatabases being combined someday, I would like to automatically populate a column on every record with a project name I...

I have a query with fields from different tables. Two or three of these field may have one or more entries. When I run the query, if it displays a record...

Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...

I would like to consecutively number an Access report each time it runs so that I know how many times this report has run. Can anyone help?

I have a table of values which has the following fields: AreaElement, Joint, GlobalX, GlobalY, M_sd This list consists basically in a long list of M_sd...

Hi, I found the following commandment on the www.mvps.org/access site. Thou shalt never allow thy users to see or edit tables directly, but only through...

IF I have 2 table (A & B) and I want to add them to the quanity of table C. How would I do that. But I want table C to be a running total. So if table C = ...

Ok I'm posting this here as you guys have been so helpful in the past. I've been asked to do a query to work out the total working hours taken to do a job. ...

Can anyone help me please. I'm totally new to Access 2007 but have started to design a database for my husbands shed business. I have an Orders Table and a...

Hi I am using this code to send data into excel Set rst = CurrentDb.OpenRecordset("SELECT Temp.* FROM Temp;") rst.MoveFirst Do While Not...