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!

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...

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...

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...

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...

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...

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...

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...

Hi, I'm trying to use Dlookup in a form to find the closed date and time of the previous record. This is the syntax I'm using. =DLookUp(" [MainTable]![PullDateTime] ","Main Table","[MainTable]![ChargeNo] = [LastCharge] ") LastCharge is a hidden field that...

I have a "Main" table that is related to six other tables by the PropertyID. I'd like to have a delete button on my form that would delete not only the record in the Main table, but also in the other 6 related ones. Any ideas on how to do this????