Search results

Hi All I need help with allocating a value for a group of products I have products A1, A2, A3 , A4, A5,A6, A7. A8, A9, A10, B1, B2, B3, B4, B5, B6, B7 etc. A1 to A6 have a category Bags A7 to A10 have a category Sacks B1 to B3 category Rolls B4 to B7 category sheets Instead of listing each...

Hi All I have a form with a subform that requires inputting invoices from suppliers. For quite a lot of them, the majority of the information is a repeat of the previous invoice. Is there a command function that I can use to copy all the information from the previous record and insert them into...

Hi All I am so close to a solution that you have helped me towards. I am stuck at a syntax in a query. The following query works fine SELECT QPostCodeCharges.Charge FROM QPostCodeCharges WHERE (((QPostCodeCharges.Courier_Company)=forms!FolCustDN!Cust_Transport_Company) And...

Hi All I need help with a code for a DLookupFunction. I will try to attach my simple database The database has 2 parts to it. The first part One part is for inputting the delivery charges for a postcode prefixes for Freight Companies (in my example it is ADD and FR). You can see in the...

Hi All I am desperate for the correct syntax in the following: If condition1 Then Statement1 If condition2 Then Statement2 Else: MsgBox "Do X" I am getting an error on the Else: MsgBox Line Can someone PLEASE HELP Rob :)

I have a simple syntax problem that I want help with. On an after update field in a form I have the following code "If Me.Cust_Del_PCode.Value Like "EN9*" Then Me.Delivery_Cost.Value = "55" If Me.Cust_Del_PCode.Value Like "BD1*" Then Me.Delivery_Cost.Value = "65" Else: MsgBox (“LOOK UP THE...

Hi all....I am a novice on access and have a very basic knowledge and I need help with VBA coding. I have made an Access 2003 DB. I have a form with Field1, Field2, Field3, Field4. Field1, Field2, Field3 are address fields, but people have used all 3 fields to insert post codes. I need a...

Hi all....I have an Access 2003DB. I have a form with Field1, Field2, Field3, Field4, Field5, Field6. Field1, Field2, Field3 are address fields, but people have used all 3 fields to insert post codes. Field4 and Field5 are comobo boxes with the following selection options: Field4 - 0.5 and 1...

Hi People I have a very basic knowledge of Microsoft Access 2003 and using it, I have built a rudimentary Access database for our family business. But, now I need it to be a bit more sophisticated if possible. I have used the threads on this site when making my database and I am in awe of...