Search results

anyone know of a way to increase the amount of criteria allowed in a query, the max seems to be 9. and I need about 25!!! ta John

I have 15 combo boxes each with another combo box that is filtered based on what you slect in the first combo box. but they do not work consistently. the work in terms of the data, but sometimes the selection made by the user then dissapears when they move onto the next pair of boxes, or...

I have a form which runs a query. there are many records shown in the query. the query displays all the data correctly. but I need to reference this to text boxes within a new form. so... line 1 of the query has the details for a particular record, the text boxes need to link to this. same...

great! thanks jeff, do you have the location of the download? ta John

the saga continues! er, me again, sorry! my boss has now chucked in a nice spanner into the works. the fields I am emailing could include 1 or many projects. is there a way of say having, 50 combo boxes, the user selects the project for combo box1, and the instrument for combo box2 and so...

anyone know of a way to link a form to the address book in outlook? . the idea being that instead of storing the email addresses on access the user picks up the address book and select the emails recipients they want. also this would allow for about two users to be always emailed as they are...

Success! many apologies! I had not typed in the email address in the correct place!! thanks for all your help, am very happy now that is works. cheers John

email query (cont) yes I do, started off as a text box, with the name as txtemailaddress and then when I ran the form, the caption changed from the email address I had typed to #NAME so changed the text box to a label but with no success.

Apologies!!! Option Explicit Sorry, am probably being stupid. have tried the code you gave me, see below! but am getting an error occuring about using an expression which evaluated the wrong data type. any pointers? Private Sub Command10_Click() On Error GoTo Err_Command10_Click Dim...

success! Hayley, thanks for all your help, I appreciate the time and patience! I managed to bodge it, and this is how it now works. have the two combo boxes. a query with the other data I need runs off that form. with critieria based on the combo box selections. I then made a macro to run...

Further Query that was very useful thankyou. the problem I have at present ... the two combo boxes work fine. i now need to attach about 5 text boxes to the combo box. so... the first combo box picks the project code. the second picks the intrument within the project. thus, the text boxes...

sorry, i am sure this is totally simple. I have two combo boxes, by selecting data on each, the txt boxes on the form will show up a particular record. I have built the two combo boxes, and they work fine. but I cant seem to reference the txt boxes to the combo box. the txt boxes would have...

cheers! sorry Hayley, thanks for that, as I was looking at the form again,I decided on a different format wherby the database asks the user in a popup box for the project code and then for the instrument then the form displays the resulting info. I would want these popup boxes as...

IGNORE ABOVE HELP REQUEST ta! please ignore the previous mailing.

I have two combo boxes and a subform. one combo box is the project code. and the other combo box is the description of the project instrument. there are many instruments to a project code. I want the subform to change when I select the project code (which it does) but then the instrument list...

I am investigating whether access can email a user with the text of the email taken from fields within the database. I really want it to be as text within the message rather than as an attachment and be able to specify the recipients from within access. am dubious as to whether this can be...

ta! cheers Jeff, I'll give that a go, regards John

I have a database which follows the progess of a report from start to finish, there are 5 stages numbered imaginatively 1 to 5. I am looking to record the date that the code changed. rather than get the user to record the date, I propose having 5 fields i.e. date of stage 1. date of stage 2...

ta! absolutely, if only we did not try to do different things and keep everything simple! cheers for the response. glad to know, I was not staring the answer in the face! regards john

must be a very easy problem, but cannot seem to track down the answer.. anyway to increase the size of the checkboxes within a form??? tried the properties box, but does not seem to change the checkboxes. cheers. john