Recent content by JayAndy

Hi I have a Form with a Crosstab in there. Is it possible to use VBA to grab what is the active column (Field Name) is when you click in it. Thanks

Thanks Error Handling is in there. Error l get is Error 429: ActiveX component can't create object No code on the other DB just opens a display form. Have put in message boxes and the problem is the above code. Have Option Explicit to the top and run Complie runs start through.

Thanks CJ_London Have tried Removing the () and are still getting the same error. In answer to your question, sorry, yes; the terminology is wrong. There shouldn't have been a DB. We are using Access 2016 to build the database and Microsoft Access 2016 Runtime to run it. It works without any...

Thanks JHB but still the same problem and error.

Hi I am using the below code to open another Access Runtime DB Dim accapp As Access.Application Set accapp = New Access.Application accapp.OpenCurrentDatabase ("C:\IAS\Txing.accdb") accapp.Visible = True "I am getting the error saying Error 429: ActiveX component can't create object" Can...

Thanks Static but still only does the top files in the path.

It was the comments of the person how created it.

Hi All I'm trying to get a piece of code together to run through folders to see which ones haven't been used in a long time. I have managed to find and change a piece of Excel VBA code below but only gives me the information for the top files. Anyone have an idea of how to run it so it gets me...

Hi Everyone I am trying to export the data l have filtered in the Spilt form but can't find how to do it anywhere. Some of the fields that l wanna export are not visible in the top half but are visible in the datasheet at the bottom. Does anyone know if this can be done.

Thanks for your Reply have Tried that and Put a Left join on there and can edit it in the Query designer but still get the same error message

Hi All Im am trying to edit this record set but keep getting: Runtime error 3027 Cannot update. Database or Object is read only. This is code l am using. Dim db As DAO.Database Dim rst As DAO.Recordset Dim StrString As String StrString = "SELECT Timein.ID, Timein.[Employee Name]...

Thanks but when VBa does like "' AND MyDate = #" Part and comes up with error: Complie error: Expected list separator or )

Hi All The below syntax l have created from the information on the web but still get a Syntax error. DLookup("ID", "Bill", "Customer = " & Forms!Bills!Customer _ & " AND Date = '" & Forms!Customer!Today & "'") What am l doing wrong. Thanks

thanks it works now!!

Thanks tried that but still print the form