Search results

Hello. I'm trying to attach a macro to an update query and need to know first if this is possible and if so, how do I do it? Before the update query is ran, the user needs to ensure they have imported & appended new data to a table which then needs updating with a new date. I've never used...

Hi, hoping someone can help me with a ridiculous problem I am having in Access. I have a 2003 database that links to an 2003 Excel Spreadhseet. The spreadsheet is passworded to modify but anyone can open it to read it but not modify it. Inexplicably, I now get an error message in my database...

Hi I'm trying to creat a field that picks up only the characters to the left of either "-" or "/" in the string. The number of characters to return can vary. eg the field [billref] can be 1234567-001 or 1234567/abc-001 or 12345678-001 or 12345678/abcdef-001. I only need the numbers to the left...