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: *

  1. Fortborg

    Print Report Record From Form

    Hi All, I am trying to get my form to print the associated report, with the current record only. My expression has been DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.OpenReport "Group Use Permits", acViewNormal, "[Id Number] = " & Forms!Recreation...
  2. Fortborg

    Is there an Excel Open in Access?

    Hey, I've tried many code variations to get Access to open a specific Excel file "VouchersDatabase.Xls", and I've been able to get Access to open the file, but only after getting some kind of macro prompt. I can't see a way to get Access to cleanly open a specific Excel file for me...
  3. Fortborg

    Open a specific Excel File

    This code is a good start, but I haven't been able to make it run correctly. It doesn't even attempt to open the Excel application or fetch the object. I've been shuffling code all morning, I'm out of ideas. Anyone else want to take a crack at it? Thanks, Fort
  4. Fortborg

    Open a specific Excel File

    Hi, I've got a database that updates to Excel by exporting a Union Query to a text document and importing in Excel. What I need to is to get my Excel file to open "Excel.xls" from a macro without having to go through any sort of database action first, ie. Update to Excel. I just...
  5. Fortborg

    Make A Union Query

    Works like a charm! Thanks so much, that code was exactly what I needed.
  6. Fortborg

    Make A Union Query

    Hi all, I've got 2 tables which contain the same column headings. Payee Name, Purchase Order Number, Ect. I need to make a union Query to join the two tables, but haven't had much success with the coding. Can anyone suggest sample code to get me on my way? Thanks. -Fort
  7. Fortborg

    Export to Excel w/out writing over existing.

    I'm not following...you want me to try to generate a different sheet each time, then move them all into one place?
  8. Fortborg

    Export to Excel w/out writing over existing.

    Hi all, The folks down in accounting (god bless them) have decided that rather than let Access handle their needs, they will still use Excel. Problem is, everyone else is now using my neat new Access database. I've made a query from 3 different tables of the data accounting needs. The...
  9. Fortborg

    Making a Report From Two Tables

    I have a database setup with two tables. Table A contains Name, Address, Phone number, ect.. Table B contains Item Descriptions, Costs, ect.. I need a report that will make a printout with: Name Address Description 1 Description 2 Description 3 Amount Total: How can I do this? Any help...
  10. Fortborg

    Dates in Excel?

    Hi Dawn, I'm exporting through a macro with the output function, and am using Access/Excel 2000. -Fort N'zur
  11. Fortborg

    Dates in Excel?

    Hi, I've been wrestling with thise one the past week or so, and now I've finally decided to seek help. :^) I've got a database that needs to be sorted by date, but I have users without Access who need to be able to view it in Excel. Problem is, when I export a query to Excel using excel, the...
  12. Fortborg

    Adding two fields together in a form

    Thanks John and Henry, as soon as I read Integer I was slapping my forehead! Now to explain to my boss why the project it three days behind...and what I was using that extra time for. LOL Saved my bacon, thanks again. Fort N'zur
  13. Fortborg

    Adding two fields together in a form

    I'm betting there is an easy way to do this and I'm just not seeing it, but its held me back for two days now, so I seek advice. What we needed is a form, made-up all pretty with all the bells and whistles, that the user will fill out then just hit a control button to print the thing and send...
  14. Fortborg

    Change Case for Labels?

    I have a table with Address information used in letters so it's all been entered in "John Smith" format, but to print labels I need the case changed to "JOHN SMITH". How can I do this?
  15. Fortborg

    Caculate Sums on a Form

    Hi, I know this could probably be done if I take the time to play with it, but I just don't have the time for that. Here's my situation: I have created a Form for customer information, and a sub-form to enter their different events. Events are: Buying Product A: Number of Product B: Number...

Part and Inventory Search

Back
Top