I'm in trouble big time (1 Viewer)

Dano60 · Sep 20, 2017

Hi,

I'm very much an amateur with access but played around somewhat.

I'm from Canada and I'm French to complicate things a bit.

My boss gave me the impossible task to fix some issues with our database.
The original employee that created that database left town a while ago with it seem a database that is not roll off completely.

So please be patient with me!!!!!! :banghead:

jdraw · Sep 20, 2017

I think this is cross posted at http://www.accessforums.net/showthread.php?t=68130.

Dano60 --when you post the same or similar topic on different forums--advise the readers that you have done so. Show the link to the other post(s).

If you think your English is not sufficient to communicate, then write you post in French; go to Google translate; and translate to English.

I think your English is good enough to communicate. However, I think your knowledge of the system you are being asked to support/modify is weak.

Tell us in simple terms WHAT it is you are trying to do.Not quasi database/Access or SQL. We'll get to that in due course.

I recommend you post a copy of the database.

Hopefully you ar working on a copy of your production database.

Dano60 · Sep 20, 2017

How can I paste a copy of the database on here?

jdraw · Sep 20, 2017

Try this link
https://www.access-programmers.co.uk/forums/faq.php?s=&do=search&q=attach&match=all&titlesonly=0

Dano60 · Sep 20, 2017

Thanks, I will send the complete database tomorrow morning!!!

I'm also afraid to change existing data in the database because it may affect other thing within.

jdraw · Sep 20, 2017

Make sure you make a copy or 2 for safe storage--just in case something goes bad.
You never work on/make design changes to your production database, always on a copy!!

Hopefully your production has some sort of Backup in place.

Dano60 · Sep 20, 2017

Will do thanks for the tip!!!!!

pbaldy · Sep 20, 2017

I moved this out of the introductions forum. The first post seemed like just an introduction to me, but it seems to be moving to technical content now.

Dano60 · Sep 20, 2017

Here what I would like to do. In the frm_DetailProduit_Scolaire_E there is a field called binding color, within that field you can choose various color and also the option "To be determined".
When I click on the View Production Sheet at the bottom of that form, there the above code that calculate a "DateTerminaison", then open the Production sheet (see below the attachment), (sorry guy's this report is only in French) which is printed and sent to the production floor.
I would like to put in that code a vbCritical which would prevent the report to open if in the color field the option "To be determined" is selected. The "To be determined" option as to stay because it's put there for the purpose when the salesman as to send a order form to the client to be approved and sign even though the client as not chosen is finale choice on binding color. The vbCritical has to informed the salesman that he as to change the "To be determined" choice.

All this to prevent the chaos of having a production sheet reach the production floor which would require the production personnel to contact the salesman and to have the said binding to be produce in house according to the querry generate by this program. (about 1500 order to process in 2 month).

Hope this is enough info

jdraw · Sep 20, 2017

????
see attached jpg

Dano60 · Sep 20, 2017

What is this jdraw????

Dano60 · Sep 20, 2017

Oh shit can it be that the database was open when the zip was made?

moke123 · Sep 20, 2017

Jdraw,
You can open it using shift bypass but the error remains. there appears to have only been one module. Additionally the tables are all ODBC linked tables.
hth

Dano60 · Sep 20, 2017

Can you try this one. The other one was compressed while the database was open.

Also the compressed file was done with a Mac (don't know if it matter)

jdraw · Sep 20, 2017

I can't open the file, even with shift..

If moke123 has ideas/insight/suggestions, perhaps he could answer.

Dano60 · Sep 20, 2017

Sorry guy's trying to figured it out too.
Could it be, If the original database is not in a file call Gaupel in my c drive or a shortcut to it. It will only open in read only.

Dano60 · Sep 20, 2017

moke123 said:
Jdraw,
You can open it using shift bypass but the error remains. there appears to have only been one module. Additionally the tables are all ODBC linked tables.
hth

So can you help me with what you are able to see?

moke123 · Sep 20, 2017

So can you help me with what you are able to see?

well, a few problems with that.
*my french classes were 45 years ago so I pretty much forgot it all.
*There are no tables as they are linked by ODBC.
*theres no VBA, mostly Macros

heres a copy with the Macro1 code removed. It opens with shift bypass.

Dano60 · Sep 20, 2017

moke123 said:
well, a few problems with that.
*my french classes were 45 years ago so I pretty much forgot it all.
*There are no tables as they are linked by ODBC.
*theres no VBA, mostly Macros

heres a copy with the Macro1 code removed. It opens with shift bypass.

What about if I put an jpeg image of the code (For the button that that open Fiche de production) the report I dont want to open if in the form at the binding color = "To be determined"

I think that the code to be inserted would have to be just before DoCmd.OpenReport 15 line from the end of code.

I'm in trouble big time (1 Viewer)

Registered User.

Super Moderator

Registered User.

Super Moderator

Registered User.

Super Moderator

Registered User.

Wino Moderator

Registered User.

Attachments

Super Moderator

Attachments

Registered User.

Registered User.

AWF VIP

Registered User.

Attachments

Super Moderator

Registered User.

Registered User.

AWF VIP

Attachments

Registered User.

Attachments

Similar threads

Users who are viewing this thread