Stack Overflow
Stack Overflow

Questions tagged [ms-access-2003]

Microsoft Access 2003 - a rapid database application development tool - Use this tag for questions specific to Microsoft Access 2003. Also use the more generic [ms-access] tag for general MS Access questions and [access-vba] for questions involving MS Access Visual Basic for Applications

Office 2003 reached end of support on April 8, 2014. If you haven't already begun to upgrade your Office 2003 environment, Microsoft recommends you start now. MS Access is a member of the MS Office suite of applications, included in the current Office 365 edition.

Use this tag for questions specific to Microsoft Access 2003. Also use the more generic [ms-access] tag for general MS Access questions and [access-vba] for questions involving MS Access Visual Basic for Applications

803 questions
0
votes
1 answer

Connect to C# Program Data Source from Microsoft Access

I have a small C# console program that retrieves an item list from quickbooks, and I am trying to figure out how to expose that data to Microsoft Access. It is in XML format. I want to retrieve the data in real-time, since it only takes about a…
Arlen Beiler
  • 15,336
  • 34
  • 92
  • 135
0
votes
1 answer

Access SQL - Multiple OR conditions using checkboxes

My query, which kind of works is as follows: SELECT [copyright status], sum(IIF(layer='key info',1,0)) AS [Key Info], sum(IIF(layer='approaches',1,0)) AS [Approaches], sum(IIF(layer='research',1,0)) AS [Research] FROM resources WHERE…
KurtB89
  • 49
  • 1
  • 4
0
votes
1 answer

Returning values of fields on active subform

I'm trying to pass data from a form with a subform into a microsoft word document, form and subform in this image: I have code for passing the form data, but I'm not sure how I reference or request the data from the subform? Ideally the string…
Andy
  • 135
  • 2
  • 14
0
votes
2 answers

Creating an SQL query in MS Access for a dropdown box lookup in a subform?

I have the following two tables, the first called Projects and the second called Parts: I then have a form (lets call it Form 1) that uses Projects as its Record Source with a subform that links Project on the Projects table to Project on the…
Andy
  • 135
  • 2
  • 14
0
votes
1 answer

How can I avoid Runtime Error 445 - "Object doesn't support this action" and still make the assignment?

have a problem trying to get a URL in VBA, when using automation from "access ie 2003" with IE version 8. The code runs fine util it reaches the statement: artRSSFeed = .Document.Url Bare it in mind the previous URL assignment (FeedURL =…
Andrew Seabrook
  • 397
  • 2
  • 17
0
votes
2 answers

Using MS Access 2003 to connect to SQL Server 2005

My dad built an MS Access Database to do property management. Now he wants to share it with other users over the internet. So I got a hosted SQL Server account at Network Solutions. Now I'm trying to connect the Access 2003 client to a test SQL…
Chris Beck
  • 1,899
  • 2
  • 19
  • 26
0
votes
3 answers

Returning row number on MS Access

I have 4 tables, from which i select data with help of joins in select query...I want a serial no.(row number) per record as they are fetched. first fetched record should be 1, next 2 and so on... In oracle the equiavelent in RowNum.
reggie
  • 55
  • 1
  • 2
  • 8
0
votes
1 answer

Increasing MS ACCESS SQL Query Performance

I am facing following scenario in MS ACCESS SQL. (Unable to load SQLFiddle due to connection issue) Table A : ID, Code 1, Code 2, Source, Other Columns 10, A20, AA, x, etc 10, A50, AA, x, etc 10, A70, AA, x, etc 10, E20, EE, x, etc 20, A25, AA, x,…
bonCodigo
  • 14,268
  • 1
  • 48
  • 91
0
votes
3 answers

CopyFromRecordset method isn't moving the cursor to last row output

I am using ADO to query a table in MS Access 2003, and outputting the data to Excel 2003 worksheets using the CopyFromRecordset method. The table has more than 65536 records, so I cannot use DoCmd.TransferSpreadsheet and need to use VBA with ADO. My…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
0
votes
1 answer

How to link HTML document with several tables to MS Access database

My purpose is to link *.html document to MS Access database and export it to *.XLS file. The problem is my *.html file contains more than 50 similar tables. If I'm using "Link HTML Wizard" it looks like Here I can choose the particular table from…
mbigun
  • 1,304
  • 4
  • 19
  • 46
0
votes
0 answers

Is there a program to convert an Access 2010 DB to an Access 2003 DB?

I've spent the last week making a nice database for a project and my boss forgot to inform me that it needs to be in Access 2003 for the client. Is there a way to seamlessly convert from 2010 to 2003 with a program?
user2417886
  • 3
  • 4
0
votes
1 answer

How to dynamically position a text box in Access 2003 report?

I have an Access 2003 project (.ADP) which is a front end to a SQL Server 2005 database. In this ADP, I have a report, which is a set of 8 unbound text boxes, stacked on top of each other each with their own labels. Each text box is for…
FMFF
  • 1,652
  • 4
  • 32
  • 62
0
votes
2 answers

DateTime picker control, problematic behavior

A datetime control on a form, bound to a table field, works fine. If I add the picker inside a tab control it raises this error when I load the form: An error occured in a call to the Windows Date and Timer Picker control. Is any workaround for…
Nick Dandoulakis
  • 42,588
  • 16
  • 104
  • 136
0
votes
1 answer

Insert into ms Access from SQL Server using OleDb provider

In this post Remou has nicely described how to bulk insert data from a SQL Server table into an MS Access table using the following syntax: SELECT fld1, fld2 INTO accessTable FROM [sql connection string].sqltable In the examples in his post, Remou…
nam
  • 21,967
  • 37
  • 158
  • 332
0
votes
1 answer

opening mdb file by multiple users

i am new to access and am working on 2003 version I am preparing user form in access which wish to be opened by so many users at a time. so will this be possible?
user2216436
  • 41
  • 6
1 2 3
…
53 54