Search results

can someone write me a code to: Print off certain reports on the 1st of every month? E.g. 5 different reports that we can call "report1" "report2" etc for simplicity.

I have a report that may or maynot hold any information based on what date it is. Is there a way to automatically make this report appear if it is holding any data? (For any code lets call the report "report 1".)

I have a report that shows customer name, age, money owed. Now i want to add a check box that is named "payed". When this checkbox is ticked I want the name, age, money owed etc to disappear. Is this possible to do with a report? (note that the money owed data is summed up in the report...

In my query i have a field that is titled "date_achieved", and another that is titled expires_(months). for example the date_achieved field may hold 01/01/2020. The expires_(months) may hold 24 months. I have made a new field (an expression) that is supposed to give the date of the...

I have a fairly simple list in a report of about 80 rows. How can i group these rows? As in the first 10 are in "group 1". The second group are in "group 2" etc.

In my form evrything is working ok. But i have a filter. The toolbar at the bottom of the page is what i am trying to work with. I want the user to use this, but only the search function. Is there a way that i can alter this? I do want search I dont want record navigation or the filter...

Is this even possible? I have a date entry textbox on my form. I also have a "insert time" textbox aswell. Can I either lock, or make the "insert time" box invisible if the date entered in the first box is after todays date?

HI I have a subform which is a query and does exactly what i want it to do. This query has criteria, which is selected through the main form. At the minute the query doesnt update itself straight away if some criteria is altered. However it does update if I navigate to the next record and...

At the minute i have a form that works perfectly well. However at the minute the comboboxes that I have are looking up data from tables, i then assign a time to a customer through this form (in a seperate combobox). Say customer surname is named "combobox1". Now i insert a textbox into the...

1 lot of results per page of report e.g. page 1) customer name, address, profit made on on page page 2) customer 2's name, address, profit made and so on how do i do this

ive never really used reports before, does anyone have any decent learning material?? I have a form based on a query. At the minute there is 4 lots of info on one page, as in (customer name, address, tel etc)x4. I want one lost of info per page, how do i do this. And if i have pages of...

errrm i'm not sure about whats happening with my queries at the minute. I have entered lets say, a customer with an address. And then another customer with a different address. I now have customer A with address A. Aswell as customer B with address B. When i do a query, this is what is...

I have a form that is designed to enter data. But at the same time this form looks up information, (such as looks up a athlete instead of creating a new one) and then finally inserts a new result time for the designated athlete and event etc. It is working perfectly ok at the minute However...

i have created a data entry form and just realised i have done it terribly wrong. Lets say i want to enter an athletes times into this form. (so the times in seconds is what i am creating/entering). this part works ok. But when i input a athlete it adds this athlete to the atthlete table I...

hi I have two options above a combobox. If option one is selected i want the combobox's criteria (or row source to be list 1) if option 2 is selected i want it to be list two. These two lists are from 2 seperate tables. I am thinking that i need some code but dont know what the code should be...

quick question. In a totals query i have a list of times. Hoe do i use the average function to give me correct average times? It is currently giving me the number 5.25E-02. I am looking for something like 01:15:09 for minutes:seconds:milliseconds

I am hoping this is a simple question to ask you; if i have the following data: person event time A.smith A 1.15 A.smith B 1.20 A.smith A 1.10 A.smith B 1.50 A.smith C 1.16 How can i make my query return the quickest time for each event, e.g. so I get: person event time A.smith...

ok i know how to set the criteria of a query to the contents of a taxt/list/combo box from a form. But is there a way i can change the return value of the query from a form, (e.g. returns the freatest value of something) instead of doing it manually and typing in 1 in the Return: box? does this...