Recent content by smercer

A. Because women are too hard to please? A. because we are affected by Murphy ’s Law?

But they accept visiters, you might be able to come and visit me. lol

ha ha Go to hell, do not pass go, do not collect $200. damm, no get out of hell free card. :D

I wonder what happens to bachelors.

Then have a third sheet for saving the month by month returns. How the values are transfered could be done in either excel (via macro) or access (via a linked table and append query) does that help?

I recommend doing that with a linked table, that way you do not have to inport the data all the time, and you do not have the 15 minute wait. also do you really need to have the import the data in to excel? If you had a excell link you would be saving directly into excel on the fly. In this...

Wow, you've been on this problem for a few months now, I thought you would have solved it by now. In answer to your question about cross tab queries, It is a topic of access I know little about, but I can say you are on the right track I think.

Error writer There was once a young man who, in his youth, professed his desire to become a great writer. When asked to define great, he said, "I want to write stuff that the whole world will read, stuff that people will react to on a truly emotional level, stuff that will make them scream...

Hi all, I am having a problem with this linked table(and the only table) in access which is linked to a database in MySQL via ODBC. the problem is that the linked table in access is read-only (I want it to be read and write). I have searched the internet and found that you need to have the...

Hi all I am having a problem trying to Use Access as a front end database and having MySQL as the backend and I am trying to export a table from Access to MySQL following this website: http://builder.com.com/5100-6388-1050135.html but I am geting an error (see attachment) I tried to create a...

1) Check the fields in your query. 2) Check the references in the combo boxes so that they are referecing the query

Although the obvious is that the Database is so bloated it is making it crash, It could be something else too like bad coding, having more coding means more problems for you to trouble shoot more coding. Food for thought

The only other suggestion is that having a variable "xls" could be a reserved word that visual basic needs. try another name. If that didn't work, good luck.

Have you tried having a link by going file-->Get External Data-->link Tables. You then go down to "files of type" and choose "Microsoft Excel(*.xls)". You can then change the data as you would as in any table. even from a form Or you could just import the whole thing and there would be no link...

Try doing a macro, then save it as a module. You would then have the vb coding necessary for your work