Search results

i have that in my code. it was accidently left out when i pasted the code here

AHH ic yes i fixed that as well. same issue although. Am i going about the wrong way to do this?

alright i fixed the namein the table and the code. as for the edit you made, im not sure what that is. can you please further clarify?

Hi, i have a similar problem with a recordset. I am not the most advanced VBA programer, but this is what i have code: i am trying to get the value from a regular, unfiltered table (the msgbox is justto display the data to make sure it is correct) i keep getting the error "object required" i...

is this a seperate development platform all together?

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

IT WORKED!! thanks!

thanks that sounds like a fix, however im having some trouble implementing it. can someone please advise?

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

ive googled it and apparently there is none. ill do a search in the help anyway

i should have specified im using access 2010

that sounds like a better idea lol how would i go about doing that?

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

alright ill check it out. where do i find that?

I am not new to development,however i am new to developing in access so i am not sure what the SQL of the forms record source is. so where would i find it and how much data would that show? i am working with sensitive materials/documents so there is only so much i can show as for the joined...

I dont believe the search is the problem. The correct number of records return, but only half the values are visible.the date, and one of the numbers returns, but there are 3 fields that do not show up

Dim strFOM On Error GoTo Err_cmdSearchRecs_Click strFOM = InputBox("Please Enter FOM Number", "Search") Me.Filter = "[FOM List].[FOM Section] = " & strFOM Me.FilterOn = True GoTo cmdSwitchButtons_Click that is the new code (well part of it)

Alright, your search code works as well, but i am getting the same error!!!! this sucks (n)

sorry, the "doublet" was a typo from when i copied and pasted into the forum. as for the Enter_FOM_Section, im not quite sure why i did that. it kind of just happened that that is what the box would show when the box prompts the user to enter a value. i shall try your solution

uhm...anybody lol?