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?

Thank you both for your responses. synapsevampire, your formula worked for me; I just had to change the criteria because I was trying to *include* records with a RESERVE_CODE of 'INITIAL' or a sum of DELTA_AMOUNT greater than or equal to 15,000, which is why I was trying to suppress records...

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

Never mind - my fault. I forgot to copy over frmCalClock from the new version. Thanks again - just fantastic! ------- Kyle

Just downloaded the newest version and copied the basCalender module into my DB; however, now the minutes aren't showing up on the calendar form at all when I specify "DisplayMode15MinClock" in my dblClick event. Any thoughts?

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

This works perfectly - I can't tell you how much time you've saved me in developing an appointment form in my app! I'll give you another star, since my wife won't part with the first-born... ----------- Kyle

OK, hit my first snag in trying to use the code for selecting date and time at the same time. I'm getting "Compile Error: Wrong number of arguments or invalid property assignment." I've added fields to my form named txtDate1 and txtTime1 to test this. Here's the code: Private Sub...

This looks great! What would I have to change to include a 15-minute clock, in addition to (or in place of) the 5 minute display clock? Thanks for posting this - very handy in an app I'm currently working on. Much appreciated!

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

Richard - Thanks for the input. Funny you should mention it, because I spent a good part of yesterday working with sample data and testing my connections to the SQL Server (so far, so good). There's no need to preserve history for this application - "today" is the only time period this client...

Zameer - Thanks for that link - you're right, some interesting stuff there. However, the people I'm working with are not medical providers, they just set up independent medical examinations (IMEs) for insurance companies. Thanks again for the info. --------- Kyle

Ginger - Thanks so much for your detailed response! I appreciate the insight. tblProvider must have a relationship with tblAppointments, because they need to make sure they don't overbook a Dr. on the same day at the same time. I didn't even think of putting the attorneys in tblProviders...

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

Not for nothin', but did you know there's a Recipes Collection template on the MS Office website?