Search results

Damn, I still can't get this thing going. Have attached sample db - Object is to be able to add a new record on Form3 after clicking on the magnifying glass on Form1

Still no go. [SightID] comes from a subform on form1, [ssl] is on form2 [SightID] is also on form2 tried latest if me.newrecord THEN [ssl] = [SightID] end if but no value was entered for [ssl] so couldn't save record

Thnks for that - tried if me.newrecord [SightID] = [ssl] end if but if me.newrecord was objected to by VBA then tried [SightID] = [ssl] and was told it could not find the object I was referring to

in this case, you need to explicit set the value you need in the forms "before update event" (maybe just for a newrecord also) ???? once again in plain English (my VBA is very poor)

I have a form which contains a subform (continuous data). In the subform the is a command button that opens a new form (to a specific record). All functions normally except when I try to add a new record on the second form. The macro created on the command button is 2frmSightDetails, Form, ...

OK, the draw has been made - anybody brave enough to tip a winner? My hope is one of the African countries gets up, because of their great entertainment over a number of years, Cameroon would be nice

Try 0 (false) or -1 (true)

?? "*" all records should show Can you post the database?

Where does it get "" from? It should either be "*" or the value selected from the combo box

For each of the three comboboxes, on formload [comboxx]="*" So if you make a selection on 1 combobox, the other two will be "*" If you then clear the first combox and select another one, the same process will occur

In AfterUpdate event for the combobox add If IsNull([combo11]) Then: [combo11] = "*"

Try here http://www.access-programmers.co.uk/forums/showthread.php?t=177560 I was trying the same thing athis is a working solution

Does this meet requirements?

So what have you changed?

My interest in this concept was sparked by thinking back when I was working, after a 12 hour Saturday and an 18 hour Sunday, by Tuesday lunchtime I had racked up my mythical 40 hour week - and no, I was not being payed overtime for it and worked the rest of the week (10-12 hours a day) Why I'm...

ProgramID is a text field - you'll be struggling to link that to a numeric one

muchos gracias

So, I have three fields (numeric) formatted as 000 and show up in queries as 001,010 025. When using SYS & "-" & ASY & "-" COMP , the leading 0's are removed and it shows up as 1-10-25. What's the trick to retain the 3 characters??

You would need EesPercentage in a new table, linked to employees with an expiry date

How does everyone handle different screen sizes? Badly!