Microsoft Access

• Topics

  Started by

  Posts

  Last post

• Update Field to current logged in user ID with new record command button

  Hello all, I have an access front end that uses a sql backend. We want to add a field in a form s…

  kwoznica

  32 replies

  8 years, 6 months ago

  By: R. Brush

• ms access to word doc

  Hello,Maybe someone will help me. Dim appword As Word.Application In References is Microsoft office…

  peter478

  4 replies

  8 years, 6 months ago

  By: peter478

• trying to upsize MSACCESS 2010 to sql server 2008

  Using sql server migration assistant 7.3 to try to upsize an MSACCESS database.   When I …

  fizzleme

  16 replies

  8 years, 6 months ago

  By: fizzleme

• Access mdb file previously working on Visual Fox Pro, now we are on SQL server

  Hi! Just a little background on this issue. So we have this Access .mdb file that HR uses to pull p…

  uuya

  3 replies

  8 years, 10 months ago

  By: WendellB

• security access - sql

  Hello all, I have a question regarding security of SQL data in database. I use: - sql2008 express w…

  peter478

  5 replies

  8 years, 10 months ago

  By: WendellB

• short date q.

  Hello , In my table view I have set a filter = getdate() Is it possible to convert it directly in t…

  peter478

  4 replies

  8 years, 10 months ago

  By: peter478

• table structure

  Hello , I need an advice. let me describe. I have Main table with this structure: id id_creator id…

  peter478

  5 replies

  8 years, 11 months ago

  By: peter478

• ref integrity after Migrating database to sql server 2008 R2

  The unpleasant task of upgrading an MS Access 10 database to SQL Server 2008 R2 fell on my shoulder…

  fizzleme

  10 replies

  9 years ago

  By: WendellB

• ETL REWRITE

  We have server running access etl. It generally gets the data using LANSA queries and access and SQ…

  karthiknfr_1991

  3 replies

  9 years ago

  By: Eirikur Eiriksson

• How to get date??

  Hello , I would like to find right date. Example: year = 2016 week = 40 day = 3 (tuesday) How can …

  peter478

  15 replies

  9 years ago

  By: peter478

• Changing Tabs in Access

  Not sure if the topic is right. I am helping out an old company I used to work for streamline their…

  jbm6401

  1 replies

  9 years ago

  By: WendellB

• Output-parameter via VBA cmd.Parameters always returns null

  hi, still trouble with StoredProcs and VBA. First my StoredProc: /****** Object: StoredProcedure …

  candide

  2 replies

  9 years ago

  By: candide

• Changing both the Connect and SourceTableName properties for a Linked Table in MS Access 2007

  I recently ran into quite the conundrum trying to change both the .Connect and .SourceTableName pro…

  sgmunson

  4 replies

  9 years, 1 month ago

  By: calle_bdn92

• SQLite and Transform

  SQLite does not know TRANSFORM/PIVOT as in MS Access. How can i make the next query/view in SQLite?…

  madref

  2 replies

  9 years, 1 month ago

  By: madref

• @@ROWCOUNT in StoredProc returns 1, in VBA returns -1

  hello, this strange behaviour I can't explain: CREATE PROCEDURE [dbo].[sp1_UPDATE] @ParCRUD_Typ…

  candide

  1 replies

  9 years, 1 month ago

  By: candide