Recent content by dnrhymer4

I now have this, but it's still not writing to the table: Private Sub Account_Number_Change() Dim strSQL As String If Me.Account_Number = DLookup("[Budget Account]", "Account Number Dump", "[Manager] = '" & Me.Manager & "'") Then Else strSQL = "INSERT INTO [Account Number Dump] (Manager, [Budget...

Yes, both are text fields

Hi Folks, I need some help. I have a form with a combo box bound to Table 2. I am trying to write an Insert Into Statement that will add the value to Table 1(Account Number Dump) in the On Change event. I keep getting Error '3134' Syntax Error in Insert Into Statement. Can anyone tell me what...

Awesome. Really appreciate it. I thought I did split it? I created a backend with all my tables and then have a front end which I stored in the shared folders for users. I'm new at this so I'm sure there's some step that I've overlooked.

Yes I do. Is there anything I can change to prevent it from happening again?

Yes, it is split. I was doing some work on the front end this week, mostly cosmetic stuff. But I never used that table or query while I was working on it, so I'm really not sure.

Great. Thanks :).

Hi All, I'm a little stumped with this one. I have a table showing all my fields in English. I then created a query based on this table. For months now, it's been working fine. Today, I went into the query and one of the fields is showing in Korean? I've tried to delete it and re-add that...

Figured it out. My DLookup was looking at the wrong field. Thanks for the help!

Yep, but I have no idea why it's only working for one manager. If I select any other manager and enter the password, it tells me the the password is incorrect.

It's only finding the password for one manager. The macro opens another form while applying a filter.

There are reports that are also filtered by the cboManager that everyone has access to. I'm only trying to limit access to the data entry.

Hi, I'm trying to require a password using an input box in order to enter a form. I have a table listing the managers and passwords. I've pieced together some code. The problem is that it will only open for one manager. Any help is greatly appreciated. Private Sub...