Recent content by candyA25

Can you give an example?

Can someone tell me why I'm getting a run-time error on the line below? I suspect it has something to do with the SQL query I have defined in the variable? Line causing run-time error: Set rs = db.OpenRecordset(MedSelectQuery, dbOpenDynaset) Content of MedSelectQuery variable: strLocalBE =...

Can anyone tell me why I'm getting run time error '3163' on the following line? If DCount("*", MedSelectQuery) > 0 Then Here's the code listed before this: Dim MedSelectQuery As String Dim fso, f As Object Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.GetFile(strLocalBE)...

Believe I found a solution: Dim fso, f As Object Set fso = CreateObject("Scripting.FileSystemObject") Set f = fso.GetFile(strLocalBE) Dim FileCreatedDate As Date If f <> "" Then FileCreatedDate = f.DateCreated Else MsgBox "Missing data in path file --...

Is there a function I could use to find the date listed in the "date created" property of an Access file?

Can someone tell me the syntax for using variables in a VBA update statement? I have the following that I want to use to update a record field. Dim thisTbl as String If Answer = vbYes Then If MedicationInvNo2 <> "" Then thisTbl = "tblMyMedData" Else thisTbl = "tblMedData"...

[SOLVED] How do I open one Access form at a time? I have two forms set to open if the queries listed below have existing records and the SyncData button is clicked. What I want to happen is this: if the first query has records, open the form. After the user is done with this form, if records...

That was it! Thanks!

I have a form with a query set up as the record source. If there are records in this query, the form will display. When the user clicks a button, if there is another record in this query, the form displays the next record. When it gets to the EOF, it should close this form, but EOF is not being...