Search results

Hello, I want to run some code when a user presses the Enter key on a form - how do I do this? Thanks

Hi All, I want to limit the results in a query to the selected items on a list box - how do I do this? :confused: Thanks

Hello All, Probably an obvious one...I have got a form with a couple of dlookups on it, when they return an error it pops the debug message up and if there is a value in the field already it just leaves that value there. How can I supress the message and clear the field and move on to the next...

Hello, I have got a combo box with a product code in it, and depending on which code is selected I want the data to come from one of two different tables. Is there any way I can do something like a match formula in Excel to see if the stock code is contained in a table? Any ideas would be...

Hi All, I've got a very confusing problem, I'll try explain as best as I can! I have written a query in Access 2013 which has data from a couple of different sources and displays information on a form. I can open the form and it will run fine and if I close the form but leave the main Access...

Hi All, I've got a database that is locked down for all users with forms so they can navigate the system and the navigation pane is hidden. On a couple of the forms there are buttons to print the form and when that button is clicked it unhides the navigation pane...??? Any ideas how to stop...

I need to do a DSum with criteria that picks up a previous month based on todays date, I have got the following but I don't know how to format the last part of the criteria. If I take out the Month(DateAdd("m",-13,(Date()))) and replace it with 6 it works fine...

I have a button on a form that runs DoCmd.SendObject to email as a PDF and I want to add a link to the email as follows 'click here to download...' with the 'here' being a link to a document on our website. How can I do this? Any ideas are greatly appreciated. Thanks :)

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?

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

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...

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?

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...

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...

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?

Hello All, I have got a continuous subform on a form - is it possible to make the subform fit the number of records there are? There will only ever be up to about 5 records, but I can't get the subform to grow/shrink to fit. Any Ideas?

Hello, I created a database in Access 2007 for multiple users. It works fine for everybody but there is one PC with Access 2010 that doesnt recognise the file. It recognises the record locking file but not the main database. If I open Access then open the database from the open window it...

I have got a form that shows a product image, but there are more that 1 images for each product. (ie 306.jpg, 306back.jpg, 306front.jpg) Is there any way I can create a form that will show all images with the product code in it. I want to type in 306 and then be able to open a form that will...