Recent content by NickBridgens

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

Thanks Chris. Changed the way I was doing things and it worked a treat and pretty fast. Selected a record range based on one of the date fields, created a record set, copied to another table (it's an archiving routine) and then deleted the original records. Ace! However, when I took it out to...

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

No joy - the customer records are displayed in alphabetical order, so it just goes to the last one, not the one just created.

I guess I have to learn that a man has to know his own limitations!

As a junior, please forgive my presumption, however, I read elsewhere that all dates in SQL are US, irrespective of who or what you think you are. I've just gone down the route of a delete statement that deleted all subrecords everything later than today, but left a couple of items in July and...

Thanks Rich, but wierd! Your code saved the record, closed the customernew form and then reopened customernew form showing the new record. Couldn't tell if the code was working 'cos opening customers form showed record as there (of course). Changed the order so it closed the form and then did...

Thanks One down one to go! Still got the same "can't find the field" message so changed code to DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Forms!Customers!CustomerID.SetFocus Forms!Customers!CustomerID.Requery DoCmd.Close And it works for creating a new vehicle...

No joy. I know I want to refresh or requery form A (and it's sub form), but the question is how can I do that in code from the closure of form B? Putting in Forms!Customers!CustomerVehicles.Requery in the onclose event of the CustomerNew or VehicleNew forms just says it cannot find the...

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

The issue was to take structured text out of an email body and put it into Access in the right fields. The mail body ended up as delimited with colons and carriage returns so I linked the email box in exchange into Access, created a form based on the email table, just showing the body field and...

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