Search results

Hello everyone, I have a form with an unbound control linked to a query. So I can put an item name in the control and the query returns all records for that one item. For example, in the query criteria I have 'Like [forms]![formname]![itemname] & '*'). Is it possible to use the same underlying...

Hi, i've given it a go but it says I can't opened an operand without an operator! what do the commas do exactly? thanks Sue

thanks for the help. I still couldn't get it to work for some reason but I managed to make some unbound controls instead and with conditional formatting I have made them work like a button. cheers, Sue

Hi, thanks for the reply. I'm not using buttons, just an unbound box that changes colour, so I thought I could use the on click event to get it to open the form with the correct record. It is this part I'm having difficulty with. I tried using a Macro with a condition but can't get it to work...

Hi, I have a look around the site but can't find anything that either helps me or that if it does I don't understand it!!! Any advice would be great! I have a continuous form and as I have found out have had to use conditional formating to hightlight buttons (unbound controls) to appear...

Hi, i've found the condition part and it's almost working. However, the button only appears if I click on the 'Washed' when the form opens. I would like the button to appear on entry, since this is not a data entry form. Also, it is a continuous form and so I have several buttons, but they...

Hi, this looks interesting. I can see where to put everything except the condition part. Where does that go? thank you for your help, Sue

Hi I would like to make a command button appear on a form only when certain criteria is put in a control on the form. For example, one of the controls has a drop down menu. When the user picks "Washed" from this menu I would like a comman button to appear. The control is called status and...

Hi, i thought I would need a new table for the proj refs. Do you know where I can find the code as well as how to put it in? thanks for all your help, Sue

Hi, I am using Access XP. I have a table for experiments - tblexp. Each experiment can have one or more projects within it. So I have a drop down list of the various projects in a separate table - tblprojref with fields project no (projno) and project title (protitle). When I am setting up a...

okay. I've managed to get an email sent when I open this form up. How can I get it to only send when the finish = yes?

? How do you 'bind' the form to the query?

yes I think I see what you mean. Let me see if I can explain what I want. When a new request is made the following information is put into the table (yet to make a form). Request Number When the request starts When the request finishes. Any other relevant info. The email address of the person...

I was nearly there!! Thanks you make it look so easy!! Is there anyway that if the result is 'Yes' I can either get an alert box to say so or possible even send an email i.e. RequestNo RequestStart RequestFinish Finished? Email Address I have very little experince in coding by the way...

Thanks you that's much better. However, how can I make it so that it remains saying 'Yes' as once the date passes they will no longer match and so even though it is finished the result will say 'No'. I was trying to put int something like IIf([Finishdate] = > Date(), "Yes", "No") but this...

Hi, I have looked through past threads but can't find the help I need! I have a table with the following : ID RequestNo Startdate Finishdate Can I put this into a query and use an IIF statement to tell me when each request has finished. Something like IIF([Finishdate] = Now(), "Yes","No")...

That worked really well. How would I change it to meet codes like 123A-1A1? I thought about changing the number from 2 to 8 but this didn't work? Can this be done?

Ooo you are good at this aren't you?!! Thank you so much for that, it's going to save me so much time! thanks again Sue

Sorry I forgot the page doesn't hold the layout as it should so there should be gaps between the different columns.

What does normalised actually mean?! I'll have a go at explaining: Table 1 has Experimental Code Date started Experiment Finished? 1A 01.01.01 no 1B 01.02.01 no 1C...