Search results

OK i've added the report i'm on about. If you pick a medicine that is nearly empty then tick the empty tick box it will force the empty status to zero and not show up in the report. This is what i'm after. But when you tab out of the amount box in the subform you have to go back in then back...

A mate of mine had a look this afternoon and he too is stumped !

AmountLeft is not actually a calculation, qtyLeft is a calculation. AmountLeft wants to be equal to the calculation qtyLeft if the Empty tick box is not ticked. The reason is: say the medicine is a 100ml bottle, and 97ml has been used on animals or the expiry date is past. I need to be able to...

Am i missing something but the box you added is the same as the 2nd box down out the 4 on mine - its the 4th box that should be the same as the 3rd if the tickbox isn't ticked

Please could someone help. I am trying to get a main form field to match a calculated field if a certain tick box is unticked but i can't seem to do it. Database is attached. If you change one of the amounts in the subform, you will see the calculated qtyLeft field is updated (due to the...

Database attached. If you change one of the amounts in the subform, you will see the calculated qtyLeft field is updated (due to the DoCmd.RunCommand acCmdSaveRecord) but the AmountLeft field is not updated. In the 'OnCurrent' event for the main form i have remarked out what i thought would...

Nope still no joy. Any more ideas - this is frustrating. I thought i'd tackle it fresh again today but i'm getting back to how i was yesterday now. I just want to set the value of a field the same as another box if a certain tickbox is not ticked, why is it giving me such a headache. I will...

Ok i am pulling my hair out here i am desperate for some help. I am writing a database at the moment (hence my post), i am struggling with something that is doing my nut so i will try to explain the basics here: I have a main form and a subform, the main form consists of a list of different...

tweaked it a bit but its working a treat - thanks for ya help

thanks for reply - will try this on monday morning when i get into the office - will let ya know - thanks again - that was how my mind was working but my fingers weren't absorbing the info properly ! will be back to you

I have adapted the attached searchDB for what i need - it is very good, thanks to whoever created it. But.... What i want to do is have 2 search boxes at the top, 1 that filters down JUST the surname field and a 2nd box that searches other fields to filter. Reason being, i have a applied it...

I have created a list box that shows several columns of information from a query, 2 of these columns are check boxes that appear as check boxes in the query but in the list box they are shown as either a 0 or -1. !! Can anyone tell me how to get check boxes shown as check boxes in a list box. I...

I have two tables that i want to combine into 1 query in date order - the first table contains information such as 'cattle id', 'date of birth', 'sex', 'breed' etc. ... the 2nd table contains Artificial Insemination dates & bull names (serving dates) for cattle. I want to combine the tables into...

Thanks BobLarson - that works a treat - it is what i was trying to do but my form had spaces in the name, i tried adding _ underscores in place of spaces but it didn't work so i ended up renaming all my tables to remove the spaces to prevent future problems. I have another query now if anyone...

HELP with list box http://www.access-programmers.co.uk/forums/showthread.php?t=130278 Can anyone help me with this thread ? I want to know how to select something from my search listbox and use the contents of 1 column to place into the previous form as an entry Thanks

I need to know how to pass a field from a selection in a list box to a field in another form (in Access 2003). I have created a search box that uses a list box to display some records. There is a text box that a user enters details in to filter the list box down to less records. I want to be...

Thanks for all ya help guys - between you i've managed to cobble something up that works. For those interested the code is below. Thanks Again ******************************* Private Sub NewEternit_Click() On Error GoTo NewEternit_Err Dim objWord As Object Dim FName As String...

Yeh, i worked out how to set the filename to save to - i did forget i'd pasted the code before i added the line to actually save the file. But what i need to know is the code to check if it exists before saving and if it is then ask me to do a saveas. Thanks for your reply.

OK - bit of a newbie here & maybe this question has been asked a thousand times but i can't find any answers that cover this question properly. Basically i am writing an access database that stores contract information, contact details, orders etc etc. I want to take the Order Number field...