Search results

Thanks for the reply! I appreciate it. I will try to explain what happens. This form loads when the user opens the database and is hidden from the user: [CODE] Option Compare Database Option Explicit 'ADODB connection to the tbl_ActiveUsers Public adoActiveUsers As New ADODB.Recordset...

I have a table called Dealers that I am looking to update through a form. I did not create this table and for some reason it has the primary key as Dealer. That is a text and not an autonumber. I asked and was told that is how it needs to be. I have a combobox that a user can select a dealer...

Hello. Is there a difference when using Microsoft.ACE.OLEDB and SQL Server connection? I am using Access 2007 front-end and SQL Server 2014 for the back-end and ADO for my record set. When I started this project is used this statement: connDB.Open ConnectionString:="Provider =...

Sorry to revive an old thread. I have what I find to be a strange error occurring. Hopefully I can make this clear. When the database opens a form called frm_SysControlForm opens first. Then it opens frmMainScreen and frm_SysControlForm gets minimized. The form frmMainScreen has a button called...

Well I figured it out. I took out the second block of code with my adoQuoteConfigsCustom. I added this SQL instead: ' Build sql to copy config to the new quote sSQL = "INSERT INTO tbQuoteConfigs ( QuoteNum, ModelNum, Category, SubCategory, Description, Cost ) " sSQL = sSQL & "SELECT " &...

Thanks for the link. It didn't work for me though. It just inserts a new record with all fields blank except for the primary key. I guess I will keep looking.

Hi. I am working with a database that deals with trailers. What is happening is a salesman takes an order for a make and model for a trailer for a customer. The customer can then add some customization to the trailer such as more tail lights or tie down straps. They add the customization on a...