Recent content by colette

Apostrophe's in Names Hi, Here is another way, equally annoying though... Chr(34) is the ascii code for apostrophe. field=" & Chr(34) & me!txtname & Chr(34) Colette

Test for Global Connection = nothing It turns out to be... if gblCNN Is Nothing then If you want to close it, here is a sample I found... If Not Cnxn Is Nothing Then If Cnxn.State = adStateOpen Then Cnxn.Close End If Set Cnxn = Nothing I wish I didn't have to test for a closed...

I just started using Execute. I seem to be running into problems with strings and dates when the values are empty. I don't recall having the problem with docmd.runsql. Does anyone know where info on this might be documented?

Here is something I have been noticing and I thought someone might be able to shed some light on this and maybe offer a cleaner solution. I working with a front-end db in Access and linking to Oracle tables. When writing SQL Insert and Update statements using dates and strings, if the...

The Fields Collection Take a lookin in the help system (while in the modules) so you get VBA help. There is a section with the title above. Here is part of it... The Fields Collection The Fields collection is one of ADO's intrinsic collections. A collection is an ordered set of items that can...

The Fields Collection Take a lookin in the help system (while in the modules) so you get VBA help. There is a section with the title above. Here is part of it... The Fields Collection The Fields collection is one of ADO's intrinsic collections. A collection is an ordered set of items that can...

Hi, I have a form which has two separate subforms in it. When the user selects a record in the first subform, I want the values of that record to write to the second subform's fields. OnCurrent works when there is more than record in the subform. My problem is two fold, one I don't want my copy...

test for global variable=nothing Hi, I have been trying to use a global variable that stores my connection string and as I move around the db, it sometimes loses the value and appears to be set to nothing (especially in development). I have yet to figure out how to trap for gblConn=Nothing so...

sending emails Hi, docmd.sendobject is one way to send out emails. With Outlook 2003's email security though sending emails from Access has become more tedious. It only allows one email at a time and so lists of people cause you to hit a button over and over again. There are some third party...

I was doing that originally. I also use it to copy my linked tables within the external db to local tables. When I sent each type of object over one at a time, the system hiccuped on the open forms. Then, an individual from this site suggested a way to copy the whole db much faster, only copied...

Try testing for quotes also Hi, I don't think this is the solution, but another thing I often do is if var="" To troubleshoot this, try seeing what your variable values are as the function begins either by stepping through the code or by putting a msgbox that displays the variables there. This...

Copy Database / Rename Tables / Alter Table Does anyone have a suggestion on how I could further improve the code below? The function is behind a button on the form. It makes a copy of a database and then in an awkward way attempts to copy the linked tables making them local tables and dropping...

Partial Solution Hi, Thank you for leading me to this partial solution to my issue, but next time don't be so quick (and rude) about assuming people haven't spent time searching the web. I spent over an hour and was seeking two specific things. Backup on Exit implied "Exit" and I didn't want...

Minor Change to Code Hi, I tried the code and received errors on the line... Dim fso As FileSystemObjectFileSystemObject I changed the "Set" line to... Set fso = CreateObject("Scripting.FileSystemObject") and it worked. Colette

I am saving an odbc connection string to a global variable. Periodically, it seems to lose the connection. Does anyone have a way of testing that the connection exists. I have tried to do if gblvar=nothing then... and it doesn't like that. It often gives the err=13 Type Mismatch when it doesn't...