Search results for query: *

Got it! it was AllowEdits. DUH :) thanks everyone!!!

nope, that didn't work either. AGHGHGHG! Frustrating :)

With all of these, it keeps telling me that it can't find the FIELD: "Forms" Keep in mind that the button I am using is in the Child_Subform, while the location of the actions I want to take is in the Parent_Form.

Actually neither of those work. Hmm... .says the form name isn't valid

Thanks! and if I want a button in a subform to turn EDITS ON in the parent form, how do I do that? Me!Forms![Search_Inventory]!Edit = True that doesn't work

I have in a subform a textbox that has info in it. I have a button that I want to click, and automatically populate a textbox in a text box in the parent form. Don't ask the reason, it's how the user wants it! :) what line of code will work with this? I have this but it isn't working...

i got it thanks!

set db = DBEngine.Workspaces(0).OpenDatabase("Your Database Path") what is my database path? should i start at the server level ?

Well I changed the field names - and i get no errors, but nothing happens to the data in the table called "Inventory" any ideas?? :) Private Sub ALL_BUTTON_Click() strSQL = "Update Inventory set RECVDTE = #" & Me![DATE_REC] & "#,RECVBY = '" & Me![REC_BY] &...

This is rather complicated to explain, but it's probably pretty simple, actually. I want an administrative form where you can enter the PRODUCT_ID field as the "filter" and then there are 2 fields below it where you can add in info. What I want a button in the form to do is trigger...

OK - I have a form opening with a filter applied. I want to search records within this filter. I want to open up a new search form to search within the previous filter. What code do I need to do this?

Thanks! That did the trick!~!!!

Everythign is almost working great - but I am getting this error when I run it: (i have "lou" and "lou" as username and password) Run-Time Error '3075': Syntax error (missing operator) in query expression '[username] = 'Lou' [password] == 'lou".

cool everything is good so far. how do i make it check the password in the database?

how do i make a password form? that's where I'm getting stuck. Thanks!

yeah, i want only people with a password to be able to open a form. i have a switchboard with 4 buttons - each one opens a particular form, and i want only one of those buttons to be password-protected. the administration button. how can I do this?

How can I add a password to a particular form when it's opened from a switchboard?

how can I get the standard "Search" feature included with Access97 to work with both the Parent form AND the Subforms simultaneously? As it is now, it ignores the subforms! Help! :)

nevermind, i got it. thanks though! Cycle: Current Record

How can I disable the ability to tab into Record 2? I would like the cursor just go to the top of the Tab order again.