Search results

Hi all, newbie here, Please could someone will help me out with a problem i got with my database, i think the problem has something to do with the log table/module i got as i get Run-time error “3201” you cannot add or change a record because a related record is required in table CustomerT like...

this may help http://www.youtube.com/watch?v=A5iXuDq741s peter

Hi all i'm still stuck with this :banghead: this is my query in sql view how can I get NumberOfDups to go into NumberOfScales SELECT First(EquipmentT.CompanyID) AS [CompanyID Field], Count(EquipmentT.CompanyID) AS NumberOfDups, CustomerT.NumberOfScales FROM CustomerT INNER JOIN...

update.....I sorted it :) thanks peter

Hi jdraw, yes I noticed this was a very old post. the only thing I have found to identify why this doe's not work is because both FollowUpEmail and FollowUpPhone are on the same query with Between DateAdd("d",7-Weekday(Date()),Date()) And DateAdd("d",13-Weekday(Date()),Date()) in the...

Hi All, I used Between DateAdd("d",7-Weekday(Date()),Date()) And DateAdd("d",13-Weekday(Date()),Date()) in a query to show records that need a follow up, but its not working in the query I put Company FollowUpEmail and FollowUpPhone both FollowUpEmail and FollowUpPhone have the above...

Hi All I still need help with this thanks peter

Hi jdraw, yes, I used that findduplicates query to get a number from my EquipmentT table for CompanyID (changing the criteria of the dups from >1 to >=1 so it showed all records) I then wanted that number (number of dups) to go into my CustomerT table in my field named TotalNumberOfEquipment...

Hi John, thanks for the reply, I tried using dlookup but all I get is #name? in the field on the form any ideas thanks peter

Hi All, I've done a query with my equipment table for duplicates company names to get a number for my customer form for total number of equipment. how can I get the number of duplicates for each company to be put into total number of equipment in my customer form? thanks peter

Hi CJ London, thanks for the reply, that is working :) thanks again peter

Hi All, I have made a form with a combo box that is for company name and below is subform with datasheet for equipment. what do I need to do to only show equipment from the company that I choose in the combo box. I just can't get this to work thanks peter

thanks Solo712, that now works

I did try that, but I get a error cos it not a sub, it a function so I changed the end bit from exit sub to end and when I click on my button to exit and save it does nothing, when I close using the X in top right corner it says cannot save this record at this time :confused: I changed the...

Hi Solo712 thanks for the reply, I think I didn't explain correctly.....on a new form when putting data into a field it records the new value even though the old value is blank, that is what I want to stop being logged(as I would have too many in my log table), after that if the field has...

anyone got any idea how to sort this for me. I've been messing with the code to sort it, but still unable to do it thanks peter

Hi jdraw, lol, I misunderstood what this done, for some reason I thought it added a prefix to the field name and the control name :o thanks for the reply peter

Hi all, not sure if the code below works or not so can someone test it for me. I can get it to run, I input the form name and it says conversion complete, but when I check the form in design mode the name and control are still the same with no prefix I made a macro for this to run...

Hi StarGrabber, yes that's all, thanks for that works the way I need. I don't have code that unlocks QuoteNeeded, but would like to be able to at some point (just incase someone clicks QuoteNeeded by mistake), maybe a button that when clicked asks for a password before QuoteNeeded could be...

Hi nschroedor, I tried your codes, but it didn't work :confused: this code was red If IsNull(varNew) "" then Exit Sub thanks for your reply peter