Search results

Hi, just wondering whether anyone can help me with this. I have a simple form that contains details for a component, and a subform showing what harnesses contain this component. What I'd like to be able to do is click on a button on the form, and for it to print a report showing the data on the...

I'm now writing a query to show all of the values in a table, but only if one of the fields does not match any of the values in another specified query. My coding so far goes like so: <> ([QryDisplayAllocated]![GI Number]) However, this just throws up a parameter entry box, instead of looking...

I have a query that reads a value from a form, and then displays all of the records from a table that match this value. The code goes something like this: [Forms]![FrmForm]![Text Box] This is all well and good, but is the inverse to what I want. I'd like a query that displays all the records...

I'm having two problems in on really, so here goes! I'm trying to create a button to disable another button in a subform, but it does not seem to recognise the subform in the expression. The code is as follows: [Forms]![FrmHarnessSetup]![SfrmHarnessSetup]![Command12].Enabled = No I simply...

I have a query in my database that returns a single value. Is there any way to set up a text box in a form that will simply display this value? So far I've tried creating an unbound text box, and then using expression builder to refer to the query for the control source, which produces this...

By default, the fields in a form that I am making are locked and are for viewing only. I am trying to build a macro that unlocks the fields and allows the user to edit them. I went into expression builder and it helped me build this: Forms![Sfrmmemberdetails]![Surname].Locked This particular...

Using Access 97, I made a table which contained a short date format. I tested that it was rejecting invalid dates by entering 35/07/02 in to the field (35th July, 2002). However, instead of refusing it, it flipped it around to give 02/07/2035! This could be a bit distastrous when being used, is...