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
6
votes
1 answer

how to export two MS ACCESS table into one csv file without getting overwritten?

I am trying to export two MS Access table into one .csv file. I am not able to do so, i am able export these two table into two different csv files. I need both tables to get exported into one csv file. Both tables having different numbers of…
ravi chaudhary
  • 617
  • 4
  • 15
6
votes
4 answers

How to see who is using my Access database over the network?

I actually have 2 questions: 1. How might I see who is using my Access database? E.g: There is someone with an Access database opened and it created the .ldb file, I would like to see a list of who opened that database (it could be more than one…
Pellizon
  • 1,365
  • 2
  • 12
  • 26
6
votes
2 answers

How to find duplicates from two tables and also to find duplicate in itself?

I have created this statement in access 2003 SELECT COUNT(*) FROM TABLEA WHERE NOT EXISTS(SELECT * FROM TABLEB); Does this statement helps to check if the records in table A is the same as table b? TABLEA is the new table of table b and i…
10e5x
  • 909
  • 4
  • 15
  • 27
6
votes
3 answers

Microsoft Access VBA - Run time error '3075'

I've encountered the run time error '3075'. I'm a novice in VBA! >.< Can i know where did it went wrong? I can't solve it... For e.g, if I enter a name "Sally" into a textbox (txtMainName), upon clicking on the search button the error pops-up. The…
GuessWho
  • 99
  • 2
  • 2
  • 10
5
votes
3 answers

IIF query using OR operators not working

I'm trying to run the following as criteria in an MS access query. Basically what I want to do is: If checkbox = True then all records, including those with blank or Null fields are shown (the default value in my form's combo box [combo9] is…
Reigncloud
  • 51
  • 1
  • 1
  • 2
5
votes
2 answers

Populate a variant array from a comma-delimited string

Usually if I want to create an array from a comma-delimited string then it's a String array I want and the Split() function I'll use. However right now I need to convert a comma-delimited string into a Variant array so it can be used as a function…
Aiken
  • 2,628
  • 2
  • 18
  • 25
5
votes
3 answers

How can I always round up decimal values to the nearest integer value?

On a report I have the following code for a field: =Sum([PartQty]*[ModuleQty]) Example results are 2.1 and 2.6. What I need is for these value to round up to the value of 3. How can I change my field code to always round up the results of my…
Shaun
  • 99
  • 2
  • 2
  • 8
5
votes
2 answers

How to Dynamically Change the Rowsource of an Access Chart

I would like to know if there is any way I can set the rowsource property of a chart in my report at run time. I intend to have a chart in my report's group header section. The rowsource of this chart should be updated according to the group…
got2nosth
  • 578
  • 2
  • 8
  • 27
5
votes
1 answer

What reference is needed for TableDef object in Access 2010

I'm trying to use a macro/.mdb file that was written in Access 2003 in a new Access 2010 Access install. Opening my file I get a compile error saying the TableDef object is not able to be found. When I check my Tools->References menu I see…
WildBill
  • 9,143
  • 15
  • 63
  • 87
5
votes
1 answer

Run-time error on appending linked table in MS Access

I have a database that links to an Excel spreadsheet. When adding the linked table manually, I have no problems (I just follow the little wizard and the table is created perfectly). I am trying to automate that using VBA: Dim db as…
rryanp
  • 1,027
  • 8
  • 26
  • 45
5
votes
2 answers

Spell Check code in MS Access form field - throws error when change is accepted

I added the following code in the AfterUpdate event of a textbox in an MS Access form: Private Sub txtComments_AfterUpdate() With Me!txtComments .SetFocus If Len(.Value) > 0 Then DoCmd.SetWarnings False .SelStart = 1 …
Michael T
  • 1,745
  • 5
  • 30
  • 42
4
votes
1 answer

Running MS Access saved query from c#

Found very strange behavior of MS Access database when running queries from c#. It appears that if query in MS Access contains "like" statement it will not return its result to Oledb. If anyone knows how to solve this I'll be very grateful. c#…
Vadim
  • 107
  • 2
  • 8
4
votes
1 answer

change linked tables absolute paths to relative

How do I do the above in MS Access 2003? I have a lot of linked tables with absolute paths, I want to remove the directory part of all paths to refer to current directory.
Tomas
  • 57,621
  • 49
  • 238
  • 373
4
votes
3 answers

Microsoft Access ODBC Connection Strings Limited to 255 Characters?

Microsoft Access 2003 database (.mdb) containing a linked table which connects via ODBC to a backend Microsoft SQL Server 2008 table. When I enter design view for the linked table, then view the Properties field, I can only see the first 255…
iokevins
  • 1,427
  • 2
  • 19
  • 29
4
votes
1 answer

How do I edit an Access ADP file?

So I have this Access Database Project file that I have been tasked to edit. I have Access 2003 and 2007 installed. The ADP only supports 2003 for some reason. Anyway, the issue I have is that I can't figure out how to get to the VBA code in…
Michael Beck
  • 2,806
  • 3
  • 20
  • 22
1
2
3
…
53 54