Search results

There are tens of thousands of chemicals being added so the more I can automate the better. One click saved equals close to an hour overall.

I have a database of chemicals and one of the entries is the MSDS number. I would like a hyperlink, pointing to the .pdf of the chemical, created when I enter the MSDS number. If the MSDS number is 1111 the .pdf file will be something like (\\servername\folder\1111.pdf). Is there a way to...

whatever, I PMed you my email address and a little bit of an explanation.

I was having a problem creating an MDE file for my database. I was going to post a question about it but I searched (like a good poster does) and found this thread. I followed your tip and it worked wonders, Thanks!

Thanks for the kind words. Your a) is what I am looking for. It seemed nice and easy when I outlined it on paper but it is another thing when I try to put it in the report. I would greatly appreciate any help you can give me.

I guess what I need is limiting it by three criteria. I need it to limit by transactions from 'the beginning of time', the ending date, and the particular chemical (or all chemicals). When you open the inventory report you will select the ending date (the beginning date is already entered) and...

Thanks for the compliments although there is quite a lot of formatting I still need to do. My form does not filter according to the ending date. For instance if you pick the ending date to be 8/30/06 it will include transactions made after that date (it won't cut off the data). I know that...

I am a bit stuck on an inventory report. The database I am working on keeps track of chemicals including the amount of chemicals purchased (Acquisitions), disposed, as well as the initial quantity on hand. Using these three figures I am able to do many things but I can't figure out how to get...

I definitely am not running low on resources (2gb of ram) and I don't have any forms open when I am coding not to mention I don't have any forms with timers. It only happens with the DoCmd command.

That doesn't make a difference. Thanks for the reply though! Aaron

I'm not sure what you call it but I call it auto-complete; the functionality that gives you a list of methods/commands when you are typing something like Me.Forms. When you type the Me. after the . it will bring up a list for you to see what you can do from there. That works fine for me but...

Is there a need (advantage) in buying Crystal Reports or would I be able to just use what comes in .NET 2005? My company is on a spending freeze but yet I need to update and create new crystal reports so if I NEED it they will purchase it…you’ve gotta love the accountants! Also, is it...

That does sound much more plausible. I always questioned it but because I found it in so many places (and one printed) I just figured it was a HUGE house. Good investiagtive work!

I'm not saying the bricks were 40000 tons but the whole house. I thought the same thing as you, I saw this in a desk calendar, but I looked it up and it's correct.

That did the trick! Thank you so much! If you were here I'd give you a kiss!

I still get the error. I guess instead of [Container] I need [NewData] since I am passing NewData into the Sub? either way I still get the error.

Mailing an entire building has been illegal in the USA since 1916 when a man mailed a 40,000 ton brick house across Utah to avoid high freight rates.

Same error. Here is the code in the entire Sub:

Here is what I have so far: Dim SQL As String SQL = "INSERT INTO tblContainers (Container) " _ "VALUES ('" & [Container].Value )"'" DoCmd.RunSQL SQL but it gives me an error "Expected: End of statement" at "VALUES ('". Does anybody have any idea why? As you can tell I...

I thought it might but I wanted to make sure, thanks!