Search results for query: *

I guess I wasn't clear. She needs the report as is. She also needs to write up a summary and wants to be able to cut and paste from the report. This is just one of seventeen reports on this project. All the others perform as expected in Report View. But this is the only one that includes...

Yeah, me too, but the client wants it. I think in addition to printing the report, she often needs to cut and paste from it. But in the end, I just don't understand the concept behind the Report View. What is it supposed to do other than show a Print Preview w/o page breaks? It does let you...

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

Thanks again. And no, I didn't think you were talking about editing/deleting records, just form designs.

Thanks all. This makes sense. Katie, does this mean that I should save the form just once with the records source property empty? Also, why does saving causing bloat? Doesn't the db just overwrite the previous version of the form, or is the db saving them all somewhere (till a compact?)?

Wow, nice catch. I was just examining the query in the form properties not in the code, and I didn't catch the difference even when I copied it here. The DISTINCT is vestigial, left over from a previous table structure. But now I have a strange theoretical question, why didn't DISTINCT...

Controls are enabled and unlocked. Edits are allowed. Here's the query in the form data source property: SELECT Grantees.*, Grants.* FROM Grants INNER JOIN Grantees ON Grants.GranteeID=Grantees.GranteeID WHERE Grantees.GranteeID=3 And Grants.GrantID=4139; Here's where the query is...

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

Thanks. It was missing drivers. (Why didn't I think of that?) After reading your posts, I searched way down in my stack of disks and found an Application and Driver Recovery DVD. Never knew I had one. Thanks again.

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

Well guys, it was a reference problem as expected. The last recommended article concerned Vista which wasn't relevant here -- I'm running XP -- but it did link to www.allenbrowne.com/ser-38.html "Solving Problems with Library References, which linked to...

No error messages when run Compile if that's what you mean.

Many thanks for your help. These are the references currently checked: VB for Applications MS Access 12.0 Object Library OLE Automation MS VB for Application Extensibility 5.3 MS DAO 3.6 Object Library I unchecked the last three (couldn't uncheck the 1st two), closed the db, reopened and...

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

Thanks folks for responding so quickly. As I said in my post, I tried using the SetWarning method and it didn't work. "Response=acDatatErrAdded" works, but turns out not to be what what I want to do. I googled "acDataErrAdded" and found a nice little article "NotInList Event Demystified"...