Search results for query: *

Here it is: ******************* valProposal = Forms![frm_Prp_Proposal].ProposalDescription valDate = Format(Date, "mmm dd") valTime = Format(Time, "mmss") myPath = "C:\Program Files\Reports\" valSummaryFileName = valProposal & "-Summary-" & valDate valSummaryFileLocation = myPath +...

I tried parsing the string as you did and I am still getting the same error. Any other ideas?

I thought this would be the easiest thing in the world to do – using VB I want to import a specific worksheet into Access. The “!” is an illegal character and Access won’t take it in the code. Do you know how to import a spreadsheet (not the whole file and not necessarily the first sheet in the...

That worked! THANK YOU!

I’m trying to write some VB code in Access that will loop through a recordset. That’s not hard, I have that all set, but one of the fields of the recordset is “code”. On the form I’m using there is a corresponding square for each “code” value. What I want to do is use the value of “code” to find...

I am using VB/SQL to insert rows into a table, but when I use VB/SQL to delete those rows, I get the error "search key not found". It is not a memo field (I've seen problems on the net with this) and it is not indexed. Is the table corrupt? I tried recreating the table from scratch, but that...

I never would have thought of that. THANKS!

Just curious - what was the syntax when you were getting errors? The difference between your syntax and mine was that I was using "Snapsot format" instead of acFormatSNP. I haven't gotten the error since I changed the syntax, but it has popped up without any pattern that I can tell...

I can not for the life of me figure out what my problem is with Snapshot viewer. I am using it to output some reports and I randomly get the error "can not create report, there is not enough free disk space." There is MORE than enough free disk space. And what is stranger is that there seems to...