Search results

Hello, I have a db that is having some strange speed issues on some very basic queries. Objects that have a rowsource/recordsource with a SQL statment in particular are really slow to populate. Likewise on deactivate/activate the report query seems to reload. I've put breakpoints in every...

Hey guys, In my report's detail section, I need to display footnote references for each detail record that correspond to a footnote below. The report's purpose is to display records from imported transactions in two tables from two different systems, and display the difference. The report...

Re: NT Command Script and Documented Steps to Decompile / Compact / Compile an Access Hey Michael, This script has saved us many headaches! Having said that, I don't think it's running the full process. The reason I say that is because when I run it, %DBfilesizepre% and %DBfilesizepost% do...

I have a report that I'm running in report view. When I open it, it will open the detail sans one column (uses a VB UDF). Then it wipes that. Then loads the detail followed by the UDF column it initially left out. Then it moves to the footer......and it seems like it is going through this...

Hi- I am pretty new to class modules, properties, methods, arrays, etc etc. I'm trying to learn more and in doing so I've run into a snag that I just can not get past. Moreover, it's probably my unfamiliarity with arrays, when to use parentheses, when not to use them, how to dimension them...

Hi, I have a query that needs to have a date entered into it, but the same date needs to be entered into different locations within the query. I know I can make a dialog box come up and ask for user input, but since it is in multiple places, I don't want to have the date dialog box come up...

Hi, I am trying to create aging columns using a sub-select. The query is to list each account, then age the amounts via columns. My problem is that the column it creates with the subselect shows the total amount for all accounts rather than the single one I am trying to resolve. I think I need...

Hello all- Having some trouble with some of my code below. There are times where the strAccountPrefix_LOB variable is either blank or 2 characters. Because it is being dimensioned as 2 characters, when it is blank, it gives me spaces. The spaces return an asc() of 32, but the spaces will...

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...

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...

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...

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...

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...

Hey guys- Having quite the issue with corruption lately and I don't quite know how to even begin to troubleshoot this problem, yet I've found a way to fix it, so I guess that's a start. Here's the dilemma: We're running Access 2003 with Windows 2000 on all of the machines. When my users log...

Hi Guys- I have three tables in this scenario: tblFunction, tblContractorFunction, and tblInvoiceFunction. tblContractorFunction and tblInvoiceFunction have a 1-M relationship to tblFunction yet share FunctionType as the common foreign key (which is actually a text value). I want the query to...

Hi all- I have an excel spreadsheet that has column headers that are identical to the column headers that are in an ADO crosstab query I'm running. What I would like to do is take the name of the excel header and use it to call the column identifier in ADO for a report I'm making. I'm just...

Hi guys- I lost an incredibly large amount of information from my database....and I need some help. Let me give some background: Let me begin by saying this is affecting most of the tables in my back end. Long story short- a record from tblClient was erased, and everything downstream from...

Hey guys! Hope you can help pull me out of a bind again. What I'm trying to do is show all fields of all the records in tblQuoteDetail with a QuoteID of 7. Then show the 'cost' field (stored in tblQuoteDetailContractor) for all related records with ContractorID = 1. If the record does not...

Hello AWF friends- I have a table (tblContractor) that contains all of the employees for our location and their information such as address, phone, ssn, and salary info. Every week the employee submit a report that calculates what their pay will be. The pay report pulls data from...