Recent content by wjburke2

Thanks llkhoutx, after some further testing it was found that the server is at a remote location and so we believe the trunk line between my location and the server is mostly responsible. Thanks again if it wasn't for people willing to reply to these sometime silly questions I would be spinning...

Thank you for your response, No, this is a all SQL Server backend. What changed: Because of the limitations of SQL 2008 R2 express. I had three databases Referance_Tables, TBO_Tables and Trace_Tables. When I moved to the SQL 2012 Standard Ed. server I combined all the tables into one database...

My Access application is used to parse a text file and insert the records into a SQL Server BE is way slow. It was running on a 2008 R2 Express server. I recently migrated the data to a SQL Server 2012. Before the move I was inserting at about 30,000 records per minute. Now I am doing 30,000 a...

Thanks I will give that a try. I am not sure if I follow the open as binary methodology completely. I assume I can then read the record without triggering a EOF. pass the strread by ref to Alphanumeric, strip the bad stuff and keep going. I will post my final solution.

I had removed the check and put it back here. As you can see it was only checking the first name. I tried moving it up to check the whole record but that didn't work. So if you find a code error it probably the cause. Thanks again for your help. Public Sub ParseHistoryFile(ByVal inFileName As...

Thanks JDraw, I have a program that allows me to see what the characters are its called V File Viewer. In this case the invalid character is causing a EOF so any attempt to display it fails. My records are 658 bytes long but this causes the record to appear as 35 bytes and triggers a EOF. ASCII...

I have a program that has been working for a year or so, it imports records form a text file created by a web site. Someone has entered a hex("1A", "A8" in a name field. It is shutting my program down. I tried a alphanumeric check to replace it and a length check to try and skip the record but...

Thank you for you timely response, that makes since because most executable are blocked. I download it file and will try it Monday when I can really get into it.

When I downloaded the attachment I only download a file named Attachment.php not a MDB

My applications main screen has like 3 sub forms layered on top of each other (all identical size) Depending the selection the user makes on the top form I hide the top form. showing detail records. Kind of a drill down thing. I found a article on here that looks promising but I can’t find the...

Good question I am having a similar question. I have developed a application and am distributing it via Package Solution. The users are running it in runtime mode. On one screen I have a subform that allows the user to add/delete items from a bundle. In runtime the right click function is not...

Thanks, that worked great. I had to create a second hidden field called tmpOld_Value to hold the data source then use it as the argument in the IF. I started to wirte a iIf before but must have coded it wrong because it didn't work so I moved on. It was kind of weird that it could not find the...

I have a Audit Report fields that displays the Old and new valuse. This field can contain Dates, Part numbers, Inventory counts, Boolean values, etc. My problem is that when the value is a Boolean value it display a -1 or 0. I need this to display True/False. I tried this code but get a error...

Thanks Pat, I was just wondering if there was a docmd.outputto or some other way to send the contents of a Textbox/Memo Field to the printer. I have a Memo field for Audit information. I was thinking the user might want to print it without using the mouse to select it all then paste it into a...

I have a Memo field on a form. I would like to print the field. The best option would be for the user to be able to right click on the text box and select and print, or to put a button on the screen to print the contents to a printer. No formatting is required. I just want to print it out on...