Recent content by lizI3

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