Recent content by TIMER

I see now what I was doing incorrectly. I was grouping (Group By) my productID, productQTY & costpricePU. and I should have been doing this >>>>>> Thanks Plog for your help. Regards Fergus

Hi I'm trying to create a totaled/calculated BOM Query for each of my bomID's. I have no knowledge of SQL but came across a DISTINCT SQL function while on the web and wondered if this is what I should be using to get my desired result below. product_TBL productID productDESC costpricePU...

I played around with that website you suggested Peter and found another more secure solution to Validation No 1 Like "[a-z]" Or Like "[a-z][a-z]" Or Like "[a-z][a-z][a-z]]" Or Like "[a-z][a-z][a-z][a-z]" A bit long winded but it prevents the end user from possibly entering in digits into the...

Peter your link http://allenbrowne.com/ValidationRule.html provided great help and the suggestion you posted for the 2nd Validation Rule was extremely close. The solution to Validation No 2 I found by playing around with your suggestion was... Like "[a-z]#######" As you can see I just dropped...

I think I have solved the 2nd Validation Rule Like "E#######" But I have decided to use the letter "E" as the first Character and Letter of the required validation rule and using the character # to allow entry of a number only data. What I seem to have a problem is with the letters. I don't...

Brilliant, that one works. Thanks a mil Peter. ;)

Hi, Access newbie here. Just finishing a beginners course on Data Application Management and I need help with 2 validation rules I'm trying to complete for a course lab report. The 1st validation rule I need to create, is one where the text characters are less than 4 in length ie. Miss, Mr...

excel image

Attached is the excel image of what I'm tring to accomplish

I'm trying to develop a simple company price list. I have created a suppliers products table. But I want to use the suppliers products to make up our coded goods (A Bill of Quantities simply). But I'm caught in a certain area that I dont have any knowledge on. I want to create a form / subform...

Hi Newman, Yes I gave that a go and it works, by right clicking on the hyperlink and selecting "Hyperlink" then "Edit Hyperlink", the Edit Hyperlink dialog appears and I changed the email address to mailto:abc@abc.com But its only works with the one record, how can I make this a permanent...

Hi, I'm very new to this database game and have just starting creating a customer information database. But have come across a problem already. I created a form which I've setup a field which contains customer email address, when click on it the hperlink, it trys to find a web site.... "Unable...