Search results

I have a form that is used to enter some data. The record source is a query based on one table. The fields on the form is: ServiceID, SerialNbr, CartStatus, CartDate, CartEvent, CartRepairType, Remarks Ok here is what i'm looking to do. When the user enters a number in the SerialNbr...

Dang you are good!!!! that did it! 'preciate it sooooo much!

ok it work for the Timestamp but as for the UserID here is the code I had Public Function UserName() As String Dim sBuffer As String Dim lSize As Long Dim strAppUser As String UserName = "" sBuffer = Space$(40) lSize = Len(sBuffer) Call GetUserName(sBuffer, lSize)...

for Timestamp will I put Now() as the ControlSource? as for the user name I was using code to capture that which is the user that is logged in at the time.

oh and one more thing. If I want to add the current date and user to the table as well, how would I do that being that I'm using access built in navigation controls. Because at first I had it behind the addrec button using code. I have 2 fields in the table to hold the values called Timestamp...

worked Like a charm pbaldy.....thank you so much for your help!

:confused: Ok, let me try to explain my delima.... I have a form with several text boxes and combo boxes. One of the fields (ServiceID) is picked up from another form. There record source is a query with the following fields: CartID, ServiceID, SerialNbr, CartStatus, CartStatusDate, CartEvent...

Can someone please look at this code and tell me why I am getting the "Object Required" error: Private Sub cmdAddRec_Click() On Error GoTo Err_cmdAddRec_Click Dim rstServices As New ADODB.Recordset Dim fld As ADODB.Field Dim strField As String...

now, i'm going to link them to the SQL Server

ok.....i see it now. Thank you so much for the quick response

i did that and it deleted the table

I want to delete a link to a linked table without deleting the actual table. The tables where linked when the application was designed by another user. So the tables links are pointing to C:\documents and settings\user name\desktop\database name. I want to delete the links to all the tables so...

i think i figured it out......because there are other tables/forms that depends on that table with the list of vehicles. So, now my question is by look at the mdb do you think there is some kinda code can be written that instead of deleting the record we can choose the "Out of Service" status...

here is my compressed mdb.

i'm sorry I'm new to Access 2007 version and I went to tools in Access when I opened the db but I don't see Database Utilities.

it's very weird bc if I add a record and then use the delete button to delete the new record i added it works fine. but when I go back and navigate to an older record and try to delete it the button doesn't work. i get that error.

not sure how to do that.....the db is local it is not in SQL.

Yeah, I've changed my code to this and it's still giving me a "RunCommand action was cancelled" error. Private Sub cmdDelete_Click() On Error GoTo Err_cmdDelete_Click If MsgBox("Are you sure you want to delete this record?", vbYesNo, "Confirm Delete") = vbYes Then DoCmd.SetWarnings...

I'm so sorry...the error was: DoMenuItem action was cancelled

oh btw here is my new code: (but it's still not working) Private Sub cmdDelete_Click() On Error GoTo Err_cmdDelete_Click If MsgBox("Are you sure you want to delete this record?", vbYesNo, "Confirm Delete") = vbYes Then DoCmd.SetWarnings False DoCmd.RunCommand acCmdSelectRecord...