Recent content by AndyBr

Thanks, HiTechCoach. Looking at the code, I'm pretty sure I can tweak it to make it work. I love how the writer says that the extra tricks "are clever bits I never want to have to figure out again". How true. I also got out my SQL book, which seems to indicate there might be a way to do it...

I haven't found the answer to this yet, so hopefully I'm not asking a question already answered. I'm an amateur, but I do Access fairly well. Background: I'm trying to import Excel spreadsheets into Access. At work, I investigate problems / issues of a medical sort, and when one happens...

That's originally what I tried. For some reason, it wanted to read the whole thing as text. That is, as: "#[Add_Monitoring_Date]#" Rather than: 1/25/2010 I fiddled a little with single and double quotes, but quickly just went with the format function. I just didn't spend enough time...

Thanks Wiklendt and vbaInet for the thoughts and answers. You guys were right, the issue wasn't in the forms - or, better, the solution was in the query. What you wrote was accurate, but didn't exactly fit. But it prompted something. The solution was to use the format function to...

Thanks. I realize how hard it is to comment without code. Here's what I have: In form's field is named "Add_Monitoring_Date". It is sourced by a query, but since people will be entering new data, it's not limited to the query data. (The query queries the past entries for that provider, so...

This has been most obnoxious for me over the last day or so, and I'd appreciate any help people can give me. I have a database used to record the results of monitoring the Department of Health does of providers. Providers are monitored annually, so every record is identified by a provider name...

Just to save someone else a morning of searching: the 'in that order' is very important. I was going bonkers trying to figure out why the reverse - Chr(10) then Chr(13) - would return in my report as two boxes, a little like this: [] [] The reason was the order of the two chr. This is...