Search results

I added the reference by browsing to a mapped drive. However, when I ask Access for the path to the reference it returns something like \\global\tektronix\net\global\namerica\.....\MyLibrary.accde So I assume this is the absolute reference. Thinking that maybe this shows up differently on...

I have Access databases that have been running fine for years, unchanged. They all reference a common "library.accde" database which contains many commonly used functions. Recently, we've intermittently been experiencing that the databases cannot find any of the functions in the referenced...

I have a time field in my table with the default value set to Now(). However, it seems that when I open my table, the value gets set for the next record (even though I haven't started entering it), and if I wait for 10 minutes... or an hour.... to enter the record, the time gets set to that time...

Can some one point me to something like "Making Access Database Available on the Web, For Dummies?" I have many years of experience with developing complex db's in MS Access, and a few with SQL server. But NO experience with web applications of any kind, or with Sharepoint or anything like...

My "minor change" was that I changed my linked SQL tables to a different server. I went back to my backup copy, re-changed the links there, and now all seems to be well. Go figure. Spikepl, these are of course all good ideas, and I do have error handling (almost) everywhere.... but the...

I recently made some minor changes to my db. Now, when I open it, I am getting "The expression onload you entered produced the following error: File not found", with no opportunity to go to a debug window and no clue what is causing this. If I click OK, it goes away and everything seems to work...

HI, I am using Allen Browne's method for handling multiple instances of a form. See http://allenbrowne.com/ser-35.html for code and details. Using Access 2010. However, I am having a problem where sometimes the instance does not close properly. I've posted my entire FormMultipleInstance module...

So, do you know what is meant by "default order"?

1. Is it possible to "autoorder" the tab indexes of a section of a form, using VB? (I know how to do it manually) 2. In the object explorer, under "Section" I see "SetTabOrder", but can't find any help on this. What do you suppose it does?

Hi,I have a db created in 2007, but my users have now upgraded to 2010. The db works fine mostly, but I am puzzled: When I open the db in 2010, at the top in parentheses it says "Access 2007". Fine, I thought it was just warning me that it was still in 2007 format and maybe I should consider...

Acrobat reader.

I am using unbound object control rather than image control, because image control won't do PDF's. I am populating the controls at runtime. The problem is, depending on the PC, I can't link to PDF's or JPG's at all, at runtime or otherwise.

I am linking to the files using unbound object frames on a form. I want the pictures to actually show up in Access, without the user having to click on a hyperlink. Also, there are multiple pictures per form. Also, I have confirmed that it's not an Access 2010 specific problem. I have found...

Hi, I have code that creates links to pictures on a form. The pictures are external .jpg or .pdf or .bmp files, and different files are linked to depending on user choices prior to opening the form. This works fine on some PC's, and not so fine on others. Some PC's can open the bmp files but...

In answer to you questions: 1. To close, user clicks a button which has embedded macro with action "quit". I do not have the closeform stuff before it. I will try adding that... but I seriously doubt that it is going to make any difference, as I think the problem stems from those seeming...

I have about 25 forms in my database (Access 2007), each of which contains between 3 and 6 unbound object frames. All of these are linked, NOT imbedded. Yet the presence of these linked OLE objects seems to cause the db to bloat, by something on the order of 1 to 5 MB per frame! The links are...

Yes, I have the latest SP installed. Now I think I've determined that the cause of the bloat is linked OLE objects. I am continuing this discussion under "linked OLE object causing database bloat?"

Hmm, well, I agree. I wish I had more information to give you. What would you like to know? All I know right now is that sometimes, although it's clear that the user is no longer using the database, there was no "logout" record recorded. And I am looking for ideas as to why this would be? I...

I have a form called "Hidden" which opens in hidden mode, via the db's autoexec. The autoexec also logs a "login" record to a table. Form Hidden's close event logs a "logout" record.... at least most of the time. Sometimes the logout record does not get recorded, and I don't understand why. Any...

Hi, I am in the process of adding tab controls to a bunch of forms. I'm not adding anything to the form other than the tab controls, then moving most of the existing controls on the form to one of two pages on the tab control. After doing this for about 15 forms, my db size has grown from about...