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
0 answers

ms-access same data entry for multiple userid's

I have a vacation database that tracks gained and used time. I have just found a shortfall in my applications design. For national holidays our managers that work receive a deferred holiday. I have found that my data entry form is tiedious to…
Desert Spider
  • 744
  • 1
  • 13
  • 31
0
votes
1 answer

ms-access 2003 combo box population

I have an entry form with a sub. I have three combo boxes that work together. combo 1 sets up with vba and an after event combo 2 and on into three. They work fine independently of the main form, but when I sue the form as a sub the cascade stops…
Desert Spider
  • 744
  • 1
  • 13
  • 31
0
votes
1 answer

ms-access 2003 countif in a report

I have a report that displays all office employees. I am trying to give a summary of employee by type in the foother of the report and I receive an #Error as a result. Report Detail Name DOH UserID Position Page Footer Text Box with…
Desert Spider
  • 744
  • 1
  • 13
  • 31
0
votes
1 answer

Microsoft Access 2003 Query - Count records and sum it

I'm creating a query with Microsoft Access 2003 and had encounter an issue. I'm new! I've got 2 tables. First table, i have a list of records that include the name, property name and the country state. Second table, i have a list of property names,…
GuessWho
  • 99
  • 2
  • 2
  • 10
0
votes
0 answers

Accessing detached .mdf database over TCP/IP

My problem is exactly as described in title, but I am not familiar with MS Access, and I'd like to avoid interacting with it at any cost. I have stumbled upon a point of sale (POS) system, which is built on MS Access. MSAccess Runtime 2003, to be…
Kai
  • 424
  • 5
  • 16
0
votes
1 answer

ms-access 2003 DateSerial Function Overflow Error

Possible Duplicate: ms-access built in function Month(number) In one of my queries I have the following function. DateSerial(Date(),[Roster]![DOH],[Roster]![DOH]) When I invoke the query I receive an overflow error. What am I doning wrong?
Desert Spider
  • 744
  • 1
  • 13
  • 31
0
votes
1 answer

MS-Access 2003 Limiting a query result based on an expression

I have a query that pulls vacation summary information. I would like to limit the results to greater than current anniversary date. When I riun the query with only the anniversary expression the anniversary expression works fine. When I put in…
Desert Spider
  • 744
  • 1
  • 13
  • 31
0
votes
1 answer

JET SQL for Access 2003

I have the following SQL statement: Select Choose(1,Orders.Employee, Orders.Customer) as Name1, Choose(2,Orders.Employee, Orders.Customer) as Name2, [Shipped Date] FROM Orders; However, the field "[Shipped Date]" has a space in it and hence why I…
Abs
  • 56,052
  • 101
  • 275
  • 409
0
votes
1 answer

Repeating subtotals in MS Access Report

The question seems to be quite simple, but I am not being able to solve it. I have a MS Access 2003 report that exports something like this: Europe Spain 2 3 4 England 2 2 4 France 1 2 3 Europe Total 5 7 11 Asia China 3 2 1 Japan…
Guillermo Gruschka
  • 167
  • 1
  • 3
  • 16
0
votes
1 answer

Set flag for main report in subreport

Ok, I'm a bit of a VBA newb. I have a report that's being generated based on a subreport. That all works fine. Now I need to add a conditional flag in the subreport to display the main report differently. Ie. if an item in the subreport has a value…
nathangiesbrecht
  • 845
  • 12
  • 26
0
votes
1 answer

Access 2003 - Running an update query based on select query results

I currently have a subform that displays a select query. I want to update all the records of Table B that are showing in the subform with information from the form. The subform is not necessary. I was just using it to make sure my select query…
mkmitchell
  • 681
  • 3
  • 10
  • 23
0
votes
2 answers

how to order by descending date-column with month and year in msaccess?

I want show order by Monthly New Issues should go from newest top of list, to oldest at bottom of list like November 2049, August 2049, December 2046, October 2046, march 2046,November 2012, October 2012, September 2012… I tried with following…
Sameek Mishra
  • 9,174
  • 31
  • 92
  • 118
0
votes
1 answer

Combining Excel Tables using Excel or Access 2003

I am trying to create a merged dataset using Excel or Access and am not having much luck. I have two Excel tables, both contain ID's that I can link them with. However, TABLE1 has only one row for each ID, TABLE2 can contain multiple rows for each…
Robert
  • 15
  • 7
0
votes
1 answer

How to find where the information is stored when entered through a form?

I have an already created database in MS Access 2003. It has forms that are used to enter data into tables. I want to create a report that shows the values entered through the forms. I am trying to find where the data gets stored when entered…
amir shadaab
  • 469
  • 3
  • 9
  • 23
0
votes
1 answer

Error messages when converting access 2000 to access 97

When using access 2003 to convert an access 2000 database to access 97 I get the following 2 error messages right after the other 'invalid argument' 'Some errors happened during the conversion. No converted database was generated.' Other than this…
kjack
  • 2,004
  • 3
  • 26
  • 41
1 2 3
…
53 54