Search results

Is it possible on a form (not a page) to have the pointer item change when over an image just as happens on hyperlinks in web pages? I have been messing about with the hourglass option in macros with "on mouse move" event as a possibility but this would need some form of loop to keep it...

The weekday worked a treat, thank you very much. I seem to spend more time trying to get the syntax for validation to work at form level than I do for any other part but this worked first time

I have a table where the user enters a date. I only want them to be able to enter a Friday date. I am trying to get some sort of table validation to do this but can't get the syntax right. Is it possible please?

I have a form that prints in the manner you want. (The button is command41 in the example below). The action is attached to the click on this button The button is on the form called "frm_enter_enquiry". Private Sub Command41_Click() On Error GoTo Err_Command41_Click DoCmd.OpenReport...

Certainly was! Would never have got there in a million years without it (I am an old DataEase user and having trouble thinking "differently")

Fizzio, thank you so much for your efforts, greatly appreciated (and eye opening for me). You have given me a way forwards, thank you

Quick response Fizzio!! I had better explain what I am trying to do more and then you can say whether I am barking mad or not. I wish to record the name and address of all customers in my main table. This table also has a straightforward sequential number on it. These customers can be registered...

I have 2 tables, tbl_main and tbl_sub. Both are linked by a number field. On my form over tbl_main, I would like to put all my tbl_main fields and just one field from tbl sub and display the relevant data frm tbl_sub based on the link. I know I can do it by inserting a subform but I only want 1...

Damn..tried overlaying but it won't let you have a transparent fill as the default fill within the condition. So, one box hides the others. Back to the drawing (colouring) board I think

Thanks Fizio, this works fine..up to a point. Can only get 3 conditions per textbox so I will have to overlay other unbound boxes on the report until I can get the full 0 to 9 range. Thanks once again

I have a report with a rectangle on it. What I would like is for the fill colour to change depending on the value in a field on the report. So, if the value is 1, fill colour green, if 2 then fill with red etc. Can this be done please?

.....and lo, the mist was lifted from his eyes!! Thanks you very much for the patience and prompt response, I will now go and show off to my colleagues how clever I am

Hi Hayley. Thanks for your help here. This option you suggested will list all records as the start date is always between startdate and enddate. I tried it and the option to input criteria doesn't come up, it just runs. A typical record may contain start date as 1 january and enddate as 20...

Hayley, which field am I applying this criteria to? I can't put the criteria into a blank column. There are 3 fields, startdate, enddate and name. I would like to list all records where the start and end date period spans the input criteria

I would appreciate a "push" in the right direction with the following. I have table for recording dates that staff take their holidays. It has a startdate and an enddate fields. I would like to be able to enter a date as a criteria (or even better a range of dates) and for the query to pull up...

Many thanks (he says with embarassed expression), it was that easy!

I have a form that users enter car registration numbers on. As well as storing the number on theunderlying table, I want to store the first 3 digits of this number within the table in another field. I have tried creating an unbound field on the form to calculate the first 3 using...

Job's a good 'un! Thanks very much, one more lesson learnt for the day

Hi Rich, thanks for the quick reply. Fromn what I have tried with this method it does not give you the dialogue box to allow for the selection of a different printer whcih is where my main problem is. I don't want the users limited to their default printer and settings

I find the standard print button next to useless, being that it does not give the user the option of which printer to choose. I would like to have a button on the toolbar that does the equivalent of FILE/PRINT or Ctrl P but do not know how to assign this command to a custom button. Any help...