Search results

so as soon as i think i was finished with my database, im going through some final testing and i got an error with less than 24 hours to finish. the error is on the highlighted line...HELP!! the set warnings command works on every other form that i use it on but not here for some reason...

i have multiple reports that just wont open. i have tried calling them from a form, calling them from a switchboard, not even clicking on them in the navigation pane works. the only way i can get them to open is going into design view and then switching to report view. MESSED UP!!

Hello all, I have a form that is directly connected to a table. The form is used to search and gets populated with two values (table_name, _number_of_records). Basically, when the user searches in this form, i search the entire database for relevant data and return what table and how many...

I want to create a way to search through the entire database for records that have all or part of the keyword that the user enters in ANY field of ANY table. i have a DCount() function in there as well to show the user how many records are in each table. from there they would click a button...

Good Morning/Afternoon/Night (wherever you are) I am getting this error when i attempt to run this code and i am not sure what is happening????? i dont see any errors with this. Dim txtAcc As String txtAcc = SELECT Employees.Access_Level FROM Employees WHERE Employee_ID = XXXXXXXX)help please:)

Good day Developers! - again lol Question: is there anyway to create a form that will search EVERY table in my database and return the amount of records in whichever table it was in? if that is possible i want to create that and then have a way to direct the user to one of those selections.

Good day developers! Small question. I have a table with employee names, ID's, etc. When an employee logs in, i take the username from that table and put it into a global variable so i can use it in my switchboard (well at lease i am trying to use it in my switchboard). On the bottom of my...

sorry if this has been asked already - I have a db that, on opening, prompts the user to check any expired (or soon to expire) documents via text box. if the user clicks no, nothing happens, if the user clicks yes, i want it to go to the switchboard page that the soon to expire documents is...

sorry if this has been asked already - I have a db that, on opening, prompts the user to check any expired (or soon to expire) documents via text box. if the user clicks no, nothing happens, if the user clicks yes, i want it to go to the switchboard page that the soon to expire documents is in...

Good Day all, so here's the thing...I am using access 2010 and i want to password protect my database by user. there will be about 10-15 users(maybe that's just what I'm assuming). i want certain users to have access to everything, and certain users not to have access to one form which is...

I have a database (access 2010) and a few weeks ago i set up a password by doing the whole open in exclusive thing and setting the password). the problem is now, i cannot remove the password. when i go to the same section in exclusive view, only encrypt database is there and no option to...

Hi all, I currently have a table for employees which holds the first name, last name, id, password, and their access level to the database. basically what i want to do is - on start up - have the user enter their employee number and their password. i have the input boxes set up already in...

I have created a form which displays data from three joined tables. the form displays the data based on one table using a sort of reference number (ex 1.01, 1.02, 2.01, etc.). The other two tables display the data from the rows that have that reference number attached to is (using a drop...