Recent content by robbie9

I got it... Thanks..... My Brain was just not with it this mornig..

Ok..I am stuck.... I need to calculate labor costs in a query based on the Length of a counter top.. I would like to make a module to do the calculations for me, but I am having a tough time getting it to work.. I made my Module, but when I call it from the Query, it tells me I need to define...

No..the report I am opening is fine... its the File name of the send object I want to change.. stDocName is correct.. I don't need to change that... Right now it defaults to the Query the report is base on..."2004 query quote.snp" is the file name I am getting... I want to change that to something..

Which ever is easiest...

How do I change the file name of a report I am sending.. it defaults to the Query name that the report is based on.. I would like to change it to either a default name(Robs Report.snp) or have it use a filed name from the report(jobname.snp).. Here is the code I am using... Dim stDocName As...

Is there a function or a button I can add that will pop-up a calculator..let the user do some calculations and then paste it to a box??? I need to calculate Square footage of counter tops and instead of them using a calculator then having to type the number in, they can just use the button...

I work at a Solid Surface fabrication shop in NJ, where we make Kitchen and bathroom countertops....Is there a way I can have users input dimensions into a form and have access draw a counter top from those measurements??? I have seen it done in other programs, but have no clue on where to...

You are the man... Thanks..

I am having a brain fart and can't figure this out.. I have a database with kitchen orders in it.. I need to make a Query that sorts the kitchens by color and tells me how many of each color.. Can someone point me in the right direction.. Thanks

Here is a good one.. I have set up Access to fax a report.. It works great except our compqny logo does not appear on the fax.. The logo is an OLE Image.. I though it was Win Fax at first..but if I fax from word or any other program, it works fine.. If I export the document to snapshot viewer it...

I want to open a form and fill in a few check boxes..Then hit a button to print out a report based on the criteria I checked off.. For example.. I want to print out who we have quoted in the past week in New Jersey.. I can make a query and run it, and it works fine.. But I want to make it simple...

I would like a copy also, if its not too much trouble..robgallagan@eaglefabrication.com Thanks..

I tried to send the Base to you, and it keeps coming back.. I got you email address off of here..Do I have the right one??

The DB is written in Access 2000.. So I can send it to you if you can use it.. What I am trying to do is, when I am Pricing the VAnity top, The only way I can Calculate the price is buy inputing the size with a Decimal (22.5 43.5 ect..) The problem is when the worksheet gets printed out, The...

Now you really confused me.. So I don't have to change anything in the Formula?? After I input the Length, How does the formula get the Number??? Am I calling it up in the wrong spot?? or Do I need to change X to something??