Search results

I think we share the same problem. My sub reports that are based on a query (criteria from the main form) only update with a tab change, e.g. not automatically. I have asked for help too but havent heard anything. If my post is answered i will share the solution with you :)

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

arnt page breaks just for printing ? When i tried nothing happened, i dont know if i am doing it wrong

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

just from the first link, i think i have wasted loads of time working out averages in queries! I havent found the actual answer to my question yet but i am realising what i can possibily do, thanks for the links (btw im on 2007 access package)

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

Thanks with a bit of tweaking i have got what i wanted. But how would i go about changing the sex combo box to a text box. This text box just stating "m" or "f", e.g. not allowing the user to choose a gender. (where would i put the code into a text box, as in for the combo box it was the...

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 thought cascading comboboxes meant that the 2nd combobox was dependant on the 1st combo box. This isn't what I'm looking for. My first combobox has: stroke, distance, gender, relay (yes/no) I just want to display this in multiple comboboxes. So the user selects the stroke, then the...

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

Thanks once again This has bugged me for the last couple of weeks, and i eventually thought that i could complete the database withot this feature, but i think you may be able to help me: How on earth do i change the "return value" amount of the query through a form? The return value button...

im not sure if this should go in a different thread but i will post it here for the mean time. everything i have asked about is running smoothly but i dont know how to do the following. I currently have 2 frames, 2 options in each. I have 4 macros that work perfectly, using the combo boxes...

thanks guys

Firstly where would i put this code? yes i tried to substitute it in but then i simply just get no results in the combo box. when you say framename in my case this would be option1=1 right? this is the code that isnt working: Private Sub combo1_AfterUpdate() If Me.option1 = 1 Then...

Paul, now it works with the combo box, how do i go about doing it from the option buttons, (i think they are grouped??? as in they are in the same box and 1 has option value 1, the other 2) this is my code that currently works: Private Sub combo1_AfterUpdate() If Me.combo1 = "swimmer" Then...

for combo 2? it wasnt but it is now but i still get the same result :DEDIT: I CLOSED THE FORM AND OPENED IT AGAIN AND NOW IT WORKS! i seriously cant say enough thankyous to you for your patience that you showed to help a beginner

Its got some personal data though so will have to post it (and change data as a last resort). I am now using a combo box instead of option buttons to make it simpler for me. (its no longer saying invalid syntax) BUT in the combo box where i want the desired information showing says: "SELECT...

now its saying invalid syntax. im about ready for giving up and i named the combo box firstcombo to try and make it easier