I have a database with several tables (tblONE, tblTWO,...) Table tblONE serves as source for frmONE which is the first form the user enters the data. All...

I use Access 2007. So essentially I'm creating a database that will be updated once a month. Every month a new table will be added to it with the data from...

Hi, I have the following code which would run beautifully in SSMS but I can't get it to run in Access 2007. What do I need to change to make it run? SELECT...

I have around 54,000 rows of data, that consists of a time stamp and temperatures. I need to find the minimum on each day and at what time that occured. When...

I get this error reading, "Microsoft Access can't append all records in the append query... Microsoft Access set 0 field(s) to Null due to a type conversion...

Hi, The table has 3 fields R_ID, Log_Date, Log_Time When I type the R_ID and click the Log Start Button I want the current date and the time to be captured...

I just created a simple table in a data base that compares two test fields within a table and produce not matching rows. The query resulted in very few rows...

Hello all. I'm linking 2 tables, looking for the LATEST date that corresponds to one record, but that record is listed everytime the record is updated.. ...

Since now I can create a backup table and delete the old backup, I have to find a way to "Drop table LIKE Locationsbkup%". I've found snippits of code on...

I have a Start Date Field with data like this: 70109 10102 20502 110102 120503 The conversion of this is Month Day Year meaing 70109 = July 1st 2009 10102 =...

Need to join these 3 queries: Query1: B dp# T1 A 1 4 A 2 3 A 3 7 A 4 8 Query2: B dp# T2

OK, I have two tables, Work Orders and Employees. In the WO table there are several instances where an employee # is required (assigned to, recieved by,...

I need to build a criteria from a date field pulling the criteria from a form and am having some difficulty getting the synthax right I have a form named...

I am trying to create a backup table in my Access program from another application via ADO. I can "drop" the existing table, but am getting a syntax error...

When I create a new query in Access and go to save it I get the error "You do not have the necessary permissions to use the 'MSysTables' object."

Hello. I have a query that is almost working. I am trying to return the # and $ of incidents in business units. I've FINALLY gotten the $ to sum correctly on...

I created an update query (posted below) that I thought was constructed properly. However, it seems to only update according to the first criteria and the...

If the form for my criteria is closed how do I write the criteria to look for the same field name in another form that is open? I placed the 1st option in...

Hi, This behavior occurs when multiple procedures with the same name are in a module.. Look down the whole page of code for the form and I'm sure you will find...

Hi, I would like to add some fields (data) of the same column with reference to the identical time,which is another column.In more detail : My query has two...