Recent content by itsuit

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