Search results for query: *

I have used the Output To macro to run a query and show the results in an Excel format and place it into the C: drive with a pre-determined file name. When this macro is run, it does what it is supposed to do except that the file in C: does not show an Excel spreadsheet, when you try and open...

Thanks for your help but I think I've made a pigs ear with your answer, in the query design view, I have a field called Battery start date, I changed the option for the Total field to &quot;Where&quot; and in the criteria field I put your expression <Date()-365. Unfortunately it didn't work, so...

i have a field in a database that has the date of issue date for a radio battery, these batteries a guarenteed for 12 months of use. What can I put in the query under this date field to sort the data for any date over 12 months when the date format is like 27/11/02. Thanks for your prompt reply.

As I am still very much on a learning curve regarding VB code, can you show the required code that I would need to use and where would I place it. Thanks

Thanks for your prompt reply, We are on a LAN system here and are therefore using Windows NT, does this make any difference.

In one of my databases (Access 97) I have been asked to e-mail some selected data to a specific person, I have done this using the Sendobject macro, (which works well). This requirement is usually sent vis a control button on the 1st of every month, is there some way of automating this...

That does exactly what I require, and it gives you the option to write an attached message as well. Thank for your prompt assistance.

From within a database using Access 97, I run a macro from a command button that outputs a query into an .xls format onto my C:\ drive, then I have to e-mail it to another location via the attachment process. Is there any way I can use the output to macro but have the output destination as an...

Thanks Alex, it worked a treat, makes it look more professional, the illusion go's on, cheers

Thanks for your prompt reply BUT, how would I set the focus to the form, could you explain. Thanks

I have a pop up form in one of my databases that has one field on it that counts the entries on a table that fit a pre-defined criteria. When this form is opened the field shows the total but has a flashing cursor and the background is black with white numbers, it does the job it supposed to...

Firstly Thanks for your effort in helping to solve this dilemma. I've copied your code into the &quot;On Activate&quot; event of the report and turned all but the first 12 lines into a statement format to see if I can get the first row of lables not to print if the quantity box is left empty...

YEP!!! I think you understand this problem now, is there some code that will not print the row of 3 labels if the quantity lable is left empty. Cheers

the report is being used to produce a &quot;pro-forma&quot; laden sheet that will have the deails typed in and printed but not saved so you get the template report layout the same every time you open the report. Its used purely as a neat way of producing a laden sheet that can have different...

I cant run a query as I am using only lables to hold the data not bound fields. An example is shown below: Quantity Type Model 100 Radio XYZ1 50 Battery Charger ABC2 etc. What I need is that if the lable that holds...

I am using a report to produce a laden sheet which opens in design mode &quot;On Click&quot; of a command button. There are 3 columns, Quantity, Type and Model, all of the fields are lables thus enabling the quantity options to be different each time the report is printed, (without saving), the...

Thanks very much for your help, I now understand what i did wrong and the 4 fields are now auto entering from the combo box, BUT the data is not finding its way to the main table so when i close the form i get the message box telling me that i cannot save. Can you help.

Thanks for your reply Alex, but I am still very much on a learning curve. Can you explain in a little more detail.

I asked a question regarding combo boxes on the 30/5/02 called Combo Box problem, this is a continuation, as the programmer who helped me has not read the sheet and answered my plea for help. I am experiencing a problem with the code below, can anybody assist me, you may have to read the...

Thanks for your prompt reply. I tried both ways from previous note and its obvious now that you are right. The problem is that I have put the code in the AfterUpdate property using code and the following appears when I try to run it: Compile Error Variable Not Defined When I open the code...