Search results

I need to check the recordcount in a subform of a navigation frame form in VBA. Anyone know the proper syntax. I have tried multiple things but cant seem to get it. I would rather not use dcount.

Right after I posted this the light bulb turned on in my head. I changed the column in the table to a lookup field and referenced the id field. Then I exported the data to excel and copied the numbers back into the column. I then changed the parent/child relationship to reference the id field in...

I am kind of new to Access and VBA so please bare with me. When I originally created my access database, I used a text field/column to connect 2 tables together. I would like to change this to reference the Primary Key/ID column instead of the text field. Is there an easy way to go about doing...

I copied what you said it should be and the query changed it to this: =DLookUp("property","tblwoOption","[userid] = " & [auth].[userid]) When I try to run the query, I still get the Enter Paramater Value box.

I am trying to run a query and filter it by the current authorized user id in my database. =DLookUp("property","tblwoOption","[userid] = #" & auth.userid & "#") auth.userid is in a class module that should show the current user id number and for some reason it isn't working. When I try to run...

I added the double quotes and it is still shiowing the same error. I am confused on where to added and change the quotes.

I am trying to Run an Append Query using VBA. I cannot seem to get it to work. I am getting syntax error when I try to run it. Can someone take a look? Private Sub cmdloaddefault_Click() DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO tblschedule_lineitem ( labor_name, shift, location...

This is something that I checked a few times when it was happening. Its set to "For Dates" on all Date fields.

I copied the form, query and table to a different computer and the problem stopped. Both are running Win 7 with Access 2010. Not sure why it works on one and not the other.

I am having the same exact issue. Anyone have any thoughts?

I didn't realize this event existed until you told me. I have already made the code and implemented it. I will keep it in mind for the future. Thanks for the examples.

Thanks for the reply. I came up with a code that will do what I want it to using DCOUNT. It seems to be working fine. See below. Private Sub cboreason_AfterUpdate() If IsNull(Me.cboreason) Then GoTo procedureexit End If Dim recnum As String Dim sql As String sql = "Insert into...

I am trying to check if a value that is entered into a combo box currently exists in a table, and if it doesn't then I would like to insert it. This is the code that I have come up with but I can't seem to make it work. Any help would be great. Private Sub cboreason_AfterUpdate() If...