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 "Where" 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
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...
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...
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 "On Activate" 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...
the report is being used to produce a "pro-forma" 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 "On Click" 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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.