Recent content by scottfarcus

I am attempting to develop a dynamic query capability in one of my databases. tblStaff: a list of staff names in one table (StaffID key) tblCars: a unique list of Cars (CarID key) tblStaffCars: a list of Cars owned by staff (StaffID, CarID combo key) tblComputer: a unique list of computers...

After almost 10 years developing MS Access applications for the government, I'm attempting to write an effective resume to begin my job search. I've single-handedly designed, tested and implemented over 40 small to medium sized applications to handle everything from classified document...

DoCmd.RunCommand acCmdNewObjectReport DoCmd.RunCommand accmdnew

I am using the common dialog API sampled here. Users are able to link a powerpoint file to each record in my database. I store ONLY the filename because the database (and related directory) can change location depending on the installation location. I later concantenate CurrentProject.Path &...

probably the most impatient "poster" on these boards. I'll be surprised if you get help...

Use the attachment (credit to whomever first posted it here - it wasn't me) to find code that does what you want. I'm sure you're capable of making the form and the buttons.

My users select from a combo box one or more criteria. The criteria are numbered 1-20. Typically, the user would need to select 1, 4, 5, 6, 10, 15, 16, 17, 18, 19, 20. It is somewhat frustrating for them to continually scroll thru the list when they add new records. What I'd like to do is...

I have a database that stores reports (both the path and the actual document) and a form that displays the report list showing the doc. When I dbl-click the OLE box to open the report in Word it works perfectly. However, when I move to any other control on the form, the document closes in...

g, fScanDirSelectFileFromCombo displays the *files* inside the drive or directory. I would like it to also display the *folders* inside the drive or directory. I don't believe it can be done, but thought I'd ask. Thanks!

Can it display a list of the folders in the directory as well?

Audit Trail works beautifully, thank you! Simple, but very effective. However, can anyone provide a solution to this issue: When updating data in a combo box (Autonumber field as the bound column) what is the most efficient way to alter the Audit Trail so that it reads: Changes made on...

Perfect. Thank you.

Can someone explain to me, in plain English, how linked tables work? I have been developing split database apps for years, but lack the verbiage to explain to end-users how the linking functions. Thanks!

I am using the following code in my database to send out an Outlook Meeting Item. As it is now, the message is sent to the right people, but appears as a normal message instead of an invitation, ie. they cannot reply in order to accept or decline. I would like to be able to receive responses...

I've had the same problem. Sorry I can't provide a solution, but hopefully we'll find an answer here...