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

Migrate MS Access DB to SQL Server Compact Edition

I have a MS Access DB and I need to migrate it to SQL Server Compact Edition. Is there any migration tool for doing it? I need to migrate DB structure and data. Thanks
Francisco Goldenstein
  • 13,299
  • 7
  • 58
  • 74
3
votes
2 answers

Dynamically resize a report Detail area

Is it possible to resize the Detail area of a report dynamically, in MS Access? I have a report and the Detail region has 2 rows, I'd like one of them to be "optional" - when there is no data it should not display and the Detail region should only…
FrustratedWithFormsDesigner
  • 26,726
  • 31
  • 139
  • 202
3
votes
4 answers

Adding values in two diff columns in ms access using sql query

Hey I was wondering you know how its possible to use "-" to subtract in the SELECT part of a query. So can you also use "+" to add? I've tried that and instead of adding the values together it does this 123+0.28=1230.28 does that maybe have…
Chaostryder
  • 223
  • 2
  • 8
  • 18
3
votes
1 answer

MS Access Select Query fields based on date range given

I have taken over management of an Access 2003 database for a medical clinic. Unfortunately, the person who created the DB didn't know much about databases and threw everything into one HUGE table. So right now I have a table called All Clinic…
Crystal
  • 31
  • 1
  • 3
3
votes
2 answers

Use VBA to loop through combo box list and run MS Access macro for each

Currently I have an MS Access 2003 form with a combo box list of names. The way to use this tool: You select a name from the drop down and then click the MS Access Macro which runs (3 different queries) based upon name selected and then you open a…
Weasy
  • 31
  • 1
  • 1
  • 2
3
votes
3 answers

Ahhhhh! Where did the subform go?

I have a form called Group in my MS Access ADP. On it is a tab control, and in each of the tabs there is a subform. The first tab contains the subform Users, and it isn't showing up in form view. Subform Users shows up in design view. Any clue as to…
dmr
  • 21,811
  • 37
  • 100
  • 138
3
votes
1 answer

Changing connection params when using pass-through query

I have an Access 2003 application that I would like to create reports for using stored procedures via pass-through queries. Everything works fine with one exception. When I specify the stored procedure to use for the pass-through query I have to…
webworm
  • 10,587
  • 33
  • 120
  • 217
3
votes
2 answers

Select into table in another database that is password protected?

In Microsoft Access 2003 and Visual Basic 6 I'm trying to copy a table to another access database that is password protected like this... Select * INTO table2 IN 'database2.mdb' [;Password=TestPass] From table1 It fails with error : Not a valid…
Brian
  • 292
  • 1
  • 2
  • 7
3
votes
2 answers

calling oracle stored procedure in ms access without saving password in pass through query

I am working on MS ACCESS 2003, i need to call oracle stored procedure through ms access. I am using pass through query to call the procedure. I have created user DSN with Microsoft driver for ODBC and successfully able to call the procedure.…
ravi chaudhary
  • 93
  • 8
3
votes
1 answer

MS Access form_current() firing multiple times

I have a form with two subforms (on separate tab pages). It's an MDB project in Access 2003. When it initially opens, Form_Current on the active subform fires once, as it should. But when you move to another record (ie. from the main form), it…
Eric G
  • 171
  • 2
  • 9
3
votes
3 answers

MS Access 2003: Can data disappear from records and how do I test for this and prevent it?

Problem and about the database: Data from a record in Access 2003 database has disappeared. This database has 1 backend and 3 frontends, multiple users and is hosted on Citrix. Within this database, we have records of all clients served, ranging in…
user328960
  • 31
  • 1
  • 3
3
votes
3 answers

MS Access group development

We are planning to redesign quite a huge MS Access application. Is there any way to work concurently on the same application or is it possible to merge two seperate instance of the same file (not the data, but the forms and code). Now Access…
Hubidubi
  • 850
  • 4
  • 18
  • 34
3
votes
3 answers

Share a mdb file over network, for many computers, can't edit the application

The company is using an old Delphi software, that uses a .mdb file as database. I can't change the way the application works, I don't have it's source. We are facing many problems such as: Lock problems When an user adds an entry, it doesn't update…
BernardoLima
  • 1,103
  • 2
  • 16
  • 35
3
votes
1 answer

Open Excel file from Access and copy a picture to the Access form

So I have an excel workbook that has a nice global map of shaperange objects. With some very simple code I can change the colors, group and ungroup collections of countries into arrays, etc...and it works pretty well. However, I would like to bring…
Justin
  • 4,461
  • 22
  • 87
  • 152
3
votes
2 answers

Check folder exists in Access Continous Forms

I'm modifying an existing Access 2003 application, through some machines have Access 2010 instead of 2003. I have a continuous form which includes an unbound textbox with the word "folder". The textbox has an onClick event to open a folder which…
andy295
  • 33
  • 2
1 2 3
…
53 54