Search results

I have been chasing my arse for over a week on this one, It almost works but not quite. One of the subforms will not refresh when you enter new record and the stake ID combo will not keep its default value all of the time. I am hoping that someone might have time to have a look at this form and...

Many thanks, it worked great. It made a lot more sense when I saw it in place. You know, thanks to this forum I am in danger of learning something:)

Thanks for the reply, unfortunately I haven't got a clue how I would incorporate that into my query, Could you please elaborate further. This is the SQL of my query if it helps: SELECT CustomerT.cusID, CustomerT.Prefix, CustomerT.FirstName, CustomerT.Initial, CustomerT.Country...

I am using a query to find records that fall on the following month using the month and year functions. Month(Now())+1 Year(Now())This works fine until we get to December and it all falls down. I know that is due to the year now function but I cant seem to find a way to update it other than do...

Thanks Brian, you're a Diamond. That's a new one for my arsenal.

I am trying to work out how to get a query to return all records from a date starting the month after next. i.e. query runs late December and returns all values from 1st February onwards. I have tried >=DateAdd("m",2,Date()) but that adds two calendar months and does not return the records...

Thanks for the link, I have had a look through and cant see what I am doing wrong. The form re-queries when I select a new record from a combobox but goes blank when that record is saved to the Table. Try as I might I cannot get it to re-query until I select another value from the combo box (the...

I have have a form with 4 subforms in it, one of the subforms is based on a filtered query . For a reason I can not work out I cannot get it to requery when I add a new record. To add a new record I select from a combo box and use a command button to save the record I have tried using this in...

Not quite sure what you mean by explicit. If you mean turn the visible properties to yes. Yes I have and all is fine.

Hopefully an easy one, I have a 2 controls on a form which are by default not visible and a command button to toggle them on or off. This seems to work OK as the controls become visible when they are supposed to. For some reason the label on one of the controls will not become visible. It is...

Many thanks for pointing me in the right direction. I was trying to put it into the combo boxes properties default value. Its easy when you know how!

Solved it thanks to this forum. I cant post the link to the relevant post as I am still a newbie. Many thanks to you all.

Thanks for your reply, could you be a bit more specific. I cant work out just where I set this value. Thanks

Thanks for the advice, that got rid of the #mailto: unfortunately the problem appears to be with the table. I exported it to excel and all of the email addresses are showing the #mailto:email address concatenated onto main address. I am wondering if access 2010 hyperlink field type has any thing...

Hi All I am trying to create a user friendly form to enter a list of competitors entering an event. I would like the user to pick from a list of events and that event to be used for subsequent records until the user changes it. I have used a combo box to pick from a list of events but that needs...

Thanks for the reply, its helped narrow down the problem to the dlookup function. Dim Cusemail As String Cusemail = Nz(DLookup("Email", "invoiceemailQ", "orderID=" & OrderID), "") Debug.Print CusemailIt is returning the expected email address but adding an additional #mailto:emailaddress...

Hi All Judging by the lack of replies am I right to assume that no one has any ideas or is my question to vague. I do hope it the latter or this glitch is going to annoy me far a very long time.:confused:

Hi All I have been lurking for a while now and this forum has helped me enormously in getting to grips with access. Many thanks to all of you contributors. Normally I can find the answers to any queries I have by searching this forum, in this case I am probably not asking the right question so...