Search results

Does anyone know if it is possible to build an access database to track items using a bar code reader? If it is possible does anyone have a program doing this that I could look at? If so please email it to me in a zip file. mark.kelly@pb.com Thanks

Thanks for the help

If I use a combo box to look up a record on a form. Is there anyway to link the navigation buttons to that combo box so that when the records are scrolled the look up combo box info matches the displayed record?

I am using a report to check the status of jos and how long is left t complete them. Is there anyway to program it so that the last line is not blank with (auto number) in the job# field? I tried <>"(auto Number)" and my query came up blank.

Thanks, but noe for a reallt dumb question. Where di I input this code? If inputbox("Please enter password") = Dlookup("[Password]","tblFormAccess") then stDocName = "@open edit information form" DoCmd.RunMacro stDocName end if

If this is my button code: Private Sub edit_info_form_Click() On Error GoTo Err_edit_info_form_Click Dim stDocName As String stDocName = "@open edit information form" DoCmd.RunMacro stDocName Exit_edit_info_form_Click: Exit Sub Err_edit_info_form_Click: MsgBox...

Can anyone tell me how to customize the top of a form to text I want rather than have it say 'main form :form"??

thanks

I have a combo box that brings up a "client ID #" I also have a text box for "client Name" Can anyone tell me how to auto populate the client name once an ID# is picked in the combo box?? any help appriciated.

Is there any way to get hours and minutes?

I am trying to get the total time on a form. The time does not exceed 24 hours and I am using short time for my start and finish. An example is Start time:9:23 AM Finish time:9:36 AM however my total time returns: 23:46 My formula is: =[finish time]-[start time] Any help appriciated

yes I have 2k but I do not know how to use conditional formatting. What would I need to do?

Thanks for the inquiry but I found the problem. The users who pc I was on had the PDF writer set as the default printer. Once I changed that the errors went away.

I want to pull up a form and have the text lines change colors based on how much time is left for the job. The following code will work on a report if I use a "private sub" Can anyone tell me how to make it work on a form? Any help greatly appriciated. Option Explicit Sub...

Every time I try to open or edit one of my reports I get the following error message: "there was a problem retrieving printer information for this object. the object may have been sent to a printer that is unavailable" Any suggestions? Help? the report wont open to print or even to edit..

code Private Sub add_record_Click() On Error GoTo Err_add_record_Click DoCmd.GoToRecord , , acNewRec Exit_add_record_Click: Exit Sub Err_add_record_Click: MsgBox Err.Description Resume Exit_add_record_Click End Sub

edits Yes I am still allowed to edit the existing data

additions no it is still set to "yes"

I have a form that used to work. You fill in all the data and hit the "ADD RECORD" button. before it would change to a new screen to add another record. Now when I click the button I get an error message: "You can't go to the specified record" Any advice? Help? Much appriciated.

Thanks Total time: datediff("n",[start time],[finish time]) Gave me the minutes. thanks for the help