Search results

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...

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...

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...

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...

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...

I have form that allows users to update inventory and a automated module that updates inventory as invoices are entered. Boxes is a table field format double. Boxes = Onhand / quanity in box. Now my automatic update processes calculates boxes each time it updates. I am ending up with fields...

I have a subform the displays selected inventory records. They take inventory by boxes most of the time. But in some cases they have not entered a Box_Qty so I disable and lock the Box_Count field so they can not enter inventory in boxes for this item. The problem is when I do this and they are...

I need to write a program that will update A2010 db inventory counts form a txt file. I am getting a error when I try to write the transaction records. The error Message "Syntax error in INSERT INTO statement." I know this is not the problem and believe it to be with the connection. Possibly I...

I have looked through many posts about this topic but none seem to fix my problem. I have a form bound to my inventory table not a query. It has a list box used to select the record to update. Everything seemed to be working until I tried to add Last_updated field in the Form_Before_Update...

I have used Access for some time but only today decided to try a Multi-item form. I am creating a simple form the will list inventory items and allow the user to update the inventroy levels. I can't update any of the fields in the form. I tryied to create unbound fields and code to update in the...

Has anyone had any success installing certs in windows 7. I have a script I use to install certificates for XP users. I tried my first windows 7 install today and the script did not work. Any advise would be very appreiated. Here is the script I use for XP ' Install the Programming Certificate...

This is for a corporation so the network administrators install all application. The users do not have authority to install programs on computers. I recently found a VB script that will install the current application and update versions automatically. It is exactly what I needed. My current...

I found this great VBScript by Bill Mosca for deploying and updateing Access DB's of all kinds. It runs great untill it gets to the line that runs the start shortcut. I am hoping someone can spot the problem. 'Launch FE. WSHShell.Run cLOCPATH & "\" & cSCName & ".lnk" Then errors with...

I have been developing in Access for many years. From 2000 - 2010 I am having difficulties figuring out a deployment strategy. This new publish or package options is confusing both have advantages and disadvantages. I have started a thread on another site and have hundreds of posts from people...

Is there a way to use my .cer to sign ClickOnce manifest? I am investigating different deployment options and came across an article on using ClickOnce for MS VS and MS Access and it sounds like a great option because I develop in both. My first problem is that I have a certificate I have used...

I have a form with a combo box used to select three character product codes. WOH, TEH, THE, IMA.... When the user types WOH Access automatically changes it to WHO, TEH changes to THE. Of course the user wants WOH or TEH. I have been asked to shut off the auto spell checker on this form and...

This application is for a printing shop with four high speed printers. The main form is a shift log. The operators enter at the beginning of their shift. Start time and in a sub form the printers they are operating and beginning counter for each printer. During their shift if the printer goes...

Very simple install. I have a application FE that I need to sign and distribute to people on my local network. It consists of a .ACCDB that needs to be loaded into their AppData directory and a ICON to be installed on their desktop. The user doesn’t know anything about where to install it or how...

I just upgraded to AC2010 yesterday. I converted this database from a MDB to an ACCDB. I am getting a message, Security Warning Some content has been disabled. I do not get this message when I open the MDB in 2010. I assume it is the Digitial Sig that is missing. When I try to sign the DB the...

This is a weird error, I have code that has been working and all the sudden I am getting a Variable not defined error on the Cancel = True statement. Private Sub btnAdd_Click() On Error GoTo Err_btnAdd_Click If Not Data_Valid Then Cancel = True MsgBox "Update Canceled"...