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

How to merge data into a central SQL Server database via E-Mail with a WinForms C# application?

I have an old Access database (.mdb/2003) that was used as application for the sales representatives team. Problem: My task is now to write a WinForms application that every sales representative will in future have on his laptop. All data that each…
oldsport
  • 993
  • 2
  • 14
  • 37
0
votes
1 answer

Connect to remote Access 2003 database which has linked tables

I've got this scenario: I developed a C# application which connect to a mdb file (Access 2003) through OleDBConnection (engine = Microsoft.Jet.OLEDB.4.0). This mdb file has some linked tables in another mdb file in the same directory. Everything…
lupus
  • 26
  • 5
0
votes
1 answer

Docking datagridview bottom

I'd like to make datagridview docked bottom. But when I press the key, nothing happens. Here's my code: Private Sub MakbuzTDataGridView_KeyDown(sender As Object, e As KeyEventArgs) If e.KeyCode = Keys.F9 Then MakbuzTDataGridView.Dock =…
nikel
  • 653
  • 4
  • 13
  • 24
0
votes
0 answers

How to show ole image of mdb in a form

I have an mdb database with some pictures. I would like to show these pictures on my form. I dragged the datagrid to my form but when I test it, I'm getting error. Here's a screenshot: screenshot http://img842.imageshack.us/img842/8487/60j9.png How…
nikel
  • 653
  • 4
  • 13
  • 24
0
votes
4 answers

SQL Virtual Table

I have my database set up as such: Each product I have has it's own table where it records the quantity sold/transaction # (so column 1 is "transactionID", column 2 is "quantity") ex) p-backScratcher (where p- is indicative of "product") There are…
SnakeWasTheNameTheyGaveMe
  • 2,522
  • 2
  • 28
  • 70
0
votes
1 answer

Can you have your main screen on your database to be set to 'maximize' and then additional screens to be set as a 'pop up'?

I have recently made a database in Access which has one main screen ( well several but they all follow the same layout and format) and on the main screen there is buttons for example; add new employee. Is there a way to set the 'main screen' so it…
clarerome
  • 23
  • 1
  • 2
  • 11
0
votes
2 answers

Ms access query

My MS-Access query is strSQL = "Select pincode from pincodes WHERE officename = '" &area& "' AND Districtname = '" &city& "';" but when I run this query it shows record not found even the value that are passing in area and city exist in ms…
satish
  • 17
  • 1
  • 5
0
votes
2 answers

How to check if a row exists in a specific position. VB.NET 2008 + msaccess 2003

I'm trying make a code for vb.net 2008 + msaccess 2003 to check if there is a row in a specific position between 2 rows, to be used on inserting data, which the previous data was deleted. (sorry for my bad english) for example: there are data in…
user2806886
  • 5
  • 1
  • 1
  • 4
0
votes
3 answers

How do I add an email preview button to a form in MS-Access 2003

I'm creating a form on MS Access 2003 that will send out a html email newsletter to a list of email addresses. How do I put a preview button into my form that will let me preview my email before I send it? I think I have to use an active-x control,…
dmr
  • 21,811
  • 37
  • 100
  • 138
0
votes
4 answers

SELECT * from table like from text box. (vb.net 2008 + ms access 2003)

I've been trying make a SQL LIKE statement for a search button to display data to, but it doesn't work . I've tried searching about it and even copy-pasted some of the working codes but still no.. I'm really new to this so please excuse my fail…
user2806886
  • 5
  • 1
  • 1
  • 4
0
votes
1 answer

There is an error in this MS Acess 2007 Subquery

i have two tables. first table passenger_info has information regarding passengers and second table seat_no has only one field which is seat_no. now i need to get the seats nos in seat_no field but all only all those which are not yet assigned…
Rizwan Safdar
  • 125
  • 2
  • 2
  • 11
0
votes
1 answer

how can i fix following VBA code

this code is to populate textboxes in form where sql query is fatching data from table RR_info on the behalf of hr_id. it compare hr_id of rr_info with the bounded value of listbox. Private Sub Form_Load() Dim SQL As String Dim db As…
Rizwan Safdar
  • 125
  • 2
  • 2
  • 11
0
votes
1 answer

access 2003 cycle current page not working if subform is in form view

I have a form with multiple sub-forms. I would like to have the following behaviour: pressing the tab key in the last field of the main form or in the last field of a subform the focus moves to the next subform or back to the main form according to…
rodedo
  • 791
  • 4
  • 10
  • 23
0
votes
0 answers

Bad Behavior after upsizing MDB to SQL Server (no upsize_ts in Table)

maybe you could help, i didn't find any proper solution for my problem: Working Environment: Access 2003 SQL Server 2008 R2 Express Database (based on Access 2003) containing a few dozens of Tables, related to each other: - Table "Customers"…
Daniel Alexander Karr
  • 325
  • 1
  • 4
  • 16
0
votes
2 answers

Connecting MS Access to Oracle SQLDeveloper

I want connect my MS access 2003 with Oracle SQLdeveloper so that I can do analyis in SQLDeveloper. I am trying to create ODBC driver but it is not working.I am wondering if any of you send me the links or explain how can I create a ODBC connection…
user2612244
  • 21
  • 1
  • 2
  • 8
1 2 3
…
53 54