Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kb178
  • Order by date
  1. kb178

    Executing DTS Package from Front End

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

    User to Import Data

    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...
  3. kb178

    Add columns to cross-tab

    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...
  4. kb178

    Outlook prompt when sending attachment!!

    The send keys option worked for me! Thanks Bubba100!
  5. kb178

    Best way to capture this information...

    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...
  6. kb178

    Field Length Issue

    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...
  7. kb178

    SQL to change where data is

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

    SQL to change where data is

    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
  9. kb178

    Update Query with sequential data

    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...
  10. kb178

    Update Query with sequential data

    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
  11. kb178

    TransferSpreadsheet - Change font?

    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...
  12. kb178

    Query will not export

    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...
  13. kb178

    Help renaming one excel file in an external directory.

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

    Help renaming one excel file in an external directory.

    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...
  15. kb178

    Set Recordsource based on which button is pressed.

    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.
  16. kb178

    Set Recordsource based on which button is pressed.

    I'm not sure if I'm going about this the right way, but I have two fields called Spkr1 and Spkr2. Both need the same reports run. Is there a way to run the same report based on whether I press the Sprk1 button or the Spkr2 button? I tried setting the recordsource from the form to the report...
  17. kb178

    Can you find out who edited a file?

    Thanks, that's what I figured.
  18. kb178

    Can you find out who edited a file?

    I have an Access database where I have now added some functionality to track editing changes, but is there any way to tell who accessed the data before now? The backend data file lives on an NT server. I'm expecting to see a bunch of no's here, but I thought it was worth the shot to ask.
  19. kb178

    Temporarily Change the Default Email Client

    It sounds like I might just make it easier on myself I start loading our recently purchased Office XP upgrades (which allows for an exchange server on one profile and an IMAP account on another). Thanks for the help... -Kristen
  20. kb178

    Temporarily Change the Default Email Client

    Is there any way to do that? This is why I want to do this: Some people in my company have two email accounts, administered by two different IT groups. The account which we connected over the internet to an exchange server, has had ports blocked so we need to use a POP or IMAP account. I...

Part and Inventory Search

Back
Top