Search results

I want to scan an image and store it alongside the record. That bit's ok. I've got a button that launches the scanner and saves the image with a filename as a variant on the record number (so it's unique). I've got some other code so that the resultant image shows on the form. I'm also looking...

I am trying to get my head round DoCmd.RunSql. I have a bit of code... strSQL = "DELETE * FROM Cases WHERE [DateOut] >= #" & DateForDeletion & "#;" DoCmd.RunSQL strSQL They work. Change DELETE to SELECT and it won't ("A RunSQL action requires an argument consisting of an SQL statement"). I...

Ok, here's the problem. I have a customer form A that for various reasons I have not allowed the user to add records on, they click a button, open a new customer form B, create a new record and then click the save / close button. Only if I click the button on form A to requery, can I now see my...

I have a report that prints to a preprinted form. Having set it to print perfectly on one printer, it is then about 3 or 4mm out both ways printing on another printer, so the boxes don't line up - relativity fine, absolute positioning slightly adrift. At the moment the form from which the report...

Here we go... Email comes in to Outlook with the body as colon delimited text (it's from a web site form fill). I want to import the email (easy, linked file). I then want to strip the body text into the 135 colon delimited fields, put the field into another table set up for the purpose and...