Search results

I placed the 'i' in the Type but it did not make a difference. Any other ideas?

Hi JHB, It was crashing before I put the 'i" in and I put it in to keep track of the number of times it cycled thru successfully until it crashed (my effort to try to find when it crashed) I also have to mention that it crashes only during runtime. I'll see if puting 'i' in the Type declarations...

I have the following code that I used to find an open window so that I won't open it again. I have tracked down somewhere close to what makes MSAccess shut down when the code runs. When it shuts down, no error comes up even though I have error handling. It just shuts down. I placed, in the...

Everything is working like a charm. Thanks again.

****SOLVED*****Thank you, thank you. That did it. Your post always solve my problems. There is nothing like experience. Thanks again everyone for your input.

Thank you everyone. It seems to chop the end off when string gets to about 1200, but its not consistent. Could be 1125 or 1157 I've tried removing lines with the variables that have no info such as '" <MRN></MRN>" & vbCrLf & _ '" <SSN></SSN>" & vbCrLf & _ and I can get more...

Thanks for your insight, but the field just has upper/lower case letters and period after a middle initial. I also have noticed that some days it only displace a portion of the string that fills Practice name. Anything else?

I have the following code that creates a long string that works most of the time but sometimes gets cut short. I can't understand why it does this. When it cuts the string short it cuts it short in the same place. Everything gets in the string up to/or about the following code '</Practice...

Thanks for your replay and this is definately something that might work. Basically I have an access app that opens a IE browser to a prescription writing webpage. The login takes some time and I want to leave the browser open most of the day and not have to re-login every time I want to...

Thanks Jdraw. I'm don't have much experienced in this kind of code. Could you perhaps help me with some code to do that? Thank you in advance.

Thanks Mahail for your link. But as I understand it, this will only test to see if you have a connection to the internet. I want to: 1) see if the default browser is open 2) see if a particular url is open, that is, open to a specific webpage. Is this possible?

I've looked around but can't seem to narrow a search for my particular problem. I want to find out how I can write VBA to find out if a default browser is open to a particular webpage. I guess I'm going to have to find the browsers handle but I also don't know where to go from there. Any...

I'm starting a new project and I'm looking for suggestions. I want to use a form or report that has content that the reader reads on a tablet/surface pro, and then at the end of the form/report they are to sign it with their freehand signature. I need to capture that signature and place it on...

I confirm... All I had to do was set the focus on the cbo first and everything went well.

I'm trying, for the first time to take control of my scanner. After reading several posts, I've decided on the TwainControlX from Ciansoft. Looks like a good control. However, Ciansoft does not have any MSAccess sample code. Does anyone have any sample code that can help me get started. I'm...

Thank you all it worked well and took care of the problem. I'll have to watch those things next time.

I've never been good at sql syntax. I'm trying to change the sorting order of a listbox using an option group. I can use sql to change the rowsource some of the time but not all the time. So I conclude that I don't understand something somewhere. Dim strAD As String 'Acending...

Does anyone have experience with Faxtalk FaxCenter Pro. I'm looking for sample code to launch and fill in the Fax fields from an Access form button. Thanks for any help.:banghead:

I'm an amature VBA programmer. I have developed a front/back end DB based on Access 2010 which also shares tables thru links to another Sql DB thru ODBC. In my programming, I've never referenced ADO or DAO on any of my underlying forms. I'm wondering if this is necessary since my forms are...

I have been running code that will launch a Word Template, fill in the merged fields the rename the document and save with the new doc name. This works well. My current project requires that I now save the word doc as a pdf for use with NoteTaker on the iPad. I have been successful in...