Search results

Now it says missing parameter, here is the sql below, i know you do not like this view but this is how you write sql within the access code, and it only allows you so many "& _ " so have to try and fit them all in.... qryfixed = " INSERT INTO markup SELECT TOP 1 JDE_Customer_No AS [JDE...

hi mail man, I attempted writing the "Union" for the execute of the query, and it simply came up with "characters found after query"... So i tried to write the union so the statement was one large statement including both queries, and unioned these. but it simply came up with...

Hi David, Yea i have tried to include both, if i put both in it says too many paramters expected 2, then if i take one out, it says too few parameters expected 6? I tried to include a VB if statement, then run one query or the other, however i struggled to get the code to recognise...

Hi, the tables i am referencing are there, because everything work great without the IIF in there. but then it is only using either the fixed prices or the normal costs (depending on which is hard coded into the sql), also the tables are not mdb, there are a variety of databases from ODBC to...

hey mailman, yes you are helping, thanks alot!! it seemed everything had gone a bit quiet on me so got a bit frustrated, but i am very grateful for your help!! so would the too few parameters mean it cant pull the data from the original database, in order to put the data in markup, or that...

I also read somewhere that it was "IIF not IFF" so changed them all to that and got a different error - "Too few parameters, expected 6" please help!!!

Hi i now have the error " undefined function Iff in expression"

The last bit is for the min quantity, therefore, it only shows results for the part which has more than the minimum quantity in stock. e.g. price_list.min_quantity (this value shows the minimum quantity allowed in stock) part_select.quantity (this shows the quantity in stock), therefore if the...

hey sorry about the previous post, i hadnt refreshed my page so was replying to an old one, should i be able to enter that sql into the code for my form?

Hey, I'v put the above into a new query, but it just comes up wit the same error. I may have missed something really simple with the Iff statements because iv never written them befor in sql, is it actually possible what im trying to achieve? e.g. find this vaue for factor2 then due to wat...

This is what was in the debug window. INSERT INTO markup SELECT TOP 1 JDE_Customer_No AS [JDE Customer No], Custom2.Customer_Name AS [Customer Name], part.id AS Part, price_factor.use_fixed_price AS [factor2], Iff(factor2='1',fixed_price_list.price,price_list.price) AS [Base Price]...

Hi, thanks for all the help btw, The spaces aren't in my code, they appeared when i copied and pasted it into the reply window for some reason. I put Debug.Print queryString2 befor my dbscurrent.Execute queryString2 and it just came up with the same "Syntax error in insert into statement"

Hi DCrake, the databases for this are ODBC and MYSQL ones held in other locations and by other programs, so i am unable to send you these, unless you know of a way. i could send you the program, but i doubt it would be very useful with out the data.

Insert statement... hi, the reason it does it this way is because it picks up information from the previous two inputted forms and runs queries on those inputs first, then runs another query depending on what company is selected from the latest form, what currency and what company base. I...

Problem.. Hi thanks for your help, i hope you had a good easter holiday aswell. My first problem is my form does not have a query within the "RawSource" or anything. The SQL query written for this is within the "code view" for the sub when the button gets hit. Therefore, when i goto the...

Thanks...but... hi, Thanks alot for the help, so it seems like it is possible what i am trying to do. There are a couple of bugs with this, which i will sort out (i inherited this code from a previous colleague and have only been working on it 2 days), but, firstly where would i enter ...

Help! Hey could some one please help with the above problem, im not even sure if tis possible to do what im trying to!!

Hi everyone, Iv been working on this access program which i have inherited from my predecessor. here is the query (inlcuding the do until loop etc) which i have found i need to modify to do wat i want; Do Until select_part_rst.EOF num = num + 1...