Search results

Ok here we go lets try this, Private Sub Command73_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Main Inventory", dbOpenDynaset) If Me.Sai_Serial_Number_1r.Value = "" Or IsNull(Me.Sai_Serial_Number_1r.Value) Then Else...

would i have to do DAO if it is in the same access database? Some sample code to see if im understanding this correctly Dim db as DAO.Database Dim rs as DAO.Recordset Set db = "Sai Inventory" Set rs = db.OpenRecordset("Main Inventory", dbOpenDynaset) With rs .findfirst...

Thank You! exacty what i am looking for perfect!

Ugh, thats not the issue, that just sample code. i just want to know how to open a recordset and update it with a value. I.E. im changing the password on a form how do i update that pasword on the Table.

How Can i do This? can someone post some sample code?

Hummm... So could you post some sample code how that would be done?

Sweet, go bob, go. works like a charm! thanks again!

Lol im so thick i needed pictures to do that lol hahaha. So Do i open the Form, or just set the field in it? if i open the form i see it and its not hidden from the UI. Private Sub Ok_Click() Static LogonAttempts As Integer Dim SaiCurrentUser As String SaiCurrentUser = "" If...

F11 opens and closes the navigation pane

Humm dont see it i should mention that i am working with 07

Here is an example of a password change VBA code in my eyes, i have not been doing this long so please correct me if im wrong. Dim Currentpass As String 'This is the current password Dim Newpass As String 'This is the new password 'At this point you should have 3 text boxes in your form 2 for...

lol posted at the same time bob,a hidden form, thats a good idea, how do i "hide" a form? this will probably be alot easyer on me becaus im still new to VBA.

So My Login screen looks Like This right now behind the "ok" button. this form is called "Login Screen" Private Sub Ok_Click() Static LogonAttempts As Integer Dim SaiCurrentUser As String SaiCurrentUser = "" If Me.Password.Value = DLookup("[Password]", "[User Name]", "[User Name] = '" &...

how do i assign the module to the login button? i see it there but i cannot add it how do i do it?

How do i make a Variable that is specific to a form to a global Variable. i want to save the name of the person who logs in (via a login screen that i made) , so that i can stamp some there activity within the database to that name.

how do i bind it to a table?

I Have a form that has a dropdown of records, i want it to automatically jump to a record on update, um still new to this its probably easy but i cannot figure it out for the life of me. in office 2003 i could select "Find a record based on the value I selected in my combobox.". is there a...

Humm 07 dose not have the Select "Find a record based on the value I selected in my combobox." option i can select the column that i am using as my Unique part id. i get the list but nothing happens when i select an item, if i bind the combo to the column it gives me an error saing i cannot have...

I Have a form that has a dropdown of records, i want it to automatically jump to a record on update, um still new to this its probably easy but i cannot figure it out for the life of me. i attached it here, i would like the Dropdown on the "parts inventory" form To bring up the corresponding part.

Hello i have a Button that Updates quanity on another table the Form that this is on is its Subform. Im having trouble setting my Currentvalue should i use another method besides DLookup sence i have the tables linked by Part Name? still kinda new to this HELP! what is wrong here? Private Sub...