Recent content by duckster

This does work, with a bit of difficulty though (and meticulous joining of the lines from one section to the next)... but in the end, it does still work. Thanks. I will also check out the website mentioned! Cheers

Hi, I have a report which has a few headers: 1. A static area on the top with company info, etc. 2. A details section for product info. 3. A static area on the bottom with some basic info. I'm trying to draw a single border and some lines which extends throughout the entire report page...

I've heard that, however, it's okay if I store the value, because the ServiceFee field in the underlying table is contact-date dependant, and i need a snapshot of this historical data so in the future, we can see how much the client's subtotal was on that specific date. anyone? thanks again

Hi, I have a form (called PersonalTaxPriceSheet) with an unbound textbox called SubTotal. This SubTotal field is calculated directly on the form. For example, on the form if the user chooses Option 1, the SubTotal textbox would update to $44.95. If the user chooses Option 2, the SubTotal...

Hi all, I basically have a long form which requires me to use the right side scroll bar to complete everything. I currently have a top header area (which is great because it is viewable even as you scroll all the way down). I'm wondering if Access is capable of having a "side header" (for...

Hi all, I currently have 2 databases: a main current database (Main.mdb), and a secondary database (Working.mdb). They are identical, except the working database has no data, just the existing tables, forms, etc. from the main database. When I (or a programmer) makes changes to the forms and...

Thanks for the input and help guys! I used the "iif" function found in ancentry's example and put it directly in the properties --> control source of the GST field in my form (the GST field is completely a calculated field which is not in any underlying table)...worked perfectly. Thanks...

Thanks, but it doesn't seem to be working. Can I give you a few more details? I have a "Subtotal" field On the form, and also a tax field called "GST" (stands for goods and services tax). The GST is the tax that I am having problems with as described above. It is basically an unbound Text...

anyone? I'm still working on this

Hi all, I have a Form which calculates how much to charge a client. I have a "Fee" field, and a few calculated fields based on this fee. The calculated field I'm having problems with is the "Tax" Field. Prior to July 1, 2006, i had no problems. The tax was basically " =[Fee]*.07 " in...

Hi all, I have created an Email button on a form, which automatically opens Outlook once pressed, and attaches a report (rpt_Form1) to the email. My problem is that I want to have the report in the body of the email (as opposed to an attachment). I've searched this topic and found some help...

Just wanted to give you guys an update, as it works now. Basically, you actually have to open the general Access Program first, and open the database from the File menu directly (as opposed to just opening the database by double-clicking it). Weird, but it works now, problem solved. If anyone...

Well, I've implemented your changes RuralGuy, and it seems to be working well! The coding in the "On Load" and "On Current" that you implemented seems to have done the trick. I did try the coding in just the "On Load" event, and duplicates did still occur; however, when I also added the...

+ Shift worked! Is that some sort of security feature? My database doesn't require the +Shift for it to open...I'm using Access 03. Thanks a million RuralGuy, I inputted your coding in the On Current and On Load in my form, and yes, the duplicates have decreased dramatically. The only thing...

RuralGuy, I can't view "design view", and when I right click the form, nothing happens...I also can't see the underlying tables, other forms, etc. ... or create any new tables. Did you lock up the database? Thanks.