Recent content by tim_tims33

Hi, i'm creating a search form giving the end user a range of controls to use when filtering/searching data. See the image. But, i think my range search (using the textbox) to put in a lower and upper limit...is preventing this from working. In fact, when i put data into all the controls...

Hi, I'm trying to refine my Invoice system, although i'd love to update my Stock table with the 'Invoiced amount'. I select the StockID (or in this case 'UniformID') using a lookup. My thoughts are how best to update the stock quantity after this invoice is issued. Here's one way i've...

Hi, My form-based search mechanism uses controls to set the parameters for the query data source. I have one field call quantity in stock. I could you a Between and And method to allow the end user to input the stock quantity they want. HOWEVER, i would love it for the user to first...

Attached is are two files. A screen dump of the form (in design view) and a screen dump of the query (in design view). I hope this adds some clarity. Note: there is no form code...just a 'requery' macro when the user presses search. In fact, i am hoping that if a solution exists, it isn't a...

Hi, I have built a form intended for the user to search and filter records, via use of combo boxes, in my database. The datasource for the form is a query, which employs parameter criteria (references to the values selected in the controls placed on main form). If my query datasource is one...

Hi, Why does my report print out the contents of my subform in a different order? Incredibly annoying. I just want the Report list of records to be the same as the sub-form!!! eeeehhhh!! Any ideas?? T

Order of Records in Sub-Form Still not solved! Can't seem to work out how to solve this problem (not sure what is meant by sequencer either?) Anyone out there help? Thanks

not sure what you mean here by sequencer... sorry!

Hey guys, I developed a simple Database for a local Vehicle Garage where the user types in the details of the work done to the motor in a subform. The main form is his customer details. When the mechanic wants to type in Labour Cost ... which he leaves as the last entry in the subform... the...