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
4
votes
3 answers

Check null value in MS Access Query

In SQL Server we can use IsNull() function to check whether expression value is null or not. For ex. Select IsNull(sum(amount),0) as TotalAmount From Payments Likewise is there any function in MS Access Query to check the null? I need the same…
IrfanRaza
  • 3,030
  • 17
  • 64
  • 89
4
votes
2 answers

MS Access 2003 - Help understanding the structure of mdb, mde and be

I was just wanting some explanation as to what is going on once you have split your tables out into a back end file, and set an mde out for use. When a user accesses the mde, is the mdb still required to get to the tabes (or in order to make it…
Justin
  • 4,461
  • 22
  • 87
  • 152
4
votes
1 answer

INSERT INTO statement, new record: how to grab autoid number created?

I have a button click event that takes information from controls and enters it into a table via INSERT INTO SQL statement in VBA. I was wondering if there is anything I could add to this, or some other method to acquire the record number that is…
Justin
  • 4,461
  • 22
  • 87
  • 152
4
votes
3 answers

How can I make Access combo boxes unfurl on arrow key down?

With combo box controls, I'm used to being able tab to them, click the down arrow key to open up the options, and then use the up and down arrow keys to navigate those options. In an Access form I've designed, pressing down while a combo box is…
Matt Parker
  • 26,709
  • 7
  • 54
  • 72
4
votes
3 answers

Access 2010 report ignores filter placed on it

I have run into an error with an Access Database created in MS-Access 2003. It's known the Calendar Control was deprecated in Access 2010 but unfortunately we need to keep using it. As a temp fix (until we can change to the date picker) we…
Robbeh
  • 98
  • 1
  • 11
4
votes
2 answers

Opening an MS-Access database from the command line without running any of the startup vba code?

Is there a way to open an MS-Access 2003 database from the command line without running any of the startup vba code or displaying any errors? I looked at the command line arguments for MS Access and there doesn't seem to be one for specifying that…
leeand00
  • 25,510
  • 39
  • 140
  • 297
4
votes
1 answer

How to link Access table to SQL Server with VBA

I am trying to create a linked (or imported) table in Access with a SQL Server backend. Basically the business users periodically need a copy of the table [SQL Rulesnew] (yes, with the space, sigh) so we want to give them a little Access 2003 tool…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
4
votes
1 answer

How to schedule a call to an MS Access macro?

I'm looking to schedule a call to an MS Access macro. This macro uses a .csv file (that I get daily) to update a SharePoint calendar. Could someone please explain how to schedule a daily call to run this macro (I'm using Access 2003, say…
Dmitri Boulanov
  • 87
  • 2
  • 10
4
votes
4 answers

Error adding column using SQL command in MS Access 2003

I want to add a column to my EMP_2 table. The new EMP_PCT column will store a percentage as a number, for example 20% as 20.0. I tried to input this method. But it gave a syntax error in the ALTER TABLE statement. Why is it not working? Below is the…
user1933884
  • 43
  • 3
4
votes
2 answers

Microsoft Access runtime error 2455 when trying to access grandchildren forms from child form

I have three forms in an Access 2003 database (developing in Access 2007) that sit in a parent -> child -> grandchild relationship. In the 'Form_Load' sub of the child form, I set some properties of the grandchild (form header, row source, and…
asgallant
  • 26,060
  • 6
  • 72
  • 87
3
votes
1 answer

Access 2003 VBA / Sql Update TableA on count condition also in TableA

I'm very new to Sql, and having trouble wrapping my brain around the syntax. I have a table PM (with Fields Acct, Amt, Action, Reason), and I need to update a few fields in the table wherever count(Acct)>1, and the Amt is the same. Specifically,…
graidan
  • 151
  • 2
  • 11
3
votes
1 answer

How can I hide a sub-report that has no records

I have a sub report on another report that could have no records in it. Is there a way I can hide the report (and its label) when there are no records to display? Alternately, is there a way to return a single row (e.g., "None") when an SQL re-query…
BIBD
  • 15,107
  • 25
  • 85
  • 137
3
votes
6 answers

Access: Shell cmd Open MDB

I have been using the following command to open another MDB Access file via VBA: Shell "cmd /c " & Chr(34) & strNewFullPath & Chr(34), vbHide strNewFullPath is the full path of the MDB file. Works fine when using Access 2010, but doesn't run on…
Rick
  • 2,288
  • 18
  • 66
  • 98
3
votes
2 answers

environ("username") versus advapi32.dll

I know there are at least 2 ways of retrieving the username in an Access application. You can use the environ function: environ("username") And you can use GetUsername in advapi32.dll Public Declare Function GetUserName& Lib "advapi32.dll" Alias…
SouthL
  • 175
  • 2
  • 12
3
votes
5 answers

SQL select query not working. in ms access 2010

here are my two charts and my query. Obviously you do see that some parameter names match. but my query shows up as no results. WHY IS THAT? Thank you . Altho this query was made in access 2010 it also works in 2003 and 2007 if you cant read the…
Chaostryder
  • 223
  • 2
  • 8
  • 18
1 2
3
…
53 54