Recent content by dots

Hello, Has anyone ever tried SmartList to Go? It is software for Palms and it allows you (supposedly) to sync directly with your Access databases? Thank you!

Thanks anyway, I figured it out. Instead of trying to requery the child, requery the combo box that's in the child.

Hi, I have a main form that contains a subform (child1) which is in datasheet view. The subform is based on a query and all that is on the subform is a combo box for users to select components. If the component is not listed, I have an ADD button on the main form which opens up another form...

After much help from this forum, I was able to create a form that allowed my user to select an image and attach it to the current record. After a few days of using it, my user has informed me that it is not enough. He needs to be able to draw his own images for each record, and he likes to use...

Thank you Roy. I wasn't quite sure what you meant, but you pointed me in the right direction. I added a variable field to my query called MyCount, which Counted the Work Order field. I added a field to my form with the control source of MyCount, and put the following code in the On Open event...

Thank you for the input. Mike: When I tried your suggestion I got the same error message "You Canceled the Previous Operation." Roy: When I tried your suggestion I got the message, "Microsoft Access can't find the field 'Enter Work Order Number' referred to in your expression...

Hi all, I'm pretty sure this has been answered before, but I can't seem to come up with the right "keywords" to find it. I have a button on my form that when pressed, asks the user to input the Work Order number they are looking for. The form (based on a query) then opens to that...

Thank you Roy. It works perfectly now!

I am trying to put a simple search button on a form that will allow a user to enter in a Work Order number and click the search button to go to that record. The code is: Dim rs As Recordset Dim Bkm As String Dim stWorkOrder As Integer stWorkOrder = Me.[SrchWO] Set rs = Me.RecordsetClone...

Nigel, This is a dumb question, but do you put the Me.Recordsource statement before or after the Open Form statement? I've tried it both ways and I can't seem to get it to work. Thank you!

Is it possible to use the same form and change the recordsource to different queries? I have a form that, depending on which button is clicked, the user could look up information by different fields. Do I need to copy the form and change the recordsource to the query they need to use for each...

Thanks for your reply. I think my issues are more serious than I previously thought. Now I am getting an Out of Stack Space error when I try to add new controls to my Switchboard. I'm going to try to copy all my data (except the Switchboard) to a new database.

Hi, I have a form that contains 2 combo boxes - cboCostCenter and cboMachineCenter. cboMachineCenter is dependent upon the value selected in cboCostCenter. There is a Close button on the form. In the On Current event of the form, I have the following: cboMachineCenter.Requery On its own...

Hi, I am new to using Access in a multiple user environment. I have a database (inherited) that will soon be shared by about 8 people for entering work orders. My question is regarding the data entry form. The Work Order Number is not an auto-number field. It is based on another table (WO...

Thanks, I'll have him try some other databases.