Search results

I have created a form with a button to email the form as a pdf but I also need to attach a pdf from my documents to the email - how can I do that?

I have got a report that needs to be sent on an email from Access 2010. Is there any easy way to use the default Outlook signature on the email?

All I had to do was set the 'Filter On Empty Master' to no...

It is a fairly new purchasing system, so there arent always orders for all products. If there are no purchase orders, I want the subform to show the monthly sales for that product so that they know how much to order.

I have got a continuous form that lists purchase orders for a specific product, there is also a subform that shows sales data for the same product. The problem I have is that if there are no puchase orders, you can see any of the sales data. What is the best way to show this information? Thanks

Excellent!! Thanks sparks.

OK, here you go... Me.PALLET_QUANTITY = DLookup("[PALLET QTY]", "tblSupplierPalletQty", "[STOCK CODE]= '" & Forms![ENTER PURCHASE ORDER]![PRODUCT CODE] & "'" And "[SUPPLIER]='" & Forms![ENTER PURCHASE ORDER]![ACC NO] & "'") Each of the criteria works on its own, it's probably a simple...

Ok! I have made each half of the formula work and put them together, but it now just says "Run-time error 13: type mismatch"

That returns the same error but with an ' in front of the "HAREUR" in the error. It doesn't seem to be picking up the "and" as an operator.

I have got the following lookup on my form: Me.PALLET_QUANTITY = DLookup("[PALLET QTY]", "tblSupplierPalletQty", "[STOCK CODE]=" & Forms![ENTER PURCHASE ORDER]![PRODUCT CODE] & " And [SUPPLIER]=" & Forms![ENTER PURCHASE ORDER]![ACC NO] & "") to find the pallet quantity of a product for a...

The primary key on the current record is a calculation from the last record on the table. It works fine until 2 people use it at the same time, then it start trying to duplicate the primary key.

Hello, I have a database that uses a field from the last record to populate the primary key field on the current form. The database is used by several users simultaneously and I have been having problems with primary key conflicts. How can I write that field to the table as soon as the form...

Hello, I need to show the totals of a 3 columns in 3 different queries on a form. I am currently using a DSum but it is very slow - is there any better way to do this?

Thanks - that was exactly what I was needing! On a serious note, does it make sense what I'm wanting??

Hello, I have a form that displays sales information for the last 12 periods. How can I make the text box labels change with the month? Eg in February, the labels show this: Current Period January 2012 December 2011 November 2011 etc. in March, show this: Current Period February 2012...

Thanks, I had actually found that out just before I read this post! I don't usually use spaces and special characters - this is just a very early version to test.

Hello All, I have got a form that shows purchase orders. There is a tick box on each purchase order to say if it is complete or not. On the form there is another tick box - if it is not checked I want it to show orders that are not complete, if it is checked I want it to show all orders. I...

It is a numeric field. What I can't work out is that when I take the "ALL" out of the query the DSum works fine, put the "ALL" back in and it returns #ERROR...

The union query is working fine on its own, but when I put the Dsum on a seperate form it just says "#Error" in the text box.

Hello All, I need to calculate the total of a union all query. It works fine if I take out the ALL in the query but with the ALL in the query it returns an error?? Any idea how I can sort this out?