Search results

I have a form set up with a query as its control source. When I enter information into the form, it is supposed to update the query, and when I click a created "Save" button update the table. This way multiple users can work in the same tables, forms, etc... at the same time. This has worked...

I am trying to run a report to output information from a field with a lot of characters. I am using string manipulation to get the information I want from the field which is in a table. Also, the key is located in the table and i need the code to find a specific key, then return the information...

I tried to get a picture up, but didn't have any luck. So, here is basically what I am trying to do: Text Box 1 Text Box 2 Text Box 3 Text Box 4 Text Box 1a Text Box 2a Text Box 3a Text Box 4a Add New Record Button Submit Button The...

I am trying to make a form with 4 text boxes for entry. I want to have the first text box be filled from a reference to a field in a table. The rest, I want the user to fill out the information. Also, I want a button at the bottom of the form to add a new record and fill the first text box...

Linking was the issue thank you very much for your help. I found the problem. I had to link the tables on the front end of the database. I appreciate your fast response!

Hello, I am adding another database to an Admin database I have created to be able to control the accesses of all the databases from one central database. When adding this new database, everything is the same as the other databases of the same type, but for some reason it cannot find the table I...

Thank you so much! I actually ended up making a new form with a query attached to it that pulled the information and restricted the query with the employee code. Then opened the form on double click. It worked well. Thank you again.

I realize that this is a beginner's question, but I was wondering if anyone had any suggestions. I have a continuous list on a form and I want to be able to double click on a name and pull up the profile's accesses. The primary key would be the employee code and since it is a continuous list...

It did work. Thank you very much! It isn't numeric.

Okay, unfortunately, I am having another problem. For the DptCd, I am still getting an error of "Data type mismatch in criteria expression" when I try to filter by the department code. It is a numeric value. I created another text box and changed the Format option to "General Number," but I...

Thank you so much! It worked perfectly. I really appreciate your help!

Thank you for your quick response. Now I get a syntax error in the line: Me.Filter = "[Name] Like " & Chr(34) & Me.Text32 & "*" Chr(34)

Hey, I am a novice with coding for Access 2007. I am trying to filter a form using Me.filter. Here is the code I'm using. Option Compare Database Private Sub Command34_Click() Me.Filter = "*" & [Name] = "*" & Me.Text32 Me.FilterOn = True Me.Requery End Sub Private Sub Command35_Click()...