Microsoft Access

• Topics

  Started by

  Posts

  Last post

• SQL Native Client with ms access

  I have an application that is currently using the older sql 2000 odbc driver to connect ms access t…

  GrassHopper

  2 replies

  13 years, 8 months ago

  By: rf44

• Autopopulate textbox using sql table as look up table in MS Access form 2007

  Hi, I have a requirement to autopopulate a textbox (DIVISION_CD) based on the value in another text…

  pwalter83

  13 replies

  13 years, 8 months ago

  By: rf44

• Include condition in the combo box in a form (MS Access 2007)

  Hi, I have a requirement to include a condition in the combo box of the form which is as follows(SQ…

  pwalter83

  20 replies

  13 years, 8 months ago

  By: Stephen_W_Dodd

• Excute SP in Access 2007 Database

  I have an Access 2007 database that kicks off a sql stored procedure. The SP kicks off an email pr…

  tuhlig

  7 replies

  13 years, 9 months ago

  By: rf44

• Access to SQL Server conversion

  My client has a requirement to migrate from Access back end database to SQL server express. There a…

  s-sql

  1 replies

  13 years, 9 months ago

  By: Ron McCullough

• Creating A Simple Runnable Function in MS Access

  Good Morning Guys, i was wondering if i can do this piece of code programmatically on the query des…

  Stylez

  3 replies

  13 years, 9 months ago

  By: WendellB

• Insert into multiple rows

  I have two tables an employee table and a training table. I know how to do a mass update but not r…

  klc0000

  8 replies

  13 years, 10 months ago

  By: Sean Lange

• Updating records

  Hi, I am not getting it got to solve this. Single Ticket No is having two or more than two records…

  palash.gorai

  1 replies

  13 years, 10 months ago

  By: palash.gorai

• Ado recordset does not return value from varchar(MAX) field

  Some records in this field have len = 22000. When I run the query (Select Summary From MyTbl Where …

  valeryk2000

  6 replies

  13 years, 10 months ago

  By: valeryk2000

• Data Import (Again)

  I know that importing data into an access database from SQL Server 2000/2005/2008 into Microsoft Ac…

  Jim Mace

  2 replies

  13 years, 10 months ago

  By: Matt Miller (4)

• Conditional formatting in a form

  Hello , I have a table displayed in a form in access .(data are stored in mssql2000) I need to mark…

  peter478

  7 replies

  13 years, 11 months ago

  By: WendellB

• Convert Access Attachment datatype to SQL Server 2005

  I tried to convert an access database with one column of attachment datatype to SQL server. I used …

  Loner

  2 replies

  13 years, 11 months ago

  By: Jo Pattyn

• Switch() function in Access

  I'm supposed to write code that would give results of a truth table from a table in access. For ex…

  renecarol33

  5 replies

  13 years, 11 months ago

  By: Matt Miller (4)

• Query to find matching rows

  hello- I'm working with a database that contains a table with IDs to create Relationships and Recip…

  Chelo

  10 replies

  14 years ago

  By: Chelo

• Access 97 Error while connecting from SQL Server 2000

  Hi, I have created a DTS packages that makes a connection between SQL Server 2000 and Access 97 db…

  Sax

  4 replies

  14 years ago

  By: DeafEater