Search results

My first time using this database as my coworker has fallen seriously ill and I am unable to ask them for help. There is a query that is supposed to translate a text value into a date value. The value for the date is written in a 1yymmdd format in the file/table being used. The following is...

Hello, I have yet another database which I have been assigned the task of converting from 32-bit to 64-bit. I have used http://www.jkp-ads.com/articles/apideclarations.asp as a reference to update what I could however since I am not fully sure what the database does outside of importing a file...

I have a database that was created to be used with 32-bit system of MS Access. However the user who currently needs to utlitize this database has the 64-bit version of Office including Access. The user has been having many issues since this upgrade occured. I added the PtrSate between Declare...

The database in question is on a shared network and used by multiple people. The coding has been changed to use late binding due to multiple versions of Access being used to utilize this database. One of the users is receiving the following error message: The line that shows up during the...

Back story, I have a query that needs to be run for 14 day days back (the data shows as a number not a date for the aging) when ran Mon-Thurs, on Friday's it needs to have all of the data. Currently I have: Field: Date() = "Friday" | TotalDaysAged Criteria: False | <15...

I need to make changes to expressions in a query that is currently up and running. However the data that needs to be summed in the expressions has grown to the point where access gives the error message that the expression is too complex (see full expression in first code set). To work around...

Run Query B with varible input from query A, export to excel > repeat for all query A I am looking for the vba to have a query cycle through using records from another query as the parameter run and export for each of the records on the second query. :confused: Table 1 has information with all...

Hello, I have been snooping around the site for awhile now and normally am able to find the advise that I have needed. Currently working on a project that seems to be simple enough however I seem to not be wording my question correctly in oder to find the answer so decided to create a profile...