Hi,
When he IIf statement below is run the following error occurs,
Runtime Error '3061': Too few parameters. Expected 1.
IIf((Customer = 'Shell Uk Ltd') and (Participator = 'SHELL UK LIMITED'), (Template_Name = 'Crude - SUKO - ' & Crude.F5), (Template_Name = 'Crude - Third Party - ' & Crude.F5)))
Thanks
Towsie
towsie
Last Activity: Feb 20 '08, 04:51 PM
Joined: Jun 27 '07
Location: Aberdeen, Scotland
-
Hi,
I have changes the statement to
[code=vb]
("Select origin_of_sale as Origin, Category, Crude.F3 as Customer, sales_terms, autolift, load_point as lp, Crude.F11 as Vessel, Crude.F2 as CONTRACT_NO, VALUE_ONLY, invoice_unit, Ledger_unit, Contract_date, template_name, acct_to_group_c onversion as conv, Crude.F5, Crude.F6 as quantity, Crude.F8 as tax_quantity, Crude.F1 as participator, Crude.F14 as invoice_no, Crude.F9... -
Syntax Error
Hi,
I would be very grateful if someone could have a look at the staement below and help me find the Syntax Error.
[code=vb]
("Select origin_of_sale as Origin, Category, Crude.F3 as Customer, sales_terms, autolift, load_point as lp, Crude.F11 as Vessel, Crude.F2 as CONTRACT_NO, VALUE_ONLY, invoice_unit, Ledger_unit, Contract_date, template_name, acct_to_group_c onversion as conv, Crude.F5, Crude.F6 as quantity, Crude.F8... -
Thats what we are going to do.
Thanks for help.
TowsieLeave a comment:
-
Yes, it does seem like that but it's strange that it has worked fine for years until we started testing with 10g.Leave a comment:
-
It always seems to fall over when trying to get data from a table. The front end is Access which isn't exactly the best and the errors don't seem to that helpful.
Most of the errors are,
"Object variable or With block variable not set"Leave a comment:
-
Hi,
I am able to connect ok. When using some of the functions that the application does it throws up errors. These do not appear when the application is connecting to Oracle 8. We are just trying to determine what is cauing the errors and we thought it would be a good idea to make sure that 10g will work correctly using oracle 8 drivers.
Thanks
TowsieLeave a comment:
-
Using Oracle 10g with Oracle 8 drivers
Hi,
My work wish to move some of it's applications that conect to Oracle from 8 to 10g. I was wondering if someone could tell me if it is possible to use Orace 10g using Oracle 8 drivers?
Thanks
Towsie -
Everything is fine with respect to that. I read somewhere that if both of the values you are dividing are 0 than you get a runtime error 6. I am pulling data from a spreadsheet so there is alot of data being uploaded so I really need this to work as its stops the rest of the data being uploaded.
Cheers
TowsieLeave a comment:
-
Runtime error 6
Hi,
I am currently receiving a runtime error 6 when I run my code. The code divides two values to get another value. I know that the problem is that some of the values are 0. Is there any way round this?
Cheers
Towsie -
Hi all,
The error has been resolved thanks to your help, it is greatly appreciated.
Cheers
TowsieLeave a comment:
-
Hi,
The where condition is used to make sure that the correct data is input for each record in the recordset. I am just using that template at the moment to make sure that the correct data is being input into the table.Leave a comment:
-
Hi,
None of fields are null, I have removed the quotes from the numeric fields and and added the # for contract_date but I receive the same error.Leave a comment:
-
I have already tried that but there was no success.Leave a comment:
-
I have now solved this error, but now I am getting runtime error 3137: Missing semicolon (;) at end of the SQL statement.
[CODE=vb]If rs.RecordCount = 0 Then
Else
rs.MoveLast
rs.MoveFirst
Do While Not rs.EOF
strSQL = "Insert into t_sales (product, category, customer, origin_of_sale, load_point, vessel, credit_period, sales_terms, shipping_terms, contract_no, vat, invoice_currenc y,...Leave a comment:
-
Hi,
I have changed my code to
Set rs = db.OpenRecordse t("Select product, category, customer, origin_of_sale as origin, load_point as lp, vessel, credit_period as credit, sales_terms, shipping_terms, contract_number as contract_no, vat, invoice_currenc y as curr, autolift, value_only, export, invoice_unit, tax_unit, ledger_unit, contract_date " & _
"From...Leave a comment:
-
Runtime error 424
Hi,
I am having a problem with code below, I am getting a runtime error 424: Object Required.
The section of code in bold is where the error occurs.
Any help would be greatly appreciated.
'Allows user to upload Enterprise SGD Sales from Excel Spreadsheet
Private Sub butEnterpriseSG DUpload_Click()
Dim db As Database
Dim rs As Recordset
Dim... -
Access IIf statement
Hi,
I have a query in access that takes information from one application and imports it into another.
It imports product sales. In the application that it takes the information from two of the products are Butane and ISO-Butane but in the other application they are both just Butane.
I need to write an IIf statement that, if the product is equal to ISO-Butane it will change it to Butane and if it is any... -
Hi,
I have managed to solve the problem.
It was just me being an idiot!
Thanks for your helpLeave a comment:
-
Hi,
I still get the same result. It doesn't seem to so anything.
CheersLeave a comment:
No activity results to display
Leave a comment: