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
26
votes
6 answers

Now() function with time trim

So the function =Now()....is there a way I can use this and only get the date, not the time? or is there just a function for this idea?
Justin
  • 4,461
  • 22
  • 87
  • 152
12
votes
6 answers

VBA Code to Close an Access Database Without Leaving a Shell of the application open

I'm currently using Application.Quit which leaves a shell of the MS Access Application open. After processing the calling function against the target application, I am left with every instance of the application remaining open still; even though…
user110236
12
votes
1 answer

create form to add records in multiple tables

I am new to access (I have only 2003 version) and I am getting crazy. Consider also that I am a novice with DB in general, so now I am at the point that I am very confused... please help. I am trying to design a database to catalogue all the books I…
rodedo
  • 791
  • 4
  • 10
  • 23
11
votes
3 answers

How to determine if any row is selected in a listbox

I have a list box in my Access form. I need to know if any of the rows in this list box has been selected by the user. Is there any simple Access property or method exists for this purpose? I do not want to loop through the listbox to check if any…
got2nosth
  • 578
  • 2
  • 8
  • 27
11
votes
7 answers

MS Access: There isn't enough memory to perform this operation

I'm using Access 2003 on a duo-core machine with 4GB of RAM, running Windows XP (Service Pack 3) [5.1.2600] Periodically, I get an error msg "There isn't enough memory to perform this operation. Close unneeded programs and try the operation…
maxhugen
  • 1,870
  • 4
  • 22
  • 44
10
votes
5 answers

inserting multiple rows with 1 query

I have problem in inserting multiple rows with 1 query using ms access 2003. When I use INSERT INTO like the code below INSERT INTO Employee values ('1','b','c'); INSERT INTO Employee values ('2','d','e'); the problem, ms access always appears…
noname
  • 121
  • 1
  • 1
  • 6
9
votes
3 answers

how to use distinct in ms access

I have two tables. Task and Categories. TaskID is not a primary key as there are duplicate values.When there are multiple contacts are selected for a specific task,taskid and other details will be duplicated.I wrote the query: SELECT Priority,…
bsm
  • 1,793
  • 11
  • 30
  • 41
8
votes
3 answers

Create a comma-separated string from multiple rows of one column?

I've an access table like this ID | UserName | CarBrand ------------------------- 0 Peter VW 1 Peter Ferrari 2 Mike Audi 3 Peter Dodge 4 Heidi BMW 5 Heidi Ford I need the names from the CarBrand…
Joseph jun. Melettukunnel
  • 6,267
  • 20
  • 69
  • 90
8
votes
2 answers

Unique constraint on multiple fields in Access 2003

I have not found any answer regarding my question, all unique constraint questions did not involve MS Access. The question is how to make a unique constraint on multpile fields in MS Access 2003 database? If my table consists of columns id, A, B,…
MPękalski
  • 6,873
  • 4
  • 26
  • 36
8
votes
4 answers

How to increase performance for bulk INSERTs to ODBC linked tables in Access?

I have CSV and TXT files to import. I am importing the files into Access and then inserting the records into a linked Oracle table. Each file has around 3 million rows and the process is taking a long time to complete. Importing into Access is very…
ravi chaudhary
  • 617
  • 4
  • 15
8
votes
2 answers

"'PK_dbo.TableName' is not a valid name" with Access ODBC linked table to SQL Server

I am trying to link an Access 2003 DB to tables in a SQL Server 2008 database using ODBC. When I try to link to tables that have Primary Key established I get the following error message. " 'Pk_dbo.Batch_Claims' is not a valid name. Make sure that…
user234872
  • 215
  • 1
  • 4
  • 6
8
votes
1 answer

MS Access 2003 - Opening a report without it printing

I used Docmd.OpenReport "Report1" from another form and it seems to just want to print the report without actually displaying it. I want to display the report, not print it
Justin
  • 4,461
  • 22
  • 87
  • 152
8
votes
2 answers

query to count number of different values?

I have a table in MS Access 2003 that looks like this: *url id* example.com red example.com blue example.com blue other.com red other.com orange more.com blue For each URL I want to…
Raymond
  • 140
  • 6
7
votes
1 answer

How can I populate textbox through VBA in MS Access?

I have a table RR_info which hold following fields RR_ID, HR_ID, No_of_Beds, Room_Category. Now i want that through VBA code with Form_load event I should populate textboxes for all these table fields. For this I wrote a query which get certain…
Rizwan Safdar
  • 125
  • 2
  • 2
  • 11
6
votes
4 answers

How does Access's query editor decide whether to discard my formatting?

Like a lot of developers who are comfortable with SQL syntax I get frustrated when working with Access's query editor. I'm talking about the raw SQL Syntax view, obviously. One of its many annoying properties is that upon saving it will discard my…
hawbsl
  • 15,313
  • 25
  • 73
  • 114
1
2 3
…
53 54