Recent content by AggieLJ

I have been reading some threads that Application is the new DoCmd... any opinions on the two? Any major limitations of one vs the other? I have my entire database written with DoCmds but if the majority agree that Application is more efficient, then I will update accordingly. Thanks for your...

I finally have an update... I started with the complete Invoice, then subtracted one thing at a time until there was nothing left. Complete Invoice: 21 secs - Footer srpt: 21 secs - Notes srpt: 21 secs - Totals: 16 secs - Dividing Line: 12 secs - Refunds srpt: 12 secs - Payments srpt: 11 secs -...

Our other reports with 100-200 records each open almost instantaneously, even with the same header as the invoice. Our invoice is the product of about 12-14 tables... The people I work for are concerned about hitting the 2 GB limit, as a consequence, the laboratory testing data each has its...

I have built an Invoicing system for the company I work for. I have attached a example copy of the invoice I designed. The only major issue I am having with my system is that the report we use as an invoice is slow opening (around 20-40 secs) for one page. This report has multiple sub reports...

Well, I was kinda anticipating some kind of "How many Aggies does it take to ...<insert some task here>? " joke that all of us Aggies are used to, but a UT (or as we say t.u.) moment probably describes it better. Thanks again for all the help you guys provide, not only on this thread, but...

Nope, everyone gets to download the same copy of the front end off of the server (thanks to boblarson's FE update tool). I really don't know what I was thinking about individual tables... Like I said... Aggie moment...

Now that you mention it... it probably would make more sense to just have one audit table and simply have a field indicating which user is doing what... Thanks for jogging my memory on normalization... I had an Aggie moment... :p

Sorry for the confusion, I guess a little more background would help... :o When an admin creates a new employee, all of their information is stored in tblEmployees in the SystemLog BE. However, there became a need to track what changes certain employees made to customer records. Therefore...

Howdy, I am working on a project that includes a BE file, and two FE files. One FE is a control panel for the admins to adjust security settings, look at audit files, etc., while the other FE serves as the data entry point for lower level users. Right now, when a admin creates a new employee...

I figured it out... I had totally forgotten about the Public Subs within a form... Here is how I wrote it... Public Sub ErrorCatch(strProcedure As String) Dim strModule As String strModule = "Form_frmCurrentStuff" 'ErrorLog is the function I have to log errors...

I have made a public function that logs runtime errors. Do I have to write a "On Error GoTo Err_SpecificProcedure" to call the function from EVERY procedure in EVERY form, or is there a way to write a "universal" function ONCE per form that will call my ErrorLog function from any procedure...

That did it... Thanks and Gig'Em!

Howdy, I have multiple FEs across our network, and every user has their own printer. When a report is printed from a computer other than mine, Access 2007 brings up a dialog box saying that the Report was previously formatted for another printer (my printer), and will confirm that they really...

I figured out a way to not only check for duplicates, but to also find the nulls (in case the user deletes an entry after adding it) and make the form move all the entries to the first open box on the form. Here it is... Private Sub cmdContinue_Click() Dim Records As Integer Dim Count...

I had originally thought I could define some string to output the control name I want, but i guess not... Private Sub cmdContinue_Click() Dim n As Integer Dim x As Integer Dim Control As String Dim Check As String n = 0 Do While DCount("idrPaymentNumber"...