Search results

Hey everyone, its still not inputting any of the customer information into the "markup" table. and i cant see why

Sorry i was talkin about the code directive and [ ] and /code thing what i didnt understand.

Sorry i dont know wat u mean

Hey thanks, I have now changed my code to make it more readable! I put in the new code, and now i come up with a type mismatch error, and i have found that it occurs in these lines; queryString2 = queryString2 & " part_select.BOM, " & _ queryString2 = queryString2 & " part_select.BOMName, " &...

hey there are at least 2 iif's in the query so not sure what you mean by "Since there no IIf in the query" ?? The iffs are needed to either look at one number or look at another, depending on wat the value of "Use_fixed" is. The code is based on some which is already in use. which works...

Hi the code works fine before i inputted the iif statements, and started using the QryPrices instead of the raw databases. so i dont think its anythin up with the format which it has been written.

Hi Rabbie, here is my query... written within the Visual basic for the form which i use. I apologise for teh way the code is written, its just the easiest way to write it in the Vb but not the easiest to debug. queryString2 = " INSERT INTO markup SELECT TOP 1 JDE_Customer_No AS [JDE Customer...

Hi David, im getting this error when it runs the query... dbscurrent.Execute queryString2...

Hi guys, i have done the modifications, as far as my basic knowledge makes me believe, correctly. i now receieve the error "Query input must contain atleast one table or query." Any ideas?

Hi guys, eventually got everything here up and running. Thanks David, that union query was a great help, however, im still struggling with the IIf()'s, but will keep plugging at it.

These are some interesting posts guys lol. Iv been back in newcastle all weekend, and now we are still having problems with our servers, so still unable to test.

Hey thanks alot guys, even i knew what derogatory meant lol. I tried to tell you guys this is only my second week using MS Access, so its all currently stil alot of trial and error. Very greatful for your patients. Our systems our down this afternoon tho, so i am unable to try these comments...

i am sorry but i dont understand how i add the union as a subquery, all i know is how to extend the query " & _ " or query = query &...

Hi David, I need to use an "INSERT INTO..." which you cant use with a "UNION" :S

ah thanks, ill give it a go and get back to you!, cheers!

hey, iv never wrote a join before, would i do an inner join? wat would be the syntax? how does a join work? and as of yet i have not seen an iif work. :S

Hi david, my progress is minimal, after much testing found that i cannot use the union in the way i need. I tried using a very big if statement written in the vb code, but have yet to get it to work. Any possible solutions would be greatfully accepted!! :D

hi that was just a mistype in my post, not the code, coz i couldnt copy and paste the error message so had to simply re write it.

Hey, that space was put in by this quick reply box at the bottom, and it not in the code... each section of the code works fine on its own (i.e. the code for fixed prices works perfectly for fixed, and the normal works fine), but when they are combined for this union they do not work... I put...

hey guys... i have tried debugging it, and putting it in a query window, and it comes up wit the same error - "Syntax error - (missing operator) in query expression 'part.id = part_select.part AND fixed_price_list.part_id=part.id AND Custom2.JDE_Price_Group=price_factor.customer_group AND...