Search results

I'm pretty sure I'm using the DoCmd.SendObject method, but I'll double check. I used Access's built in button wizard to create it.

Yeah they are, I've updated all the computers to Outlook 2007 thinking that might fix the problem, but no dice. The only other link I can see is that the two that are working have full versions of access on them as well as the runtime.

Hey all, I recently installed a packaged database I've been working on, onto 4 computers in our offices. On two of the computers the email report macro that I've set up works fine, on the other two it fails and shuts the database down. The package includes Access Runtime rather than requiring a...

Ah hah! Eureka! Jenkies! Okay, thanks for all the help everybody!

There is a reference in there somewhere, I just don't see it. All the references on the report itself are good to go. The only thing I can see is that there is a header and a footer that are titled as purchase orders.purchaseorderid, but all references inside them are active.

Okay, I got that part corrected. I just used the join expressions to create a query and removed the ShippingMethodID and EmployeeID from it. Thanks for tracking those down! I have one last little catch on this report that is bothering me though. I changed the name of one of my tables from...

Very much thank you! Thats exactly what I was looking for haha

Hello again, Is there a way to set up forms/tables to do color coding? For example; If a form showing an order has been completed, the user would select an option that would show as green. If an order is void, they could select red?

The Printable PO that is having the join expression error is an original from the template I customized. Would it be more prudent to just create a new report from scratch? Really, I just need a report that shows the currently opened form as a printable report.

Thanks for the help with the multi user setup! Does anyone have any idea what the fault is with the Join Expression? I'm still stumped!

I've already recieved some very handy help from this forum, and hopefully someone has a minute they can school me again. I'm finishing up a database that will track purchase orders. I'm down to just a couple little glitches before I feel like its good enough for what we need. My two biggest...

Thank you all, that makes sense. Thats what I thought was happening (retrieving the ID rather than the info) but I wasn't sure exactly HOW it was happening. That'll teach me for using a template! Haha

Here is a stripped down copy of the database. Any help would be greatly appreciated!

Okay, first off, I'm quite new to the Access software, so forgive my ignorance or bad explanations. But I need some help. I've been able to alter a Purchase Order tracking template to meet our needs, but I've hit a couple snags. The main one is; I have 5 different tables handling information...