Search results

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

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

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

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 am automating the creation of a spreadsheet using data from my db. The data "merge" works beautifully when I run the code for the first time. If I attempt to run the code a second time within the same session, I get two different errors. Errors: 1) #1004 - Method 'Cells' of object...

If I set a reference to an object library and then distribute the application to other machines that may not be running the same version of some application, will errors occur? For example, I have a reference set to Microsoft Excel 10.0 Object Library. If I give this app to someone running...

I am using a treeview in one of my forms. It works beautifully, with one exception... I would like to use the tree view to update an underlying table after all adjustments have been made. I would like to update: ThreadText with Node.Text ParentID with Node.Parent.Key and InitialThread with...

Is it possible, in Access, to fire an event when a record is inserted into a table? I know I can do this via a user form, but without a form?

I am building an application that has the ability to export some data to MS Project in order to produce a Gantt chart view of a set of records. In order to do this, the database must have a reference set to the MS Project object library. This works beautifully on my machine, but I'm afraid...

I seem to remember hearing that there was some VBA or an API that I could use to remove or hide the Access symbol from the top-left of each window and replace it with my own icon. Does anyone here know how to do this?

I have an XP database that performs a Word mail merge using automation. The merge uses a common text file (stored on the root C: drive) as the data source for the template. This merge works perfectly on any box running anything other than Windows XP. When you try to execute the following line...

I am using some SQL statements to create and update records in my app. If I enter a subject such as, "I'll be out of the office all week." into a record, an error is caused by the apostrophe in the word "I'll". How do I avoid the error while keeping the ability to use apostrophe's in my...

Please help! I have tried all the instructions from this site (http://support.microsoft.com/default.aspx?scid=%2fsearch%2fviewDoc.aspx%3fdocID%3dKC.Q295824%26dialogID%3d1550125%26iterationID%3d1%26sessionID%3danonymous%7c1372837) and still have the following problem. When I try to attach a...

Is it possible to display a report in a subform? Can I set the source object of a sub form to a report?

Can anyone help with some Access automation? Here is my code... ' Initialize string to database path. Const strPath = "C:\My Documents\" strDB = strPath & "Test.mdb" ' Create new instance of Microsoft Access. Set appAccess = CreateObject("Access.Application")...