Search results

Yes that took care of it perfectly. There is something to learn every day. Thank you for your expert advise.

I'm getting a application crash after I try to stop all code. Private Function Func1() on error goto Func1Err if something then call Func2 Do some more stuff Func1Exit: Exit Function Func1Err: msgbox "Error Message" resume Func1Exit End Function Private Function Func2()...

Thank you for the tips. Since I couldn't change the index's to the Pervasive db, I did check the index links with the Access tables and found that there were no links. I unlinked and then re-linked the table. The link wizard then gives you a choice of identifying the indexes. Once I...

I have Pervasive Sql v10.30 BackEnd and connect to my Access FE thru ODBC. I have some tables I can open and update records in the pervasive db, but I have encountered a table that when I try to rs.edit/rs.update, says its read-only. I've gone into the Pervasive Control Panel but don't have...

Thanks for all the insight, discussion and help.

You were right about Desc. I've been working with this db for so long that It didn't catch my eye. the [Desc] took care of it. I ran my original code with the [Desc] and it also worked so it took care of the '#' in the string. So does this mean we still don't know how to take care of the #...

Galaxiom: I tried Currentdb.execute sqlM, dbfailonerror but I got an runtime also on this using my original sqlM statement. So I tried this code but it gets a runtime 3134 - syntax error... dim rs as dao.recordset Dim pDate As String, pPName As String, pRName As String Dim pILight As String...

I have to process a lot of records. One of the fields may have a string such as: field1 = "45 y/o #5 xray to be taken" or "35 y/o #23 Will bring referral" field2 = "SOMETHING" my sql: "INSERT INTO mytable (field1, field2) " & _ "VALUES ('" & field1 & "','" & field2 &...

I have some fields that have # in the string representing number such as #1 and #2. I can't seem to find anywhere how to escape the # in an sql? Can someone help me?

Okay, here is how I did it. When opening the txt file I kept track of the hWnd (windows handle) and the name of the txt file (strFiletitle - the name of the file when I created it), and put it in a field on my form. I opened, as noted above using: Shell "notepad '" & path2file & "'"...

Thanks to you both for your replies. But I'm an amateur VBAer and what you are both saying is way over my head. I basically don't really understand the way I opened it. Can you give me an example of how the code goes for me to close a text file. It appears that I need to use a certain way to...

Thanks for your reply. Here is how I open the textfile: Public Function OpenPharmTxtFile(strPharmTxt As String) On Error GoTo OpenPharmTxtFileErr Dim path2file As String 'full path to file and filename Dim y As Long Dim tempstring As String, strchar2add As String...

Thanks for your reply. I already opened it in a previous routine, but now I want to just close the file. My opening routine opens it in notepad.

I have a Test.txt file that is already open. I want to close it with the following code: Dim objfso Dim objfile dim strfilepath as string strfilepath = "C:\mydir\test.txt" '===Following does not close txt file Set objfso =...

Re: ssubtmr6.dll and windows 8 SOLVED Okay what fixed things for me was getting an updated dll. My original one was ssubtm6.dll was date 10/8/2010 but I found a new one dated 10/13/2012. I overwrote the original one in the System32 and it worked fine. Thanks for all fo the input.

Any other suggestions? I really need to get this to work. Thank you for any replies.

Thanks for your reply. I did the following from the run dialog. %windir%\syswow64\regsvr32.exe ssubtmr6.dll I get the error: "The module "ssubtmr6.dll" was loaded but the call to DllRegisterServer failed with error code 0x80004005" This is a brand new workstation and the only thing I did...

I dont' see much on ssubtmr6.dll so I thought I'd post a question. I have an AccessDb that I've been running for some time (Developed with Access2010). I now recently installed Access runtime 2010 on a Win8 workstation. My application requires ssubtmr6.dll. But for some reason, I can't get it...

Thanks for the suggestion on CreateObject. Which dll or reference do I need to do this. I'm getting Runtime 429.

Sorry for the confusion. Let me paint a new picture of my situation in different terms and perhaps this might be clearer. I have a main access db called 'AOMSCharts'. On the main form I have buttons, much like a menu, that are coded to open another access db, 'AOMSImplant.accdb'...