Search results for query: *

I'm trying to take a mail merge document with multiple "accounts" in it, and create PDF files for each account. How would one get the page number of the selection? I am using the find method to find the words "Account No. " then putting the account number in a variable. I want to get the page...

in looking at faq705-6003, I tried to see what it would look like, so I copied it to my access database... it worked ok... Then I went to see if there were any function on the net that would speed it up any... and I found a couple. the Table 'tblHolidays' should already exist. the fields are...

I've been doing alot of formatting with Word (I download books, reformat them for printing, then print them out)... but I also format them for HTML viewing... What I'm trying to do is find a paragraph mark that does not have a Less than sign after it... something like find ^p and not "<"...

I'm writing an application that will link to an Access database, get a list of databases, and then compact each of the databases (it backs them up before and after, just to make sure that the database does get compacted.) I thought I would have a little fun, and put the version of the...

I posted this question in another thread, but the subject would not have caught anyone's attention to this question, so I decided to create a new thread. Now, has anyone thought about creating an add-in or something that would save a form (or all of them) to a text file. I'm talking about the...

I inherited a database that has jpg's imported into a table.... and I was wondering if there was a way to "export" the images back out of the database, creating jpgs again... since the original jpgs are no longer available.... Gcomyn

Greetings... I found the following code somewhere on the net, I forget where, that will convert a text file from Unix format to DOS format. However, if the file is too big, you get an overflow error when you pass the string to the function. Here is the code for Lf2Crlf: Public Function...

I've been having some problems with a couple of my databases. The database that has been giving me the most problems. has about 60 or so built queries in it, and sometimes, when I compact it, the entries in the MSysObjects table shows them as OLE, instead of queries, so it gives me an...

I'm trying to put together a proposal for my boss that will show why we should 'upsize' our database to SQL Server. Right now, I've got about 10 or 20 databases that are over 50,000 records (most over 150,000) and they are getting bigger by 1,000 records a week (some are getting larger by...

I have Acrobat Exchange 3.0, and I use it to 'print' pdf files. I was wondering if anyone knew of a way to do this programmatically... Right now, I have to print the report, then a dialog box appears that asks me for the filename.... Is there a way to do this programattically?? GComyn

hello... I've been trying to append a table with 6,000 records to a table with 180,000, and I have it set to append only 100 accounts that are not already in the large table (the large table also had primary keys to stop duplication). Now, I can run it the first time, but after that, I keep...

I'm trying to create a function that will take a input a code file into a module. I know about AddFromFile, but I can't seem to get the database to create the module in the first place.... Every example that I've seen needs to already have the module created before you can use the AddFromFile...

Hello All... I've been toying with a piece of code that will go through all of the modules in a database (the current one for now), and place into a table (will create it if it's not there) the following information: Database Name Database Path Module Name Procedure Order (What order in the...

I've been trying to create (in Access 97) a Multi-column crosstab query for a while now, and not getting anywhere. I was wondering if anyone out there has done this, if it can be done. Here is an example of what I'm looking for.... Month January 2001...