Search results for query: *

Hi I was attempting to put a new table in my db. We I try to inforce referential integrity I get an error message that another user or process is using the table and to wait until they close. Only problem is that their are no other users or process open. It is a multi user db with workgroups...

Thanks Drctx, but I cannot get the code to work. Iam still a newbie at theis and I don't understand the Chr$(34) When I click my button I get File not found and the Call Shell is highlited Liz :(

I have a shortcut on my desktop with the following code "C:\Program Files\Microsoft Office\Office\msaccess.exe" Q:\VersDataLink.mdb /wrkgrp Q:\DataLink.mdw I wanted to create a new Access 97 DB with a form that would have command buttons so that a user could click on and open...

The database is being used as a interface to another system. Data is keyed into the DB using dropdown boxes and then exported to a text file and imported into another program. Therefore the data is not really being edited just keyed in to the table. The only time it may be edited if the user...

Thanks RJFost I when to tools options Advance and changed the locking option from "no locks" to "edited record" I also make sure that the open database using record level locking option was tick for yes. Is this what you were refering to as "optimistic" locking or...

Hi, We are running a multi user access 97 db from a server. I have set up the workgroups etc. Our problem is that if more than one person is entering into the DB at one time after a few minutes it Freezes. Has anyone else experienced this problem and if so how did you correct it. Iam not sure...

I have two Workbooks Test1 ( the master file) and Test2(for an individuals use) . I have a macro that will copy all files in test1 that is for "LIZ" to Test2 This is my code Dim x As Integer Workbooks.Open Filename:= _ "test2.xls" Windows("test1.xls").Activate For...

Thanks Jfgambit that solved my problem, It work great now, but can you explain to me when you would use the mousedown or keypress or keydown events. thanks again Liz

I'am having problems with toggle buttons in an option group. When you mousedown on an option toggle button it opens up another form. My problem is that I also wanted to be able to use a hotkey with it (alt + g as an example). I put the & sign in front of the letter G and it show the G with an...

How would I write a vba function to sum a changing range in Excel? So that I could call the function anywere in my spreadsheet and it would sum up to the first blank line. I was tring to use .FormulaR1C1 = "sum(" _ & Range(.Offset(-1, 0), .Offset(-1, 0).End(xlUp)) _...

No sorry this does not help . Iam running Access 97 and no Chart wizard. Thanks anyway Liz

Our database is a split DB front end and backend. It is on our Lan to 3 or 4 users can access it at one time. We had to reinstall access on 1 computer, now when we try to open the front end (only on that computer) we get a run time error message 424 object required. The back end opens fine. We...

Hi, Iam having trouble referencing a range in a macro that will copy and paste. If I want to copy b5 formula to C5:S5 (in excel) but later in the macro now want to copy B15 to C15:S15 how do you reference the row number so that it will pick your currect row? Any suggests would be welcome...

I have two questions about how to handle paramenter in a report (run from a query). First - if I enter a paramenter that produces a recordset with no data , how do I stop the report from being previewed. I just want a Message to come up No records for the data specifiec. I was going to use the...

Hi Iam having trouble with a merge doc that I have on our LAN. It is working fine on all computers but one, which will not open the doc stating it is corrupted, and then hangs word. Any ideas how I can fix this problem? Any suggestions would be appreciated thanks Liz

Net use just tells me what is connected and what is not. I don't know the command to connect if it is not already connected. In windows exployer you would go tools - Map Network drives in the drive box you would pick P in the folder you would select I3 asi-001 etc I don't know how to do this...

I am running on a network and and when we sign on to the computer we automaticlly connect to our P:\ database\ drive. I wanted to create a .bat file that would run to check to see if we were connected and if not actually map the connnection for the user. How would I do this? I thought of using...

Thanks everyone very much.. This is very helpful. I agree that I can take this back to work as an official answer.

Thanks Robert, We are running access with less than 10 usere at any given time. Some of the big bosses are not keen on running access with mutli users, but our db is small and kept at approx. 2800 records. I believe SQL server 2000 maybe an over kill. thanks for your help Liz

what is the max number of users access recomends have in a mulit user enviornment? From experience what is the max number of users you would recomend using access for? thanks Liz