Tricky calculation to perform

[leeli67]

I dont think I did. is it the runtime update I need cant seem to find the version for me. I have 32bit access 2010



EDIT: k so on further inspection it would appear im up to date , with alot of updates in the past few days I have the Office Sp1 which I think includes the access updates.

[jzwp11]

To verify, go to File-->Help. Then on the right hand side of the screen you will see About Microsoft Access Click on the link: Additional Version and Copyright Information below the version number. In the first line of the window that opens you will see the version and if it has been updated SP1 MSO should be shown.

If all of that checks out then I am at a loss.

[leeli67]

Attachment 7072 Damn ,Cant imgaine what it is .?

[jzwp11]

One last option is to create a new blank database and import everything from the old one and see if that works.

[leeli67]

if that doesn't work is there a way to just goto the last order rather than filer it out, so as to simplify the code?.
Lee

Edit: Just been trying the standing orders again and one thing I notice

1. Select Ravens Billericay
2. Select friday order For this friday coming.
3. Order form opens with this coming fridays date in date box and order detail all correct.

NEXT

Delete that last order and the order detail.

Compact the DB cloase access

then start again open the CreateOrdrFromStandOrder form

1. Select Ravens Billericay (Same as Before )
2. Select This monday coming (Different day than before but still in the upcoming week)
3. Order form opens but (blank) and on the next order number .

so in summary it would appear that the day of the week I select gives me a problem. Dont know if that narrows it down any , im continuing to try different customers and days to see if a pattern emerges.

cant open olivers monday order but can open friday orders

i can open ravens billericay orders fine no problems , could it be some reference to a customer error?

do you get an error with olivers as the customer and monday as the day ?

[jzwp11]

I tried what you suggested (with the copy of the database you most recently posted) and still could not duplicate the error you are experiencing. Everything worked exactly as it should. I'm stumped.

[jzwp11]

OK, I reworked the code in order to try something different. Let me know if the attached DB causes the same problem.

[leeli67]

Thank you JZ I will give it a go., looking Good ,

EDIT: The orders I am trying are working now. What was it ?

[jzwp11]

In my original code, I used an ADO recordset followed by the append query which I executed via DAO. I have done this before in other databases without issue. When I took your database and tried to add the DAO object reference, I got a conflict error which prevented me from adding the reference, so I started to think that mixing the ADO and DAO code might have been at the root of your issue. So I decided to replace the append query and DAO code with corresponding code to do the append via ADO recordsets. The code required one recordset to pull the applicable standing order detail records. Then I looped through that recordset and appended each new detail records for the new order via another ADO recordset.

[leeli67]

argh ...just found a day that doesn't work , let me try all the possibles and let you know, but can I just say many thanks for sparing me the time, its much appreciated and be safe in the knowledge that I am definitely picking this all up #LearningFast

[jzwp11]

I did a quick search and found the ADO equivalent execute statement to the DAO I used previously. Could you test the attached database to see if it functions properly? (It seems to work OK on my computer).

[leeli67]

Hi Jz tried the new DB and somethings changed I can only perform that create order from standing order for next monday the 16th
ie choose customer and a monday order , So because its monday now it opens the order form (Filled) with the 16th as date (next monday) all good so far, but then go back to standingorder form choose the same customer (I actually click on the customer box and select the same one again) then choose the tuesday and order form changes to blank again (same problem)

Summary: I can only open orders for Next monday (this day next week) ?

I dont want to waste your time , so dont worry about trying to figure it out , if it works on yours but not mine , I'd better take a look at my set up.

the only thing I would ask is if it could be modified to simplify it so just the last order entered is shown rather than a filter.
many thanks again.

lee.

[jzwp11]

Have you verified that a new order and the order details are correctly created (even if the form does not show them)?

Out of curiosity, what is your date format mm/dd/yyyy? or something else?

I did some slight changes to the attached. Please see if this causes the problem.

[jzwp11]

Attached is the database with the form going to the last record as you requested.

[leeli67]

date format is for me in the Uk dd/mm/yyyy.

just going to look at the last Db you uploaded

Compile error on the first DB, just looking at the go to last one now.

hmm the last order one , only shows the first order i put in , subsequent orders are not shown . as in the Order form wont update

it think it might be a date format / problem.

Anyway JZW thanks for all your help , I fear i'm taking up to much of your time, maybe if I look into the code more I will find the answer, One last thing , which section of code have you been working on with the adjustments.? the trouble is this is even all before I try and have the order automatically appear depending on what day it is , These databases are a real work in progress.