Search results

Vonnie: are you saying that the escape key is being used as a "break point"? If so, thats not going to cancel the operation, but merely pause it and we don't want the user interfering with any of the code. Thanks though :). I've tried sendkeys using Ctrl + Break, but that doesn't work. The...

Hey guys, I'm trying to build a cancel option into my database that would stop whatever code is being worked "dead in its tracks" so to speak. I've searched for examples, but nothing relevant appears in the searches. Any ideas how I could pull this off??

Hey guys, I'm trying to edit a spreadsheet that may or may not be missing data from an extraction we perform here. Basically, we take the data from our 2 job sites and compare them. However, there is the rare occasion that Site2 uses Site1's server, creating the misconception that no work was...

So in other words: INSERT INTO tblEmpInfo ( AccountNumber, AgentID, [Name], HireDate, TermDate, ActiveFlag, ProcCode, Dept, DeptDesc ) SELECT tblInput.AccountNum, Right([EMP_ID],5) AS AgentID, EWFM_EmpInfo.EMP_SORT_NAME, EWFM_EmpInfo.EMP_EFF_HIRE_DATE, EWFM_EmpInfo.EMP_TERM_DATE...

Looks like that was something I forgot to take out! Maybe that's whats throwing this off...? hahaha Edit: I tried your suggestion, and my new error is "syntax error in INSERT INTO statement". I tried this as well: INSERT INTO tblEmpInfo ( AccountNumber, AgentID, Name, HireDate, TermDate...

Hey guys, I've been searching the forums and I can't seem to make heads or tails out of this error. I looked through my SQL statement to find a duplicate field and no dice on that. Heck of it is, I made the append query like normal and it works. I copied the SQL and put it into a module...

THAT'S it!!! Thanks a ton!

Someone had mentioned to me something called "dual events" that I have been searching on, but I can't find any relevant info. RG, is that what you're getting at?

You could do two yes/no boxes: 1 = Parts Shipped, 2= Parts Not Shipped and then follow the same steps as your previous thread, http://www.access-programmers.co.uk/forums/showthread.php?t=162554

Hey guys, I'm trying to put a progress bar into my database that updates after every pass through a do loop. It works and all, but you don't see it progressing. I'm sending records from a table into an external program, performing scrapes on the data through the external software, and then...

Gemma, you're a genius!' Str_Temp is a 6 didget representation of the date without slashes. Put slashes in Private Function ConvDt(str_Temp As String) As String On Error GoTo Err_Command0_Click If Nz(str_Temp, vbNullString) = vbNullString Then str_Temp = "000000" Else str_Temp =...

That's just going to do what I've already done with the Mids in there. I tried it though, because any advice is better than none, and it did exactly the same thing as it did the way I have it coded. :(

Hey guys, I'm pulling data from an external source, storing processed transactions. The information I obtain has the date formatted as "mmddyy", and is returned as a string. I wrote a function to add the slashes, and to also format another date (which I am using for comparison purposes)...

Hey guys, Quick question (I hope!): How would I take any error message that pops up in access (like Error 3024: File Not Found) and add that to a field in my table? I'm going through a table that warehouses all of the databases on my network drive and would like this info in my table for...

That works perfectly! Thanks a million!!!!

That's great! One quick question: Is there a way to modify this so that the actual databases in my record set don't have to open? Alot of them have autoexec macros in them, and if I try to status all of my databases (450+) this could not only duplicate data, but also be very time consuming...

Hey guys, I'm trying to write a batch file that will take a list of databases I have and check what version of access they are made for. Once that is determined, I would need that information in either a spreadsheet or a text file with some sort of delimiter. Reason being: we have been...

we're referring to an actual file location, like "\\cnbase\home\---------" where the dashes would be the csv file.

Hey Guys, I'm trying to put a button on my form that will search a location for a .csv file. The file name is going to be "YYYYMMDD_NAME_DEPT".csv. Based on values from the main form, I need to search for said file based on the department. The department is tied to a supervisor in one of my...

My previous edit was a knowledge base article from microsoft (original can be found: http://support.microsoft.com/kb/904953/). It provides a workaround solution, but I've got a different idea which fits my situation and should work. The database that makes the spreadsheet I am linked to is...