Search results

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!

Gemma / Dave--- THankyouthankyouthankyou! THis is one of those problems that I foggily remember having dealt with years ago. The OLD Vickie was so much smarter than the current one!

OK, I have to append my question. In the code shown above, I first get the error at with Error # 3051. My error handling routine works as expected and returns the code to the AssemblyMasterRefresh line. THen the code fails again, on But THIS time the error handler does not fire, I just get the...

No such luck. Several reasons: 1. It's not that I don't know the error code. It's that the error handler is not firing at all. I just get the Access-generated msgbox. THe code never gets to the "HandleError" section. 2. I am using Access 2002.

Here is my code. I'm getting the error on the line .Execute "AssemblyMaster_Refresh", dbFailOnError

Yes, I have an error handler. But it does not get activated, I just get the msgbox with the error description. If I then ask for an error number ("?err.number") I get nothing. So this seems like one of those "untrappable errors". Looking for a way to trap it.

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

The problem was that the code, indeed, is not set up to handle a multiselect listbox. Once I edited it to handle multiselect, it works fine. In fact, I found my notes on the original code, and way back then I had had to edit it in the same way.

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

Yes, but what suprises me is that now if, using windows, I navigate to the m: etc. path and open the db from there, I still get the security message. Something has changed on our network recently to cause this, because when I originally set this up with the \\workgroups stuff in trusted...

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

Oh heck, never mind. I've been working in SQL server for too long, and now am losing my mind. Wrong syntax for findnext!

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

It happened again today. Any other ideas?

I get no errors, no activity at all. When my stuff runs, it logs to a text file. When this problem occurs, I get nothing logged to the text file. The time events are based on AFTER a specific time. In this particular case, I had 15 different events that should've run since I left at 4pm...

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 had already tried that. This morning when I came in, the problem had corrected itself. With no action on my part. Strange and troubling! One note, when I was having this problem, I was working from home via something called "VPN Client" (if that means anything to anyone outside our...

I did the docmd.setwarnings true. No change. Any other ideas?

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

Hmmm, wrapping it in a function seems to work. ANy idea why????