Search results

Nice analogy. Its for a security review across several accounting software systems. Want to go through list of user's system access and then pull the user supervisor's email address (or just name for that matter since it's all internal anyways) so we can email the manager a list of employees...

Yeah, but we all know there's that nice warm fuzzy feeling about live data that a batch just doesn't provide. I just need to learn my way around Outlook VBA one of these days :rolleyes: Thanks for the input though!

No warning needed, Outlook's security is tight and justifiable so. But I'm avoiding that route at all costs. I looked at that VB code, but I'm terrible at converting it down to VBA. The query is unbearable, I mean like an hour minimum to process, then everytime I nav the query, it takes...

I have a table linked to our Outlook Exchange Global Address List. This list is spread across many locations worldwide and I'm not quite sure where the actual server is housed. My problem is that there are over 64,000 records in the linked table, and it is being brought over as 255 char...

I should have mentioned this is a dummyproof thing. This is among the beginnings of a daily import and I want to make sure the old stuff is gone. What better way than to delete the table? I guess I just don't want to make a big deal coding something that might not ever happen. As for the...

Sometimes 'tblPeoplesoft' will be missing, sometimes 'import' will be missing. DoCmd.SetWarnings False On Error Resume Next CurrentDb.Execute "DROP TABLE tblPeoplesoft" CurrentDb.Execute "DROP TABLE Import" On Error GoTo 0 DoCmd.SetWarnings False Either way, I just said screw the errors...

SOLVED: Difference subreport calculating out to zero Ahhh, makes perfect sense... I programmed one field and got it to work. Now I just have to BTW, thanks for bailing me out on the post from yesterday regarding the day and night employees. I tried to help that guy but had no idea where he...

Sorry, I forgot I only 'splained the reports. Data is all coming from one archive table which records the date the record was archived. So essentially I have 2 subreports pulling from one table. Table is all transactions which roll up into account numbers on the report (which is why I...

What fields are in your table?

Should I not use a 3rd subreport? How would one go about getting the variances?

FWIW, this is my first time trying my hand with subreports, so I had a feeling I was going to have trouble, but the fact I didn't get a long line of #NAME errors kinda makes me hopeful.

detail section

Are you using a form to drive your report? I don't think you can put a dropdown on an actualy report... Where is your dropdown listsource? I'm thinking you make a form with a listbox and when you make a selection, it opens the report. When it loads the report, use the open event to set the...

I have a report that contains 3 subreports: -1 Current Period (Control Name: [subReporta], Access name: [subReport 19a - Exception Items Trend Analysis CP]), -1 Prior Period (Control Name: [subReportb], Access name: [subReport 19b - Exception Items Trend Analysis PP]), and -1 Variance...

SOLVED:Report Header on own separate page Moved subform to detail and turned visible to ON! D'oh! Thanks anyways, Joe

Hi all- For some reason, my report header and page footer is in Print Preview on the first page by itself w/o title and detail. This works fine in Report View. Pages 2+ have the page footer at the top of the page again (which is correct), one instance of the title(also correct) and the detail...

What I am trying to do is list all of the TRecsaccount data and the corresponding counts and sums of debits and credits separated out into columns. Each record is notated DR or CR in the DRCR field for Debits and Credits respectively. What I did was made a query grouped by TRecsaccount, and...

How are you populating the tables? Are you using bound or unbound forms?

Maybe it's just me, but I've come to prefer the Access 2000/2003 ULS and in fact it is the reason I build my databases in 2003 still. Maybe I'm not seeing something.... While I'd love to get with the times, I still find enough usefulness in the good ol' ULS model to keep building in 2003...

Fair enough, withoput having a complete windows xp network, it is hard to say, however I can't tell you how many times I've tried to opena form only to get the infamous "There is insufficient Memory to perform this operation" error. Take that days work and just throw it out the window...