Search results

If you are looking for database structure suggestions, this is how I would set it up: tblJobs fldJobID (autonumber) fldDate fldLocationID tblLocations fldLocationID (autonumber) fldDescription tblWorkers fldWorkerID (autonumber) fldWorkerName fldTradeID fldPreference tblCrews fldCrewID...

Yes you are right and all of the machines are set-up that way but the error continues to randomly occur.

I was getting this "error" message as well. When I looked at the .ldb file with NotePad I noticed that it listed 2 users working on the database even though only one had it opened. I tried editting out the second users name but couldn't save the file. I later saw that if I opened the db with...

This may be a poor work around but you could create a table "Globals" in your first database. Link your second database to the "Globals" table. Have your first DB write the variables to "Globals" and then have your second DB pick them up from there. :confused: HTH, Jeff

Not sure this is what you are looking for but my shortcut target looks something like this: "C:\Documents and Settings\All Users\Documents\Data Server\EMR.mdb" /runtime /wrkgrp HTH, Jeff

This should get you on your way to your answer. 1. Create a bookmark that encompasses everything on the second page. Name it "SecondPage". 2. To delete it, use this code: objWord.ActiveDocument.Bookmarks("SecondPage").Range.Delete HTH, Jeff

There's a better way to skin the cat... In my search for an answer to the above post, I found a better way to merge Access data into a Word document. Initially, I changed the above code to... On Error Resume Next With WordApp.Selection .GoTo what:=wdGoToBookMark, Name:="Full Name" If...

In case it helps somebody in the future. The "bug" described above kept happening. I created a new form and cut and pasted all of my controls from the buggy form to the new form (without any of the VBA code). The bug occurred in the new form. I created a new form AND controls from scratch to...

I'm merging about 10 strings from a form to a number of different Microsoft Word templates. The problem is that a particular template may not need all 10 strings and therefore doesn't have all 10 bookmarks. I get an unexpected error if a particular bookmark doesn't exist. My code looks like...

Nope not a modal form.. but thanks for thinking about it.

Is there a way to detect when the user has resized the main Access window? Thanks

I've started having this error today. I've complied code and compacted the db and it is still occuring. I also have to perform an End Task via the Task Manager in order to get out of Access. Any help would be welcomed.

Dont know, but I was glad to get rid of the problem by combining. It's a bit tougher to work on the program without a front end to tweek but the performance issue is a no-brainer.

using 2000 on an XP home peer-to-peer network

My experience: Started with a front end (application)/back end (database) configuration. Got bigtime delays. And very inconsistantly so (sometimes response was quick, other times very SLOW). Three days ago I combined front end and back end (based on suggestions from this forum) and speed is...

Never Mind I solved it by adding the /runtime /wrkgrp to the end of the shortcut. Thanks anyway, Jeff

I have searched the archieves and (even though there is a lot of information about multi-user issues) I cannot find a solution to allow more than one user to open the database. I am using Access 2000 on a 3 computer peer-to-peer LAN. All PC's use Windows XP Home. The mdb database is located...

try this: .Selection.Text = (CStr(Forms!HumanResourcesForm2!NeoNateInfant & ""))

I'm glad that others are finding success with this code, but it not opening my CD-ROM tray. Perhaps it is a hardware problem on my end. Thanks for the input R. Hicks.

I've written code to prompt my end-user to back-up the data on a CD-RW. I present a dialog box "Please place the CD-ROM "Back-up Tuesday" in the drive." I think it would just be cool to then have the drive tray open prompting the user to enter the disc. (I other words... just because) :D