Search results for query: *

I use an Access 2000 report to create checks based on information in an external ODBC database. I'd like to have the user alerted if a check number in the report is skipped (the check number comes from a field in the external view and is stored as a number). Any help is appreciated.

When I place images in my layout tables in Design view, I can't see the actual image - only the red "X" in the upper left corner (however, the size of the image is represented, and I can work with the Picture Properties). I can see the images just fine in Preview. Any suggestions?

I'm trying to write a formula to suppress details for records that don't meet 1 of 2 criteria. What I've tried looks like this: {RESERVE.RESERVE_CODE} <> 'INITIAL' Or Sum ({RESERVE.DELTA_AMOUNT}, {CLAIM.CLAIM_NUMBER}) < 15000 This is being done via the formula button in the Details Section...

This was originally posted in Access Modules, but I thought it might be more appropriately posted here: I work for an insurance company, and the person in the job before me set up an Access form to print 2 reports at the same time (checks and Explanation of Benefit - EOB - forms). If a check...

I work for an insurance company, and the person in the job before me set up an Access form to print 2 reports at the same time (checks and Explanation of Benefit - EOB - forms). If a check is linked to an EOB, Access should first print the check, then the EOB immediately behind it. If the...

I had posted this in Access Forms and Access Other Topics, but didn't receive any responses; hopefully this is the correct forum for my question. Environment: Access 2003 ADP (SQL Server 2K backend) ---------------------------- A little background: I'm building an app that allows a third party...

I had posted this in Access Forms, but didn't receive any responses; hopefully this is the correct forum for my question. Environment: Access 2003 ADP (SQL Server 2K backend) ---------------------------- A little background: I'm building an app that allows a third party to schedule appointments...

Environment: Access 2003 ADP (SQL Server 2K backend) ---------------------------- A little background: I'm building an app that allows a third party to schedule appointments between doctors and patients. I've created a form that allows the user to choose the patient (claimant), then choose a...

I found a sample database that contains a form I want to study for code examples; however, when I try to launch it, Access 2003 tells me that I'm missing Axctrl32.ocx. Checking references proves that to be true; however, I can't find that file anywhere to install it (I've searched my Office...

I'm now at the "can't see the forest for the trees" point with trying to figure out how to form relationships with these tables, and it's making my head hurt. Can anyone help me figure out how to join the following: SQL Server 2000 backend, Access 2000 front end: I have the following tables...

The following code was written by Helen Feddema and posted on her website to be freely downloaded. It's purpose is to backup the current database; however, I've split my DB and would like to back up the backend at the same time as the frontend. You'll see my additions anywhere "BackendDB" is...

I have a database field ("DESCRIPTION") that allows carriage returns when the data is being entered. In my report, I only want to include text entered prior to the first carriage return (discarding everything after that). Can anyone help with the formula for this? Thanks in advance.

I have an Access 2000 database that stores employees' time off requests which are submitted via an ASP page. The database consists of two tables (&quot;tblUsers&quot; and &quot;tblRequests&quot;) and a query (&quot;qryTimeRemaining&quot;). The query is used to show users (on a different ASP...

Access 2000 Some background: I run two reports; one is a check, the other is backup information for the check (the two are linked on a field, &quot;CHECK_KEY&quot;). Depending on the day, there may be 250 checks plus backups to be run. Currently we have to combine the two by hand, which takes...

I know this has been asked before, but I can't find a definitive answer. Using CR9: Is it possible (within the Crystal Reports Designer) to designate different printer trays for a main report and subreport? I print checks on blank check stock from one report, then print supporting documents...

Using Crystal Reports 9 A little background: Our company pays medical bills to doctor's offices. We issue checks on check stock and 'explanation of benefits' forms on plain paper. The two are then matched up after printing. We'd like to be able to print both of these reports at the same...

Using Crystal Reports 9: I was given the following to use with CR6, but it won't work in CR9 - I get an error telling me that &quot;the number of copies of the string is too large or not an integer&quot;. NumberVar x; StringVar tmpString; tmpString...

Access 2000, Office SR-1a, SP3 All machines are running the same version and service packs of Access 2000. I designed a database with forms to assist in data entry. The DB works fine on my Win2K machine; all vb items work as designed. However, when other users try to use the DB, buttons...

I've created a database for expense reports, and want to allow users to add multiple records at once. There is a table for Reports, with a separate table for Report Details (one report can have many details). How do I design this in FrontPage to make this happen? The details page would be...

I have a form with 2 date fields (Start and End dates). I'd like to allow the user to just type in the numbers without having to remember the &quot;/&quot; between. I know I've seen this done, but can't find an example now and it's driving me crazy. Any suggestions? Kyle