Search results

The Repair/Compact feature appears not to be working in my Access 2007 databases. It looks like it's doing something, but my ballooning file sizes don't get any smaller. This is true when I run it from manage - compact and repair database AND when I turn on "compact on close". Some examples...

I need to be able to print multiple copies of a report from Access 2007 in an Access Runtime environment. The only way that I know of to print multiple copies is to use Docmd.printout. In a full-access environment, this works fine. But in the runtime environment, I get "the command Printout is...

I am having problems getting my report to always print to the correct printer bin(which contains special paper), so i thought i would give the PrinterCapabilities class from Getz et al "access 2002 developers handbook" a try. It looks so hopeful, but.... when I look at form frmdevcaps for my...

Hi, I have a checkbox on parent form ProductInfoMaster, and would like its after-update event to change the filteron property on subform ProductInfoSub. here's my code: but at the filteron step, i get error "object doesn't support this property or method". What am i doing wrong? I also tried...

I've recently completed converting all my db's to access 2007. now i'm noticing seriously ballooning file sizes, even though i've got compact/repair on close turned on. all of my db's are split into fe's and be's, and it's the fe's that are ballooning (be's are all on sql server). I distribute...

The following piece of code runs on an on_close event of a form in my db, when the db itself closes. I get the message box saying "removing reference to " and the path to excel I get the message box saying "reference removed". But the reference does not get removed. When I reopen the db, it's...

I am getting the error "Runtime Error 70: permission denied" when trying to execute the following line of code: We are in the process of converting to a new version of Citrix. The error occurs ONLY when running on a terminal server on the new version of Citrix. On our current (old) version of...

Since I need to use command line variables (like \exe), my shortcut paths must contain the msaccess.exe path. But it varies in different environments, and this is NOT under my control. For example, on our citrix servers, the path starts with c:\program files (x86)\MS Office whereas on most PC's...

Hi, In Access 2007, I have a db set for exclusive use, but I can open it on one pc, and then open it on a 2nd PC just fine. I've tried using the /excl command line. I've tried changing the db default to open exclusively. What am I missing???

Is it possible to expand the area under a shorcut icon so that longer names are visible? For example, I have a shorcut where I want the name to show up as "FPMDataEntry_V7". But all that shows up on the desktop (until you actually click the icon) is "FPMDataEn.." Thanks!

How can I trap the error "The Microsoft Database Engine cannot open the file 'MyDb.mdb'. It is already opened exclusively by another user, or you need permission to view its data". I have an error handler in my routine, but it does not get called at all when this happens. Instead, I get a...

For years I have been using the Incremental Search class module documented in my Access bible (The Access 2002 Desktop Developer's Handbook by Litwin, Getz, Gunderloy). Now that I am upgrading to Access 2007, this doesn't seem to work anymore. I don't get any error messages, it just doesn't do...

I have answered my own question already, but thought I would post this in case others find it useful. My trusted location page contains this path: \\nfswkgrp\nfswkgrp\pcamain\Access2007Conversion\2007DBs\ I have checked the "Allow trusted locations on my network" box. I open this database: On...

Here is a sample of my table. Field1 datatype is Memo. Here is a query on that table: And a sample result from the query: I am trying to convert the memo field to a date, where applicable, so I can then search the field for dates less than a given date. But, when I run, for example, this...

I have a form with a timer event that is used to run a bunch of stuff on a schedule. I leave this running all the time, and it runs a bunch of code overnight for me. Occasionally this just stops working. I come in in the morning, and nothing at all has run overnight. Usually all I have to do to...

I am trying to run an update query that I've run for years with no issues. This morning when I run it from code I get the dreaded "duplicate values" key violation error message. OK, so the first thing I normally do to try to debug is to run the query from the db query window and have the...

I'm converting an Access 2002 database to 2007. A form in this db has a text box has it's control source set to This works fine in 2002, but in 2007 just returns the irritating "#NAME?" To add to my puzzlement, I've added a button to that same form (for debugging purposes) with the following...

I am trying to run the following SQL pass thru query from MS Access 2002: This fails on the db.execute line, with error Connection failed: SQL State: 28000 SQL Server Error: 18456 Login failed for user 'pc3565k' But, if I cancel out of the code and then immediately execute the same query, it...

At long last I've gotten my IT department to set up a link to a remote server. Sure would be nice to be able to view the list of tables on the remote server! The only way I've found to do this so far is by using a system stored procedure: How can I set up a VIEW to return this same information?

I want to convert a DMax function that I use in my vb code to something that will more efficiently run on the server. code currently is: ddate=dmax("rundate","runlog","itemname='myitem') RunLog is a SQL server table that's currently linked to my db frontend. So I thought instead I could...