Hi I know it cannot be fixed in super quick time.
i can send it maybe you could take a look and tell me what needs doing.
Thanks
Mark
P.S I can offer 50 pounds to sort this.
Thanks
Mark
Mark12345
Last Activity: Apr 4 '07, 12:05 AM
Joined: Mar 12 '07
Location:
-
I solved one problem which was when I opened the db I got an error screen, but that just required me to change the details in the startup menu area.
The rest of the problems still exsist.
When I go into my db I get Syntax error in join opperation.
I can only get into my form in design view.
Can I send it to you so you can tell me what I need to do.
Thanks
MarkLeave a comment:
-
Hi I have an order entry database that has sql errors and god knows wyhat else,
The original template came off the Microsoft website wht a pile of, u know what.
basically I need someone t o loook at it and tell me whats wrong,
I know the SQL has issues and the whole thing neds fault finding.
Can anyone help
I rally hope so.
Thanks
Mark
P.s 2 hours till I have to leave...Leave a comment:
-
7am Deadline Can anyone Help
Hi folks, I wonder in any of you can help me get my database sorted for a 7am deadline.
the problem I think is related to eith sql within my forms or links.
I will be online all night till its hopefully done.
Thanks
Mark -
7am Deadline Help Pls
Hi folks, I wonder in any of you can help me get my database sorted for a 7am deadline.
the problem I think is related to eith sql within my forms or links.
I will be online all night till its hopefully done.
Thanks
Mark -
This is the record source within my AddAnOrder Form reads. tblOrders.Freig htCharge, tblOrders.Payme ntReceived, tblOrders.Comme nt, tblCustomers.Ad dress FROM tblCustomers INNER JOIN tblOrders ON Customers.Custo merID=tblOrders .CustomerID;
Thanks
MarkLeave a comment:
-
Hi I have changed the record source for the addNewOrder to
I have changed the OrderDetailSubF orm to
I haev gone through the queris and changed the sql to the values below headed by query name.
Query Add New Customer and Order Details
SELECT tblOrders.Custo merID, tblOrders.Order Date, tblOrders.Purch aseOrderNumber, tblOrders.Shipp ingMethodID, tblCustomers.VA TTaxRate AS Expr1, OrderDetails.Or derID,...Leave a comment:
-
This is the area I cant get into, im a newbie and I dont know how to write the correct details
Im gonna check through them, im not sure the queries are set up properly.
Thanks
MarkLeave a comment:
-
urgent deadlimeline the morning pls help
Hi guys, thanks for looking. I have a deadline for the morning
My database takes down order details.
Each customer has there own priceid in the price table.
the errors that I get say enter parameter value for:
products.unit price
Unit Price
Discount Price
Maybe a bit of history would help with this, the user said originally that they wanted to be able to give customers a discount on every... -
Hi guys I didnt mention I got to have this done for the morning.
Thanks
MarkLeave a comment:
-
Order Form Wont work
Hi folks, thanks for looking. I have a database that takes down order details.
Each customer has there own priceid in the price table.
the errors that I get say enter parameter value for:
products.unit price
Unit Price
Discount Price
Maybe a bit of history would help with this, the user said originally that they wanted to be able to give customers a discount on every line of stock.
Then realised... -
Cash Job
Hi all I have an order database that takes orders, prints a workk order and an invoice.
When I click on the AddNewOrderDeta ils form, I get an error message that asks me to enter values for price & vat.
I cannot click on any bottons of fields in my form.
I wondered if someone wanted the job of sorting the database out for a fee.
Please pm me so we can address this. I need to have this complete... -
Im still not working erm dont know what to try,
How much would someone charge me to have a look at th database and resolve its issues.
Thanks
MarkLeave a comment:
-
I have removed all the spaces between Table names.
Regards
MarkLeave a comment:
-
I think this is related to the ordersubform
Private Sub cmdAddNewRecord _Click()
On Error GoTo Err_cmdAddNewRe cord_Click
DoCmd.GoToRecor d , , acNewRec
Forms![Add an Order and Details]![Order Details Subform].Form.Requery
Forms![Add an Order and Details]![OrderSubTotal].Requery
Forms![Add an Order and Details]![OrderTotal].Requery
Exit_cmdAddNewR ecord_Click:
...Leave a comment:
-
Hi im not sure what it is you need.
Thanks
Mark...Leave a comment:
-
Morning campers...Leave a comment:
-
Hi is anyone out there lol, thanks for all your help goin bedLeave a comment:
-
You a star what can I say superb. Thanks
I made sure that the orderentry form's record was set as advised.
I did the same for the OrderDetailOrde rForm,
Thinking back with this in mind I may have set up the products raw source to this value rather than what it should be, rather than where it was ment for, the record entry box.
I also ge a Syntax error (missin operator in query expression tblPrice INNER...Leave a comment:
-
so im gonna edit it to
SELECT OrderDetails.Or derDetailID, OrderDetails.Or derID, OrderDetails.Pr oductID, OrderDetails.Qu antity, OrderDetailss;[/QUOTE]
No way that will work.
First I asked for the recordsource form the Orders form and you posted:
...Code:SELECT OrderDetails.OrderDetailID, OrderDetails.OrderID, OrderDetails.ProductID, OrderDetails.Quantity[b], OrderDetails.Discount[/b] FROM OrderDetails;
Leave a comment:
No activity results to display
Leave a comment: