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...

Greetings, I'm using access 2000 and using switch board for my menu control. I don't want to spent too much time to design a form layout so decided to...

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...

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 a SQL 7.0 database that I have been using as a backend data store and using Access 2000 .adp as the frontend. I have also created many stored...

My update isn't updating the table. Why? Code is: strSQL = "Update AVAILABILITY " & _ "Set AVAILABILITY. = " & varNewID & _ " WHERE AVAILABILITY.BookingDate=...

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?

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 = ...

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 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...

Hello everyone, I've been wondering this question for a few weeks now. My situation is that I generate many "runlogs" from my reactor that have various...

Hi there I have created a listbox called LB_Actions with the following: Display Control: List Box Row Source Type: Table/Query Bound Column: 2 Column Count:...

Based on A 2007 I have found how to do this or NOT do this http://office.microsoft.com/en-us/access/HA010448531033.aspx My problem is as follows is this...

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...

Dear All, I have a form but i could not move to the next record and even i could n't save the records to the table. How can a table and a form fields can be...

Hi This is the situation: In my database, my user has added a record for a new student. When she pressed save, the following message appeared: “The...

I recently upgraded computer including a larger monitor. When I now run my databases, they fill about 25 percent of the new screen. How can I enlarge my...

I created a form and added a button with the embedded Macro that prints the current record only. The macro arguments a select record, print record. My...