Replies

Export on the query also doesn’t work, though on the table it works fine. Maybe the difference between the resources it takes to run a query and display a table are enough to cause the difference. At least I was able to get the data out in the end. Thanks, -K.

Nope, no memo or OLE fields. I can do it a few rows or columns at a time from the query without an apparent problem. Thanks for the reply Hans.

OK – I ended up solving my problem by writing the query contents back to a table in the DB and then copying the contents of the table which I was then able to past from the clipboard just fine. I’m still curious why this happened if anyone has any ideas.
-K.

Thanks to all of you for your help. I now have enough info to solve the problem. Kevin’s code is exactly what I was looking for. This work with automation is relatively new for me, so all assistance is greatly appreciated.
best,
Karl

check out the thread beginning in post 302777 . You can either use this in a select query or you can use it in an update query to write the data back to two separate newly created columns in the table.

best,
Karl

yeah, I’ve considered local copies as an option, but I really want there to be a cleaner solution with all of the templates in a single place. (as if wanting ever solved anything…)

You say “a few extra lines of code could check to see if they have the latest version if it changes.”

Thinking this through, I would still keep a “master” copy on the network drive, and I would check the “modified” dates of the local and network copies… is this what you mean? If the copy wasn’t current, could I automatically pull an updated version to the local drive? If so how?

thanks,
K

I’m afraid I don’t quite understand what you’re asking. How does the selection on the calendar (and which calendar?) effect these combo boxes? Let me say this, however: the default value is set independently for each combo box on a form, and the default value is loaded into the form when the form/record is opened. If you want to change the value of combobox based on other selections on the form you need to look into VB coding. Hope this helps.

-Karl

I’m afraid I don’t quite understand what you’re asking. How does the selection on the calendar (and which calendar?) effect these combo boxes? Let me say this, however: the default value is set independently for each combo box on a form, and the default value is loaded into the form when the form/record is opened. If you want to change the value of combobox based on other selections on the form you need to look into VB coding. Hope this helps.

-Karl

On the property sheet for the combo box, click on the Data tab. You’ll see a Default Value property field. This is a value that will automatically be loaded each time the form is loaded. Just enter the value you want here.

On the property sheet for the combo box, click on the Data tab. You’ll see a Default Value property field. This is a value that will automatically be loaded each time the form is loaded. Just enter the value you want here.

Hi John,

The problem appears to be that you included the lngStartNumber variable within the quotes of the string. Since you want to include the variable and not the string ‘lngStartNumber’, it needs to be outside the quotes, like this (and like you do in the msgbox line):

If DLookup("[Check Number]", "[Check Writer]", "[Check Number] = " & lngStartNumber) Then 

Hope this helps,
-Karl

Hi John,

The problem appears to be that you included the lngStartNumber variable within the quotes of the string. Since you want to include the variable and not the string ‘lngStartNumber’, it needs to be outside the quotes, like this (and like you do in the msgbox line):

If DLookup("[Check Number]", "[Check Writer]", "[Check Number] = " & lngStartNumber) Then 

Hope this helps,
-Karl

Mark,

Thank-you. It looks like this works. I have some playing around to get this working, but I can see the data, so all is good. I am so grateful. I was so stuck with ODBC link…

-Karl

Mark,

Thank-you. It looks like this works. I have some playing around to get this working, but I can see the data, so all is good. I am so grateful. I was so stuck with ODBC link…

-Karl

Hi Hans, and thanks for the reply.

I’ve taken a look at post 117856, and the problem there was that a VFP database (.dbc) was being set up as a free table directory, and I am pointing to the .dbc file and not trying to set it up as a table directory.

MarkD’s post 174958 seems to rely on a properly set up DSN, which mine doesn’t seem to be, since if it was properly set up I should be able to link and wouldn’t need that code, unless I’m misunderstanding what is happening. I think that my problem is in setting up the DSN, but I can’t seem to locate what the problem would be. I’ve followed the instructions I found in Knowledge Base Article #197893 , but I still get that blank table screen.