Microsoft Access

• Topics

  Started by

  Posts

  Last post

• converting into standard date format

  hi guys i need to convert date presenting in this format 110815 but want to convert it into standar…

  james.connor

  3 replies

  14 years ago

  By: Jeff Moden

• how do I join these 3 updates into 1

  There has got to be some way to combine these to do one update: UPDATE CovElig AS cel SET cel.GrpNm…

  renecarol33

  11 replies

  14 years ago

  By: J Livingston SQL

• Splitting a whole word

  hi guys this is my first post. hope you can help. im very new to SQL and Access so forgive me. but…

  james.connor

  5 replies

  14 years ago

  By: james.connor

• What is best way to use IIF in JOIN

  Here is my FROM statement: FROM ( CovElig as c LEFT JOIN MT_BenPlans as bp ON c.GrpName = bp.PlanCd…

  renecarol33

  2 replies

  14 years ago

  By: SQLRNNR

• Join in where statement of delete query

  Has anyone been able to successfully execute a delete query that has a join in the where statement?…

  renecarol33

  5 replies

  14 years, 1 month ago

  By: renecarol33

• Perform Access 2007 queries on SQL server

  I am a SQL guy not an Access guy, but someone cam to me today with an Access problem. Essentially…

  thermanson

  7 replies

  14 years, 1 month ago

  By: royce.bacon

• Access to SQL Server migration issue with Combo Box data values

  We utilized Microsoft's upsizing wizard to convert an Access DB (2007) to a SQL Server DB (2005) Ha…

  Express12

  6 replies

  14 years, 1 month ago

  By: charlie.mather

• strSQL = "SELECT * FROM Main_Table WHERE Usr='" & curuser & "' AND Tme >='" & CDate(strHour(a_cnt)) & "' AND Tme <='" & CDate(strHour(a_cnt + 1)) & "'"

  This query is throwing an exception and I do not know why yet. The logic is there I just need to im…

  sepich.eric

  3 replies

  14 years, 2 months ago

  By: Welsh Corgi

• SQL Server 2008 read-only access causes error in Microsoft Access 2007

  Hello, A user has a role on SQL Server 2008 to SELECT from tables (no update, insert, or delete). …

  yoffes

  7 replies

  14 years, 2 months ago

  By: Welsh Corgi

• CurrentDb looking at old path

  Hi All, I have recently moved an Access 2003 database from one drive to another, it contains a macr…

  clarmatt73

  11 replies

  14 years, 2 months ago

  By: Welsh Corgi

• Building a invoice number SQL Server & Ms Access

  Good afternoon, I have problem with my current development on a billing system which is in multi…

  veasna.much

  4 replies

  14 years, 2 months ago

  By: Welsh Corgi

• SQL BIGINT and Access 2007 - Casting not an option

  In building a data mart for use by the business, we've run into an issue with SQL's BIGINT type and…

  ashley.perkins

  1 replies

  14 years, 2 months ago

  By: WendellB

• Unable to open an Access 2003 db in Access 2010

  We have an Access 2003 database that we use to create project managment requests. It works fine in …

  brian.cook

  5 replies

  14 years, 3 months ago

  By: Welsh Corgi

• Missing "Falsepart" in IIf function used in Access 2003 Query

  I have a working query and report in MS Access that I have to convert to Crystal Reports to run aga…

  sgmunson

  2 replies

  14 years, 4 months ago

  By: sgmunson

• SELCT DISTINCT Usr FROM Main_Table (Exception thrown.)

  My code is below and terminates at the execution of the SQL query with this message: The Microsoft …

  sepich.eric

  3 replies

  14 years, 4 months ago

  By: sepich.eric