Recent content by kb178

That one line of code just took care of 4 hours of research on this! Thank you for that link!

I have a user that needs to import a data file. The problem is that I used the transferspreadsheet function in the code to import the data. The import worked fine on my machine. However, on the user's end, her tables show up as "dbo.tmp" where mine just show up as "tmp" in the adp file. So...

I have a cross tab report that sums up some information for me based on quite a few different columns. It displays them by a territory number. My issue is that I also need to show 2 other columns alongside the territory. Is there a way to do this? I have: Terr Count1 Count2 Count3...

The send keys option worked for me! Thanks Bubba100!

I'm not sure what the best way to handle some information I need to capture, so I thought I'd post it to tek-tips and see what you guys think... It's for a database where attendees will be registered. A person will call and register multiple people. Those people need to be grouped together...

I was given the task of providing a report in which I need to pull simple information from a table. To throw in a wrench, my field lengths are all 50 and each field in the report can only be a max of 25 characters. If a data field contains more than 25 characters, the rest of the data must be...

Thanks guys... JamesLean - I read your mind before I read your post! That's exactly how I did it...

I have a table with a First Name column and a Last Name column. 1/2 the records are incorrect where the last names are in the first name column and the first names are in the last name column. I know it's certain records between 2 ids. Is there an easy way to switch the records? Thanks, Kristen

There is no common link between the two tables. Basically, if I have a table with Jim, Bob, and John and another table with ABC123, ABC456, ABC321, I want to assign the certificate #s in the order that the are in to the names in alpha order. With the example data above, this is the outcome I...

I have a table of names and a table of certificate numbers. How can I sort the table of names by last name and update their certificate field with a certificate number from another table? The certificate numbers need to be appended in their id order to the sorted list of names. Thanks, Kristen

I'm using the TransferSpreadsheet command to loop through a query and export different names in different tabs. It works beautifully, thanks to advice on this site. However, the font it exports to is Ms Sans Serif, and I would like it to be Arial. Is there any way to change the font when...

I have a simple query where the only criteria is that one field is true and another is false. I have a button on a form which exports that query to Excel and then updates the false field to true. Here is the code: DoCmd.OutputTo acOutputQuery, "Query1", acFormatXLS, , True...

Awesome! Thanks pdldavis! I guess it likes when you just use date, instead of calling something on the form!

This thread has been a big help to me - but now I'm feeling greedy... When using the OutputTo function in VB in Access I'm allowed to export something as: "C:\whatever " & Me.Date & ".xls" (Me.Date is specified on the form I'm running the code from). I tried doing the same...

Thanks... I wound up creating a union query to create two records, the first with spkr1, the 2nd having spkr2. Then, with your strfilter example above, I created the filters based on whether spkr1's button was pressed, or spkr2.