Dear Sirs, My program is ready thanks and due to all of your help. During testing now I realized that I have a field in a query which is called:openp & l but...

Hello. I need to use a count of records returned by a query in my form code. I can use an actual count of the records returned by a query or I can use the...

In Access 2007, when I set up a View to query some fields and then delete some of the fields from the query I get an error message. For example, I set up a...

I have linked to an older table to which I need to add new records. My problem is that one of the fields is named S&H (honest!), and Access won't...

So i have a table with the following data on it: Date | CustomerID | Method | Aged Days | Manager and have a query based off of the table with the...

Recording the date and time when a record is modified in Access Create a macro named LastModified and set its action and item arguments as described in the...

Dear All I need your help to make an update querrie. I have the following tables: 1-Date Table : only 1 field dates 2- Customers Code: 2 fields (Code -...

Hello, I have a field of text with values such as: 07-55 02-222 03-4444 In an empty field, using an update query, I'd like to make them 8 digits formatted...

I have 7 categories each with 10 sub categories. (Example) main group is: “Personal� sub groups under “Personal� are Billing Letters Fin...

In a VBA function, I need to fill a combo box with the table fields name. Could you please help me on this? -- Wagner Mokva

I am having to change all cross tab report from calendar year to fiscal year which begins in October. Any sugestions on how to accomplish this?

But I can run it - MS Access 2K - Preminum Thank you in advance.

This table is linked to another database. I have one column that contains data that starts out with the job number. I want to make another column in a...

I have Planned Start Time And Actual Start Time I only want to return records where the Planned Start Time is equal to or less than 48 hours from the Actual...

Hi all, I'm trying to create a database that contain electrical performance of my companiy's product.As the objective, at last I have a report look like...

Hi. I am looking at tables which come from an ODBC source. The data has incorrctly been entered (in some cases) in the City Field, in Proper, Lcase & Ucase....

All, Here is what I am dealing with. I have two tables: West(NY) and South (NY). These tables are supposed to be identical, however the person that updates...

Hello I am using access 2003. A query field I have been using for several years contains the following code in order to keep a current age in reports. I has...

hi to all I'm sure this is easy, but as a new user I could use some help. tblAllMembers lists records for all present and past members of a sports club. ...

Hi, I'm a lowly electrician trying to make my life a bit easier. I have an access 2003 database that contains details of electrical installations. Each...