Search results

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

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...

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.

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]...

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

Hi I am trying to click a button on the form that Prints a Report without opening. Below is what l have in the On Click Sub DoCmd.OpenReport "Imports", acViewNormal DoCmd.PrintOut acPrintAll DoCmd.Close acReport, "Imports", acSaveNo It works but also prints the form too, Does anyone know...

Hi All I am trying to change the path of linked tables for my database for training process for dummy data. Whats the easiest way to change the path of all my tables to a dummy database. The dummy database will have the same table names inside it it will just be the path l need to change...

Hi Im trying to make a loop that refers to my text boxs. Im Using Me!Saturday1.Value Does anyone know of a way where l can just change the number on the Me. using a +1 somehow. For Example Me.Saturday1.value for change to Me.Saturday2.Value the text box names are below. Saturday1 Saturday2...

Hi I am trying to get a form to open a new record when its opens but the Form current is running after the open and is not opening a new record. just goes to the first record. Here whats in the Current. If Me!Listbox.Value = "Gym" Then Me.Hours.Visible = True Else Me.Hours.Visible = False End...

Hi I am trying to get access window to pop top the front if an event happen get the below code of the internet. Private Declare Function SetForegroundWindow Lib "user32" (ByVal hwnd As Long) As Long Public Function ActivateAccessApp(TargetFullname As String) As Boolean Dim appTarget As...

Hi Is there any way of finding out in a query or vba the workdays in each month between to dates. so for example between 01/03/2016 - 10/04/2016 so it gives me a Figure of March has 22 and April has 7 in that time period. i have a piece of VBA that tells me how many work days in total.

I am trying to work out a difference between two time from a form. I have a form the people put the Start Time and End Time Then in my VBA l have the following code. Dim Lvalue As Integer StartTime = [Forms]![Time]![Start] EndTime = [Forms]![Time]![End] Lvalue = DateDiff("n", StartTime...

Just Thought l would say Hi and introduce myself I'm Jay and l know some access programming and have been using this site for a bit and thought it was time to sign up. Jay