Search results
-
M
Query not combining and filtering values based on a form
On my Log On form (frmLogOn) I have first name, last name. Don't I also need to include the uPassword field as well? So I have the two tables, the Log On form, I added the six hidden fields to my switchboard, and I added all the code in step 4 to the On_Load event of the switchboard and... -
M
Query not combining and filtering values based on a form
On the Log On form I just have the fields uFirstName, uLastName and ueMail? Can it just use uFirstName and uLastName? -
M
Query not combining and filtering values based on a form
So I need to create a Log On table with a form of it's own? Is that different from the tblUsers? -
M
Query not combining and filtering values based on a form
Is that what mean by: If so, then I don’t. Is that what you mean at the end of the page where you say to create a Form to manage the information? -
M
Query not combining and filtering values based on a form
I was trying to implement a security function on my db. What I was hoping to have was three levels of users. An admin group that have full access to do anything, a user’s group that can input/edit/delete data and a guest group that can only view data. Would applying your Control Form give me... -
M
Query not combining and filtering values based on a form
Hi Gina, May I ask you something about a Control Form (“Assign Permissions based on Users Level…”) I found on your website? -
M
Query not combining and filtering values based on a form
For some reason I kept looking at the spelling of ModelYear and thinking something is not right. I must have changed the spelling back and forth ten times with and without the underscore :banghead:. But couldn't figure out what was wrong with it. And I need to pay more attention to the... -
M
Query not combining and filtering values based on a form
I can't believe it Gina! I spent most of the day today trying to fix it (and failing) and it took you all of about 2 minutes to find and fix the problems! Thank you. Would you mind telling me where I should look for the problems I had in it? Were they in the code or the query or mis-labeled... -
M
Query not combining and filtering values based on a form
In the form frmMYCustomerProgram there are three combo (Model Year, Customer, Program). Program and Customer seem to be working. I say seem because I'm not sure if it's just that the data just happens to line up or if it's really linked properly. Model Year is the one that's not working that... -
M
Query not combining and filtering values based on a form
I'm sorry I wasn't more specific. The query is the basis of a form that uses combo's and filters results. Like the frmMultiSelect form that you helped me create. Like I said I think I'm very close to making it work. -
M
Query not combining and filtering values based on a form
Thank you Gina. I know the naming convention is totally off. I'm doing this with someone else so I don't really have any control over that.:o This is the sql of the query: SELECT [Packaging information charts - Copy Of].OEM, [Packaging information charts - Copy Of].Program, [Packaging... -
M
Query not combining and filtering values based on a form
Hi Gina, I know I've asked a lot of you but I was wondering if I may ask of you to look at a query I'm trying to make work? Or should I start a new thread? It's very similar to the two queries you helped me create on this thread. In fact, I'm modeling it right off of those queries. I think... -
M
Open subform to specific records based of off input from combo boxes
I finally got it to work! Yes, I need to clean up the db, sort things out. Thank you vbaInet for your help in guiding me throught this. -
M
Open subform to specific records based of off input from combo boxes
I know, sorry for the confusion. This has been a long and windy thread. I'm sure the code works (and I have properly given credit:)). I guess, like you said, I just need to sort out which Program field it looks for and figure out if my Row Sources are correct, then it should work like it was... -
M
Open subform to specific records based of off input from combo boxes
OH!!! I see know. When you click the Open button the form it opens is filtered to that lines criteria. I understand know. But that was how it was set up to begin with. What I was trying to do was to filter the records on that first form. bc there are eventually going to be hundreds of... -
M
Open subform to specific records based of off input from combo boxes
I redownloaded the db you posted and I've attached a screen shot of the form, it's still the same. I'm not sure what I'm missing? :confused: -
M
Open subform to specific records based of off input from combo boxes
I'm really sorry vbaInet, I'm sure I'm missing something, but I can't see any difference in the forms. I've attached an updated version of the db. The form name is Program Customer ModelYear. Customer and engineer filters seem to be working but not all Programs are being filtered on. For... -
M
Open subform to specific records based of off input from combo boxes
Okay, understood. Thank you vbaInet. -
M
Open subform to specific records based of off input from combo boxes
vbaInet I’m sorry I don’t know how it happened that Allen Browne’s credit was left out of the code. Please know that I would never do something like that intentionally. I was working on the code, copying and pasting and changing this and that trying to get the code to work and somehow it got... -
M
Open subform to specific records based of off input from combo boxes
Ok I have attempted creating a filter on the form. It is not filtering on the selected field that you choose. Whenever you choose a value and click filter all the records go away. The form name is 'Program Customer ModelYear'. Would someone please take a look at it and tell me what I'm doing...