Search results

Have you tried to DE-COMPILE ?

Guys - I appreciate the feedback, but unfortunately, a deadline looms. The regulatory agency who forced this data entry requirement only complete the detailed specs 35 days ago. The deadline for submission is November 1st !!! I'm going to plough ahead and report back. I am sure there are going...

Thanks for that. I've solved that problem easily: rename the mdb file to an obscure type ".abc"....and then encapsulate in a zip file. The support issue definitely has me worried...no question about that. What ideas do you have for accomodating this data entry requirement ? Note: The guys who...

You make it sound easy. This same client has been awaiting their cloud-based CRM for over 4 years now....it's still not finished. The front-end data entry app is not trivial...it's totally integrated into their CRM....it has cascading lists, cross column validation, multiple domain look-ups...

I have a client who has a complex data entry requirement to support some government compliance program. They have clients all over the world. In a previous version of this program, they had the clients complete paper forms and have them scanned and emailed to their central office for posting...

Are you talking about digital signatures ? If so, where exactly are they offered free ?

Still didn't work....one thing missing: there is no Application.Quit in the procedure that is executed. I am going to insert that conditionally based on Application.UserControl value. I am also going to try to use SendObject to see if that works.

AN update: I got it to run today on my machine. I made a slight change to the command line args on the server machine. We'll see in the morning.....if that fixed it.

I have an Access database update process that is run from the Win7 scheduler. I have attempted to instantiate or reference Outlook and send an email indicating the status of the process. Outlook fails for some reason, but it works fine interactively regardless of whether Outlook is running or...

Appreciate it. If it's False, then it's running on the scheduler.

Without putting a /CMD parameter value in the command line, is there any way to detect in VBA that the current state of the application is that it is executing from a scheduled task ? What's happening is that my Outlook email is failing because a Namespace Logon method cannot be invoked when...

Yes Pat, you got it. It was a VB6 app, but installing Jet is only one part of the process. The VB source code must be recompiled with the new Jet library references. The source was gone so that could not be done. So I built additional functionality onto the application using AC97. That allowed...

Impossible since the system was written in VB6 and compiled with DAO 3.51. Some of the source code was missing and all of the custom controls were missing as well.

Pat - the "long story" is that the client had a huge custom-made CRM built upon VB6 with custom controls. They lost the source code and the custom controls and could not recompile into a later version of DAO to support later versions. So we bolted onto the system an Access 97 app which...

Chris - is that your specialty: finding duplicate posts in forums instead of responding to any one of them ? Time to get a life dude.

I have a client who is stuck on Access 97 (long story). I've gotten Access 97 installed on Win 7 up to SR-1. When I go to install SR2b, I must run some admin programs to unsecure the Windows\Fonts folder. Otherwise, SR2b fails to install. However, after I do that, SR2b installs, but completely...

Access could have been great, but with the poor QA by MSFT, working around all of the bugs really dampens the value...a lot. On top of that, MSFT made a feable attempt to provide a web-based version of Access....and that really makes it of questionable value now that everyone is clamoring for...

=countifs(e2:e3000,"=cb",h2:h3000,"=vaa",v2:v3000,"=vaa")

It doesn't have to be increasing...it's just that a simple implementation of autonumber would always remember the most recent highest value. A more sophisticated one would search for gaps, etc.

Thanks for that Gemma. I have been amazed from this thread on all of the misconceptions of table design....zowie, no wonder there have been so many software disasters recently that were publicized. An Autonumber column as surrogate key SHOULD never have duplicates as it should always be...