ms-access-2003 Questions
4
Solved
On a report I have the following code for a field:
=Sum([PartQty]*[ModuleQty])
Example results are 2.1 and 2.6. What I need is for these value to round up to the value of 3. How can I change my ...
Telpherage asked 1/4, 2010 at 10:17
4
Solved
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 l...
Shackelford asked 16/9, 2014 at 7:57
3
Solved
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 no...
Pontifical asked 10/1, 2014 at 7:29
4
Solved
I actually have 2 questions:
1. How might I see who is using my Access database?
E.g: There is someone with an Access database opened and it created the .ldb file, I would like to see a list of ...
Ardatharde asked 9/4, 2013 at 10:50
3
Solved
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...
Ibnsaud asked 13/10, 2011 at 8:2
2
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_d...
Mcadoo asked 29/3, 2010 at 17:35
4
Solved
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 annoyin...
Piddle asked 8/11, 2011 at 11:15
6
Solved
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?
Terris asked 24/6, 2010 at 1:10
6
Solved
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...
Dogtrot asked 17/9, 2012 at 21:3
5
Solved
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',...
Koski asked 28/12, 2012 at 5:15
3
Solved
I've encountered the run time error '3075'. I'm a novice in VBA! >.< Can i know where did it went wrong? I can't solve it...
For e.g, if I enter a name "Sally" into a textbox (txtMainName), upo...
Processional asked 28/12, 2012 at 3:27
1
I am trying to export two MS Access table into one .csv file. I am not able to do so, i am able export these two table into two different csv files. I need both tables to get exported into one csv ...
Virginity asked 8/10, 2014 at 7:29
2
Solved
Is there a way to open an MS-Access 2003 database from the command line without running any of the startup vba code or displaying any errors?
I looked at the command line arguments for MS Access a...
Eraeradiate asked 20/5, 2013 at 19:52
3
Solved
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 wi...
Heartache asked 26/4, 2011 at 9:46
2
I have three forms in an Access 2003 database (developing in Access 2007) that sit in a parent -> child -> grandchild relationship. In the 'Form_Load' sub of the child form, I set some properties o...
Clynes asked 1/5, 2012 at 17:17
1
Solved
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 fie...
Mona asked 18/9, 2013 at 6:22
3
I'm trying to run the following as criteria in an MS access query. Basically what I want to do is:
If checkbox = True then all records, including those with blank or Null fields are shown (the de...
Supercilious asked 16/2, 2012 at 11:0
1
Solved
I'm trying to use a macro/.mdb file that was written in Access 2003 in a new Access 2010 Access install. Opening my file I get a compile error saying the TableDef object is not able to be found. Wh...
Omaomaha asked 17/12, 2012 at 16:29
2
Solved
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 kn...
Barabarabarabas asked 13/12, 2012 at 1:37
1
Solved
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 tryi...
Joly asked 26/8, 2012 at 15:11
2
Solved
I added the following code in the AfterUpdate event of a textbox in an MS Access form:
Private Sub txtComments_AfterUpdate()
With Me!txtComments
.SetFocus
If Len(.Value) > 0 Then
DoCmd.SetWa...
Kelcey asked 2/8, 2012 at 19:11
1
Solved
I have a form which lets you add names to the table and shows it in a dropdown menu.
When I click on the form, it should ask the user to enter the name they would like to add and click "ok". Once ...
Somatist asked 26/6, 2012 at 15:21
7
Solved
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. C...
Foiled asked 15/10, 2009 at 22:28
1
Solved
I have a MS Access 2003 database with a table called product1 with a Primary key named Product Code. There is no auto id column.
I have used this sql to do the custom data paging.
SELECT *
FROM ...
Durga asked 2/8, 2011 at 15:36
2
Solved
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 ...
Selfdeprecating asked 12/4, 2011 at 13:18
1 Next >
© 2022 - 2024 — McMap. All rights reserved.