Search results

I wrote a custom function to calculate an average. The function uses Public variables. Query1 has the fields required for the calculation sorted in the correct order. I call the function from Query1 and I get the correct result. The problem occurs when I create a second query, Query2, that...

My database sometimes produces Error 3048: Cannot open any more databases. After researching this on the Internet I now know that it is because Access has an internal limit of 255 simultaneous connections to Jet. A “connection” includes things like combo boxes, recordsets, queries, etc…..and...

My users often export reports in Snapshot format via a form. I would like to give them an "open on export" checkbox. If checked, the exported file would open automatically. The form contains the file path. But I don't know (and couldn't find with a search) the code to then open that file. If...

My Inbox is continually swamped with Junk Mail. Thus far, my ineffective solution has been to add each junk mail to my "Junk Senders List" and delete it. But the spammers constantly change e-mail addresses so the mails just keeps coming. I only recieve legitimate mail from 2 people. So if...

My form has a Memo field that stores "To Do" descriptions. My user wants to be able to add bullet points next to their entries. There could be multiple To Do's in a single field. Any help is appreciated.

I need help with my table structures. Attached is a Access 97 sample of my existing tables. Questions 1) I need a new table that shows which BankRepID’s are assigned to each ClientID. Currently the relationship between the Banks and their BankReps is normalized. But every time I create a...

I have a form that allows my users to enter transactions. The transactions are entered on a subform in datasheet view. At the top of the main form is a continuous form that shows a cash balance figure. On the After Update Event of the subform I requery the continuous form to reflect changes...

I would like to create a form with a double layered tab format that has the look and feel of the MS Access Options form under Tools. What code or technique is required to make this work? For example, how do I make sure when the user selects the front row or back row of tabs that only this form...

I have a bar graph that displays between 1 and 5 categories depending on the underlying data. My problem is that Access scales the width of the bars according to how many categories are graphed. Thus, for 1 category one big fat bar shows up. And when there are 5 they are much slimmer. Does...

I am trying to create a main report with 4 quadrants. Each quadrant should contain a subreport displaying a graph. The subreports are all built. Here’s the problem: My users would like to be able to select which graphs show up on the report (there are 7 possible selections) and their quadrant...

I need help with my relationships and form structures. Attached is a sample database for illustrative purposes. Here are the rules I am trying to follow: One client can have many banks. One client can have many bank accounts. One bank can have many bank representatives. One bank representative...

Hello: My users want to print out data from the database onto pre-printed paper bank forms. That is, they want to place the paper bank form in the printer tray and then fill it with fields from the database. My solution is to create an Access report that has the fields aligned proplerly...

I have a Credit and Debits report that shows an account’s transaction history. It is grouped by currency (e.g., US Dollar, Japanese Yen, Swiss Franc, etc…..). In the each currency’s category header is a subreport with a Starting Balance field. It is calculated by a query which sums all the...

I have a function that performs a running sum calculation. It has a public variable to store the value. I call the function from a query to generate a running balance calculation. It works fine the first time. But if I close it and run the query again it is wrong because the calculation value...

I have a main form with several subforms based on a 1 to 1 relationship. The information on the main form is common to all the groups and is kept in one table. But each group has unique fields so each has its own table. Each of the subforms is displayed on a page. Question: I want the fields...

Hello: I have read in Access Help that using IIF statements in queries does not allow the query to be optimized and can be a cause for slow performance. Simple question: If I create a public function to do my IIF statment operation will this allow the query to be optimized and run at maximum...

Hello: I searched to forum but came up empty. Does anyone have a list of reserve words or know where I can get one? Thanks, Dwight

I want negative numbers on my report to be in parenthesis rather then have a preceding negative sign i.e. I want (10) for -1 but I don't want them converted to string values. Is this possible? I worked with the FormatNumber function but I only succeded in generating errors. As always, I...

Hello: Two questions: 1) Pat Hartman often writes about Access's ability to be combined with true client server RDMS softwars (e.g., Oracle, DB2, SQL Server) and explains that if this upsizing is going to occur that each table must have a unique index. I don't have any plans to upsize but want...

Hello: My issue is odd but I think simple to fix. Here’s the situation: I have a report with a horizontal (rather than up and down the bars go left and right) bar chart graph at the center The range of the X-axis is from -3 to +3. The problem is that if a value falls outside this range, for...