Search results

! more thing is can it be done in this way like morning before 12pm when people login to the database and it prompt up a msgbox "Good Morning" then after 12pm login people it'll prompt "Good Afternoon" and so on... Can it be done?

Great I'm also looking for this.. What if my delete is in the form then i attach a subtable to it, how would i delete the selected record on the table? Sorrie to interupt...

Hi, I've a access database and a excel worksheet how do i link them together? (Example: At the database use a command button click and it'll prompt out the excel worksheet..

Wayne, If you saw this msg please tell me whats wrong is my code?

What's wrong with this code? Howcome still got error? Code ________________________________________________ Dim SQL As String SQL = "Update Table1 ([Password],[Level])" & _ " IN 'G:\Documents and Settings\IA_TRAINING01\My Documents\odbc.mdb'" & _ " Set password = '" & Me.Text5 &...

Hi, I wanna do a text box that whenever you update the data it'll show the last date of the data that u key in. Can this be done?

Wayne, Dim SQL As String SQL = "Update Table1 (" & Me.password & "," & Me.Level & ")" & _ " IN 'G:\Documents and Settings\IA_TRAINING01\My Documents\odbc.mdb'" & _ " Set SomeField = '" & Me.Text5 & "' " & _ " Where level = '" & Me.Text0 & "' And " & _...

wayne, ok thanks alot.. I go and try get back to u later

so this command will auto edit the password... And it'll reganise the user also right?

I also wanna do this but data in the database is all password that it only cannot be seen by other person so i've to do this. I've got the entering and the registering and nw i just want to know the code for editing

wayne, i still dont get you the code that i ask for is to add the id and password to the other database table and how do i get the data and edit from the other database?

then how about if the user wanna edit the password how?

so the command above is for editing?

Hi wayne What if i wanna edit the password or level?

Does anyone know about the error?

wow its work.... But if i wanna delete the record or edit the record? how? And also i fi nv key in anything it will pop up an error where do i add a msgbox or command to let the person noe that the textbox must b key in.. I also add two labels, 1 & 2 if regsitering label1 is visible after...

here is the attachment for the above problem i wanna know when i type text in the textbox in db2 click on the button it'll transfer the text to the table in db1. Please help, urgent!

Hi I'm new to access, My problem is i got a form with 2 textboxes and 1 command button on it and also a table with fields "password", "level" on the other database. What i wanna know is whenever i insert data into the textboxes and click on the button it'll add a new record on the table in the...