Search results

Old code, new problem? The following code worked just fine - built using Access 2002 under XP. Now with Vista (I don't know if this might be the problem) and newer Windows OSs, the code fails at the db.Relations.Delete db.Relations(iRel).Name line with a Runtime 3033 error that says I don't...

I use Ghostscript/Bullzip to merge multiple reports (up to 43) into a single pdf output file. The basis of my code is the Access example on the bioPDF website. I've modified it a bit. (Since I set this up a few/couple of years ago, they have added the option to "AppendIfExists", eliminating...

Is there a way to prevent the user from clicking on the column headings and attempting to resort in a subform displayed in datasheet view? I can't disable the subform because the users can double-click on it to open a form based on the record selected in the subform.

I wanted to give back to the forum and check out my latest insight. I’ve searched around (and worked out my recent understanding) on the forum but I haven’t found a single thread that laid it out so I could fully grok the issue/solution. So I’m hoping to produce a searchable thread to help...

I have a problem I'm failing to figure out and I wonder if anyone cares to help me sort it out. I'm trying to delete records from a subform in datasheet view. It works fine when I press the DEL key - the selected record (with a FK) is deleted after I respond affirmatively to the MSGBOX...

I'm not sure how to articulate my question effectively, so I'm having trouble searching the forum. I may be just flaking on a really easy thing - I hope it's easy, anyway. I need some help: I'm making an application to help school counselors track their meetings with students. They can be in...

I've been reading the forum's history of posts about running Access db's in a Terminal Server/Services environment. I have a client who is looking to implement my FE/BE db in such a multi-user context and I'm worried about data integrity. I've advised them of my concerns and they had the...

I'm working on a utility to archive data from my application. The utility creates two copies of the db in an "archive" directory. I want to compact the first one and save it with all the records as a backup to the operation. I want to run two action queries in the second one to switch the...

Hi Folks, I'm trying to figure out how to use BeforeUpdate on my forms. My first task is to verify that data have been entered in necessary fields. I'm using the control tag = "required" approach instead of making the fields required so legacy data can be imported into the...

Hi All, I'm getting down to the wire on my little beastly application and I need some help again. I've just redone all the forms to run maximized with boxes that adjust around each form upon resizing. The thing is, there's a lot of activity on the screen as forms open and close, and I can...

Hi Folks, I'm sorry to bother you but I'm trying to learn how to put a box around a maximized form - so it needs to scale to the size of the Access Window - and I'm utterly failing to phrase my search query to be useful. Could someone please point me in the right direction? I'm trying to do...

I have a report with 7 subreports that print in a column-like manner. I put all the labels in the Detail of the main report. The first page looks great, but the subsequent pages omit the labels. I'm not sure how to articulate a Search on the Forum or 'Net. Could someone point me to what I'm...

I have some routines that I've set-up to accept an optional argument that lets me limit the ultimate recordset. The problem is that I'm running into the Error 7787 problem when I call the function as a part of Form_BeforeUpdate. It makes sense since the function opens and edits/updates a...

My application is about 4MB when there's no data in it. I just imported data into it (about 2k records in one table and 4k related records in a second table) and it jumped to 115MB. (The source file is a slightly previous version of the application and is about 5MB.) I've tried Compact and...

Hi Everybody, I'm working in the Developer version of Access XP (2002?). I keep my files in Access 2000 format. My users are often running Access 2000. Sometimes they experience run-time errors with my beast (I mean my application) because they don't have the same set of arguments for...

How can I prevent the Error 2501 - User canceled the operation error message if the user opts to hit the Cancel button on the Output To popup window where the user is to enter the filename and path of the output file? THANKS!!! Private Sub cmdExportToExcel_Click() DoCmd.OutputTo...

I have a report that hangs on a particular set of criteria. I've been able to call the report on each of the records in the selected set individually, but not when I call it on the set. The report has four subreports, two of which have LOTs of textboxes, each of which might need special...

Hi, I just made another post about error-trapping this file, but I have another question I need help with. On the Data form, there's a date field. There's a unique index in the table on the combination of the ClientID, foreign key here, and the date to prevent double entry. I also need to...

For the life of me I can't get my error-trapping and record-saving to work. I've been searching the forum and the 'net and just failing to get it. There are two relevant forms, a Client Data form and a Data form. The Client Data form includes a subform that shows an abbreviated version of...

Hi, I'm trying to delete tables using: DoCmd.DeleteObject acTable, "table name" but I'm getting an error message about the table's relationships. I've gone in and determined the names of the relationships, but can't successfully delete them. There isn't an "acRelation" constant, "acDefault"...