Search results

I'm not sure if this is the correct spot for this thread so here goes. I created an access project using link tables to a SQL development database. I finished the project on the development side and need to connect to production database. I created the SQL user objects on production database...

I'm using a front-end Access 2010 form with a back-end MS SQL 2008 database. Using a dialog form, I populate two of three text boxes from another main form. The third dialog box user will input value. I can make a call to the db using a global ADODB.Connection with main form. My objective is to...

I'm using Access 2010 connected to SQL 2008 server (64-bit). I created a database table with one of the fields as numeric (18,2). I linked the tables to the Access project. Created a form with a comb box and another text box. I can populate the comb box with a sql query. Using an AfterUpdate...

The problem I am having is inserting the option button group value into SQL server table. Below is the code. The problem area is under comment 'Insert a new record and create a new query for CPA Table. I'm not that savvy with programming. Any help will be appreciated. Thanks. Private Sub...

I have 3 HR personnel questionaires that potential employees fill out and would like to automate the process using a SQL database and Access forms. CPA questionaire has 131 questions, RT has 65, and ARP has 43 questions. I created four tables: employees, CPA, RT, ARP. The employees table has...