Search results

  1. C

    Two or More Users Can't Open DB at Same Time

    I finally got the database to open on 2 different machines at the same time. I had to go into Add/Remove Programs, select Microsoft Office 2000 Professional and click on the Change button. Once the MS Office 2k setup screen loaded, I clicked on Add or Remove features. From there, I selected...
  2. C

    Two or More Users Can't Open DB at Same Time

    No one else has the db open. Also, when I am using the database, there is a .lbd file that is created for my front end and a .lbd for my back end. I'm the only one using the database. If I leave the database open on my computer and then try to open the database on another computer, that's when...
  3. C

    Two or More Users Can't Open DB at Same Time

    Rich, I made the changes that you suggested, but I'm still experiencing the same problem. So far, the only way I've been able to have 2 or more users run the program is to give each user a copy of the front end. This is not what I really want to do, but at least it works.
  4. C

    Two or More Users Can't Open DB at Same Time

    Everyone should be able to add, edit, and delete files for this directory. I've tried testing this with two different databases and I am experiencing the same problem I have my database split so that there is a FE and and BE. I have also checked each computer to ensure that the Default Open...
  5. C

    Two or More Users Can't Open DB at Same Time

    I have put a database out on the network so that multiple users can add, edit, or delete record. If I leave the database open on my computer and then try to open the database on another computer, I get a message that says someting like "The database has been placed in a state by user 'admin'...
  6. C

    Running Access with 56k Connection

    We're thinking about having our regional field offices run an Access database over the network. The users will be dialing into our network with a 56k connection. All the forms, reports, tables, etc.. will be located on our network. Can anyone tell me how good/bad the database will run over...
  7. C

    Determine if Form is Open

    Thanks to both of you for helping me. I tried ghudson's explanation first and it seems to be working.
  8. C

    Determine if Form is Open

    I'm receiving an "Application-defined or object-defined error". This is the code I'm using: If [Forms]![Form A].IsLoaded = True Then MsgBox "IT WOKED" Else MsgBox "TRY AGAIN" End If Do I have something wrong? Thanks for your help!
  9. C

    Determine if Form is Open

    I have two forms open at the same time, FORM ONE and FORM TWO. FORM ONE is invisible. FORM TWO is visible. If I click on a button on FORM TWO, what code whould I need to use in order to determine if FORM ONE is open? Thanks!
  10. C

    Add Item to List Box on Form Load Event

    Thanks for your help! This corrected the problem.
  11. C

    Add Item to List Box on Form Load Event

    The RowSource is a Table, but I do not want to add this record to the table for other reasons. I could remove the table name from the RowSource and replace with this query: "SELECT CountyName FROM tblCounty ORDER BY CountyName;" Can you give me an example on how to append the data? I'm...
  12. C

    Add Item to List Box on Form Load Event

    I've got a list box on my form that is populated from data located in one of my tables. I would like to be able to add an additional item to this list box for the user to choose from whenever the form is first loaded. This should be simple, but I am not very familiar with VBA. Can someone...
  13. C

    Passing WHERE Statement with DoCmd.OpenReport

    Thanks! I didn't think this all the way through.
  14. C

    Passing WHERE Statement with DoCmd.OpenReport

    I am trying to pass values selected from a list box to a report named 'CountyReport'. In my report, I have the following statement as my datasource: SELECT [suggested-build/site].project_id, [suggested-build/site].[req-build_name], [suggested-build/site].[req-county], Project.project_mgr FROM...
  15. C

    Combo Box Defalut Value Question

    Thanks!
  16. C

    Combo Box Defalut Value Question

    On my form, I have a Combo Box. In the On Current event for the Form, I have the following code. Private Sub Form_Current() Me.cmbProjStatus.Value = Me.cmbProjStatus.ItemData(0) End Sub The combo box has two value, ACTIVE and INACTIVE, that the user can choose from. This piece of code...
  17. C

    Combo Box and Data Sources

    Setting the column width corrected the other problem. Thanks to evereyone for helping me out with this !
  18. C

    Combo Box and Data Sources

    I changed the Column Count property for my combo box from 1 to 4. This seems to have to corrected the problem. Everything seems to be updating correctly now. I didn't know anyting about the Column Count. I do have one slight thing that I need to correct now. Originally, my combo box only...
  19. C

    Combo Box and Data Sources

    I'm not exactly sure what your are asking. When I created the combo box, I used the wizard. I chose the user name to be displayed in the cobo box. After creating the combo box, I modified the query so that it would also return the address, city, and state. Attached is a zipped copy of the...
  20. C

    Combo Box and Data Sources

    I tried everyones suggestions but none seem to be working correctly. For some reason, I only receive data for txtAddress no matter what type of code I am using. I ran the query that I am using to populate my dropdown list to make sure it is returning data for all the fields.
Back
Top Bottom