Search results

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

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

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.

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

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

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

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

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!

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!

Thanks for your help! This corrected the problem.

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

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

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

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

Thanks!

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

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

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

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

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.