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

VBA MS access functions

Following function is for evaluating dates called by procedure CheckEventDataIntegrity. This does only for events but now I want to add partnumber along with event type. Means it should evaluate dates with event and partnumber.How Can I do…
user397316
  • 139
  • 1
  • 2
  • 11
-2
votes
1 answer

Where can I download Access 2003 sample database Northwind.mdb

I am looking to find the 2003 version of the MS Access Northwind database because I want to look at the switchboard functionality which is not used in the later Northwind database versions. Since Microsoft no longer supports 2003, it is no longer…
user12059
  • 733
  • 2
  • 13
  • 27
-2
votes
3 answers

I don't get the while loop executed

I can't make out what is the mistake. I wanted to retrieve a record from the database table and give them out. There are 9 fields in my table. The data of the second field is the search word. There can be more than one record for the same data. If…
-3
votes
1 answer

How to properly write to an Access (2002-2003) database using C#

I'm unable to write new entries to a local Access 2002-2003 (.mdb) database using C#, the problem is the syntax of my cmdText property in the OleDbCommand class. PLEASE DO NOT mention Parametized SQL statements or SQL Injection, since this is only…
Stacklysm
  • 233
  • 2
  • 11
-3
votes
1 answer

MS ACCESS GROUP BY functions

What is the function of "where" and "expression" in the groupby? why we are using that in the design query for getting sorted output? Expecting a clear explanation.
-3
votes
1 answer

Regarding MS Access 2003 and VBA programming

My requirement is to add a blank table onto a Form in MS Access 2003 on which I can paste the data copied from the excel sheet. This table need to have the same column structure as excel sheet. But I am unable to find any UI component which can do…
Nuclear - Core
  • 159
  • 1
  • 2
  • 9
-4
votes
1 answer

Join query in ms access

I need to apply a join to 3 tables (invoice, payments, client) on the client ID; however, the join I need must include all the invoices and all the payments associated with a client ID. If we have a client that has a payment and no invoices (or the…
user2497624
  • 159
  • 9
-6
votes
3 answers

INSERT INTO syntax error in c#

please figure out the error in my code.it show syntax error INSERT INTO statement. OleDbCommand cmd = new OleDbCommand("INSERT INTO tbbill(invoice,datetime,custm,total,tax,grand)VALUES(" + Convert.ToInt32(txtinvoice.Text) + ",'" +…
Priyanka
  • 75
  • 1
  • 12
1 2 3
53
54