Search results for query: *

I've built a report in Access 2007 which contains 6 subreports. In Print Preview, all looks fine. In Report View (which the client prefers before printing), the first sub looks good, but the second seems to be overwritten in places by the third, and none of the later subs show at all. The...

I have a form where the data source is a SQL query set dynamically in VBA based on entries in two unbound combo boxes. The query is a one-to-many join that selects one client's data from the one side table and one project's data from the many side table. If I copy the resulting query from the...

I have an HP dv5000 and just had to replace the HD and the screen cable. I reinstalled XP Pro from the original disk. First, the display properties dialog box doesn't give me all the options I had before. Second, .jpg files display in the wrong aspect ration, almost 1 to 1, height width, so...

All my code in all my db's are suddenly generating the “Object or class does not support the set of events” error whenever a form event triggers a procedure. I’m running Access 2003 on a stand-alone machine. The db's are in Access 2000 format. Compact and Repair doesn't help. Any ideas?

My HP laptop running Windows XP is dying (not because of any HD failure). I’m a database programmer w/o a deep knowledge of operating systems. Can I buy a compatible computer and install the hard drive from the dying one as the boot/registry drive on the new one, thereby obviating the need to...

I emailed a new version of a db to a client as an attachment. We’ve done this many times before using the same version of Access 2003, Firefox and XP Pro. She saved it to the desktop and tried to open it. She gets the message, “Cannot open this file. This file is located outside your local...

I have a form which contains a subform in datasheet view. This datasheet has a subdatasheet. When the form opens, the parent datasheet appears in expanded display (by Access design). Any of the subdatasheets is expanded by clicking on the appropriate expand indicator on the left in the...

I need to create a rpt based on a cross-tab query. Since I have criteria on the field used for the column headings, I can't know or fix the column headings in the query design. (There are way too many possibilities to just list them all.) So, I can't know the rpt's field list in advance. Is...

Is there a way to get records to print out side-by-side instead of down the page. I'm creating a report to summarize calls to contacts at a company. I want to print out the names, address & phone of the contacts side-by-side accross the page. There will be 1-5 contacts and so would fit if...

I've written an procedure to run on the NotInList event of a combo box which starts by displaying a custom message box asking the user whether he wants to add to the list, etc. But I don't seem to be able to suppress the default NotInList message box. It pops up behind my custom one. I tried...

Whenever I try to use IN as a condition in VBA I get an compile error, either "Expected list separator or )" or "Expected Then or Go To", with the IN highlighted. For example, I tried both If Me![Status] in (1,3,5) Then If iif(Me![Status] in (1,3,5),-1,0) Then where Status is a...

I have a master contacts table for a firm and want to allow each individual at the firm to choose a subset of these contacts as his/her personal contact list. I've created a detail table with two fields, ContactID and EmployeeID to contain the personal list data. I added a Y/N field to the...

I've been developing and writing code for Access databases for a long time, but there have always been network people around to do all of the installation work. I'm now developing a db for a small firm, at most 4-6 simultaneous users, not much traffic, no security issues (everybody can see...

I'm having problems with my Windows NT4 and want to replace it with Windows 2000. However, I no longer have all the installation disks for the software I've accumulated over the years. Of course, I'll backup my program and data files to an external drive before starting but do I have to be...

I haven't worked with Oulook before. I need to export the entries in the Contacts folder in the Public Folders section of Outlook for use in an Access db. I tried to Export to Access, to Excel, and to a file. Each time, all I got were the field headings, but no data. Thinking this might be a...