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

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

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

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

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