Search results for query: *

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.

I created a new Access database and put it on our network drive. All users have Access 97 and Windows 98. One user (the one that critically needs to use this database of course) can open the database, and use it until they click on any command button. When they do that, they receive an error...

Hi, I created an Access database in Office XP and converted it to '97. After I copied it to the Office '97 machine (running Win 95) and tried to open it, I got a "MSAccess caused an invalid page fault in Module MSAccess.exe at 014f: 300099cd". Then, Access closes and the .ldb file...

Hello all, I have a display only form. I would like users to be able to click on a command button and open another form (same form basically, but in data-entry mode) to add a new record. I need to pass some of the data from the display-only form to the data-entry form. I have been able to...

Hi Josh, This code is run on the Main Form. It is supposed to execute on the After Insert Event in the form properties. You are correct - there is not a subform. It is entering a new record in the second table if the criteria is met. It executed perfectly before we changed to datasheet view.

I have a form for entering new records in a main table. If certain conditions are met, it creates a new record in another table (child). The second form is a simple one - it is just an auto-number field and another number field [Rail Entry] that references the record number of the first table...