Search results

Amazing... never seen an update query?! Go to Access db window. Go to queries tab. Create a new select query in design view against the table and field that you want. Click on the query option of your Access toolbar and select 'update query'. Add the line that reclusivemonkey has given you...

In the properties of the text box put a reference to the cell that you want in the 'linked cell' parameter field. i.e. A1

I have to go to the pub for a colleagues leaving do. Take a copy of your db. Remove any personal info. Put in a couple of sample records. Save it as Access 97 and post it here. I will take a look and fix for you tomorrow.

Forgot to mention... you should create a query for your combo instead of the table. The query will reference the table, but group by the fields that you want. J.

Put your form in Design Mode Right click on your combo Go to Properties, Data, Row Source. Click ... Right click on a field in the query for your combo box and click 'Total' so that you group according to the values you want. Close without saving, and when prompted save. HTH, J.

try adding this to the on click event of your command button Dim strWhereClause as string Dim strComboField = forms![FormName].[comboboxname] 'Remove single quotes if not text strWhereClause = "Fieldname = '" & strComboField & "'" DoCmd.OpenReport "rptReportName", acViewPreview, ...

Between #01/01/2004# And #01/10/2005# If you put that in the Criteria section of an Access query it should automatically add the hash (#) signs if the fields are date format.

Kerry, Don't include any personal details for any of your customers... no account nos, etc. The cells could be formatted as date. Try formatting cells as text. If that doesn't work - you could try copying all the sortcodes and then edit, paste special, as values. Be sure to format the...

Nice link. Thanks mate... one of the best I have seen, good detail and explanations. Will have a thorough look and see if I can learn a little more. Nice one!!

Hi, I have some existing code that works fine. It allows me to output a report to a local drive, then zip and password protect the file, then I send the file on to the recipient. I have just been informed that the recipients won't have a copy of winzip... so I have to make it self-extracting...

Christoph, Thanks for the feedback. I like your idea of an error-trapping table. After thorough testing on my pc, I still find that users encounter different errors due to their environment or the way they approach things. Often it may just be a matter of waiting for an external action to...

Howdy folks, I have been trying to glean little ideas from different folk to come up with robust error trapping. I have put together something below that I quite like, but I was hoping to get some feedback to see if there is anything else that I can do. Code and explanation as follows...

Pleased to hear it Foody. It is possible to do what you want. Go to the properties tab of the unbound control. Row Source Type should be set to "table/query" Row Source is a SQL statement that will return the records you need. i.e. SELECT Invoice-Address.InvoiceID FROM Invoice-Address; Note...

Oops... missed the "Set" keyword in the following line... Set rst = dbs.OpenRecordset("SELECT invoiceID FROM tblInvoiceAddress WHERE ....)

Not sure about a nestled select in an insert statement... maybe... Otherwise you could get the value through a recordset and then use the parameter value in your insert statement. Dim dbs As Database Dim rst As Recordset Dim strInvoiceId As String Set dbs = CurrentDb rst =...

A sample insert statement would look like this: strSQL = "insert into table_name values ('7725', 'Bob', 'Nice bloke');" If you are only inserting into some of the columns you will need to specify the column names, strSQL = "insert into table_name (column1, column3, column7) values ('7725'...

Le... Le French in Montreal is obviously better than the English?! :p J.

Hey Christine, Yeah, I took a look at that code. I really like what he has done. It isn't really necessary for my circumstances, because I have multiple dialogue boxes coming up as I go through a loop, and each time the printing dialogue comes up it is only for a fraction of a second. If you...

Christine, The guru came back with the following... "The verdict on the cancel button is that neither the docmd.setwarnings nor the application.echo have any affect. This one has me stumped! The cancel option is modal, and SO modal that it's impossible to override. Unless you find a cunning...

One interesting observation... DoCmd.OutputTo acOutputTable doesn't come up with the message that is annoying us, which must mean that it isn't necessarily a windows dialogue and is probably associated specifically with the Reports themselves. I have asked an Access Guru (good mate) to take a...