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...
Changed Function LaunchCD with FunctionGetMyFile and changed LaunchCD (ME) under Browser1 (x) to GetMyFile (1) and it worked.
Sub Browser1(X)
Dim strPath As String, FilePath As Object
Select Case X
Case 1: Set FilePath = Me.txtFile
' Case 2: Set FilePath = txtFile2
' Case 3: Set...
I do not use the API calls on any of the databases that I normally work with or create. However doing that for this one would mean re-creating the entire database and since I am not aware of its full purpose it seemed more logical to learn how to update the coding. Also since there are a few...
I am not sure how many versions of MS Access are using this database. Currently I am trying to update the coding to work with 2013 64-bit. I am not proficient in VBA and have not delt with API Functions until I was asked to help with these. Due to how this is written I haven't been able to...
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...
Updated code that works:
Option Compare Database
'Private Type BROWSEINFO
' hOwner As LongPtr
'pidlRoot As LongPtr
'pszDisplayName As String
'lpszTitle As String
'ulFlags As Long
'lpfn As LongPtr
'lParam As LongPtr
'iImage As Long'
'End Type '
'Private Declare PtrSafe Function...
I am on a work computer using 2013, I am unable to download an exe file to view the suggestions.
I have been looking on google as well and have found anything in reference to the area that I am getting the complie error message.
I was actually looking at the Declaring API site earlier however...
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...
It just gives the same error message. There are other users that are able to use the database without issue with the same version of Office/Access as the user having the issue.
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...
The SQL is a bit lengthy as there are many fields actually being used.
The part I was referring to is:
HAVING ((tblImportNetworkEMC.InternalAge)<15) AND ((Date())<>"Friday")) OR
((tblImportNetworkEMC.IntLastType)="DLSI") AND ((Date())="Friday"))
So far that is working. Date is in the dddd...
All of the dates recorded are the dates in which the events happened.
I have tired adding a field Date() with the format of dddd. However when I try put in for that field to = ("Monday" Or "Tuesday" Or "Wednesday" Or "Thursday") and "Friday" on the second line the query comes back blank.
I...
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...