Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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