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

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.

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

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

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

I have a table, ( tblprocessor) with 5 fields which show details of a piece of equipment, 3 fields show related serial numbers, 1 field shows maufacturer and 1 field shows a software version in it. This table through a query makes up a part of another bigger table which is accessed through a...

I have built a database on Access 97 and one of the users is running Access 2000 software, when I've had this problem with older versions of Access, 97 has converted the old database by a prompt in the front end when trying to open,is this the same for Access 2000.

I am getting bored of the options that are offered as form templates and I would like to increase the variety of choice for my form layouts. I have read an article on Design Scheme Add - Ins but cannot find the download on the Microsoft site. Has anyone the address for this download or any...

I am getting bored of the options that are offered as form templates and I would like to increase the variety of choice for my form layouts. I have read an article on Design Scheme Add - Ins but cannot find the download on the Microsoft site. Has anyone the address for this download or any...