Search results

When opening a database what does this message mean: Compile Error Can't find project or library. It then hightlights a line of code (Date) Cheers

Thanks for the help. Is it possible to put this result in a textbox? Would using DLookUp work? How would I go about doing this? Cheers

Cheers for the reply. Is that the same in 97? When doing the query it then prompts for a name and a true option. How does this then go into a sub form? Thanks

Can anyone help? I have a table with the following: Booked with a y/n field Person Name with a text field So... Yes(True) Jim Yes(True) Jim No(False) Jim What I need is to be able to show a query that shows if the checkbox is ticked (True) and the Name is Jim total up how many true items...

Hello, Cheers for the reply, when doing this, the result that is shown is #NAME? in the textbox. This was done with the way you stated. What does this error mean? Could you show an example? Cheers for your help.

Is it possible for a textbox on a form to show a result of a query? For example a query has a sum result and that can be shown in the textbox on the form. Also can you show any result in textbox from a query? Cheers

Hello, Cheers for the reply. What about if the subform is set as a datasheet view this doesn't seem to work.When you select the checkbox nothing changes colour. If changed to a form view this works but every check box changes colour and the textboxes, instead of only the single line the check...

Hi, Thanks for quick reply. Had a go at but it didn't seem to work. The box went blue but the check box wasn't ticked. When you then click the check box it stayed on blue. I think there is an error or something could you show another example with a sub form? It's as a datasheet. Cheers

Cheers for the reply. This is helpful. How would you go about this in A97?

Hello. Cheers for the reply. Looked at your reply but Im confused a bit. Using a form and a subform within it. On the subform there is a check box column which, when this is not ticked the whole row that the checkbox is on including the checkbox changes to a different colour e.g. Column...

Hello all. Is it possible for a check box within a subform to make that entire row turn into one colour when selected true? What I want is when the check box is selected (True) that one row and the rest of the row turns into a colour e.g. red and become disabled? Any ideas? Cheers

DatePart Function Cheers for the quick reply. I am new to Access is this what I would do? Keep the Months and Years Combo boxes on the form, make a query and select the column with the expiry date and insert this in the query: Month: DatePart('m',[thecolumnthatholdstheexpirydate]) and then the...

Im new in using Access 97 and would like some help. Basically I have two combo boxes on a form - one containing Months of the year Jan...Dec that I have typed in manually and the second one containing years 1999....2006 (Also manually typed in). On a table I have got data on food and one of the...

Does anyone know why when you click on a command button that loads a report it shows it in a print preview mode and then when you click close it closes the report window and changes the form that you were originally on to a much smaller and condensed view instead of being maximised? All the...

Would this work: Having a command button that opens another database. Cheers

Cheers for the help, I have now solved it and it works.

Wizard Query Just out of interest have you checked that the setting on the toolbox is highlighted so that the wizard runs (The magic wand)

How would I go about doing this: I need to show two different forms one after another. For example; a menu screen (1st screen) with a command button that will pop up another screen (2nd screen) for the user to enter details about themselves. After clicking on the command button (On the 1st...

Cheers for the reply. That example you gave sort of shows what Im after but not quite. How exactly do you pass the cbo's criteria to the query, would you use code on a command button to do this. The expiry date is a date/time field and no it is just one field for the expiry date.

How would I got about with this problem. What would the code be for this command button. I have got two combo boxes that contain Month(cbo_Month) and Year(cbo_Month) and located in them are month names and month number e.g. Jan 1 Feb 2 etc and year 2002 02 2003 03 etc in 2 columns. These are on...