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

Excel-like data entry form for access 2003 database

I am trying to convert an excel spreadsheet for staff training records into an Access 2003 database. I have set up the database into 4 tables: Staff, Tasks, Trainers, and TrainingRecords. The training records table has the following fields: RecordID…
Dave Williams
  • 1
  • 1
0
votes
1 answer

Syntax error or access violation in MS-Access stored proc?

I'm attempting to create a very simple stored procedure with one parameter in MS-Access 2003. CREATE PROC procTest(lname VARCHAR(50)) AS SELECT * FROM T_Employees t WHERE t.LastName = lname; I get the error: Error: [Microsoft][ODBC Microsoft…
leeand00
  • 25,510
  • 39
  • 140
  • 297
0
votes
1 answer

Joining in ms access

I have 3 tables Payment_Schedule (Event_ID, Event_Type, Event_Incharge, Event_Date) Product_AMC (AMC_ID, Customer_ID) Item_Order (Order_ID, Customer_ID) For a record in Payment_Schedule, Event_ID is either AMC_ID or Order_ID. If Event_ID is a…
Krishanu Dey
  • 6,326
  • 7
  • 51
  • 69
0
votes
0 answers

Can I perform a count distinct query on values selected from a listbox?

I have a select distinct query that works find on selected fields from a listbox. However I would like it to be a count distinct and I can't seem to get the code right. Below is my working code for select distinct. Thanks in advance for any…
JenPhyllisB
  • 133
  • 1
  • 7
0
votes
1 answer

More efficinet way to filter form

I have the following code: Public Function BuildSQL(stQueryName As String, stWhereClause As String) As String On Error GoTo Err_BuildSQL Dim SQLcmd As String Dim intPos As Integer Dim db As Database Dim qryOrig As…
rodedo
  • 791
  • 4
  • 10
  • 23
0
votes
1 answer

Progressbar doesn't appear in my Form

I want to show a Progress bar to user, while I delete and Insert into a table. I use this block of code but I can't see the progressbar in the form. Would you please help me to solve this problem? SysCmd acSysCmdInitMeter, "Updating: ", 1000 For…
Kabi
  • 1,905
  • 5
  • 20
  • 22
0
votes
1 answer

Single form to display output from several queries

Thanks to the help received in other questions and some good tutorials I could create my access database to hold the books in my library and I have a good form now (with several sub-forms) to enter new books into my database. (It is all based only…
rodedo
  • 791
  • 4
  • 10
  • 23
0
votes
1 answer

NotInList script

I am trying to use Access and VBA to create a DB to store my library. I already posted a question and got a useful answer but I am still failing with the basics, so, after having checked this tutorial link I am starting from scratch and doing it in…
rodedo
  • 791
  • 4
  • 10
  • 23
0
votes
1 answer

Is it possible to use CROSS JOIN + INNER and/or OUTER join on Access 2003? If so, how? Probably also needs subquery...?

I have a database with several tables: [Plan Revenue], [Plan Revenue Expense], [Support Provider], [Z Service Codes New] I've already got a query written that will give me a count of how many expense records are listed for each provider in specific…
Michael Gmirkin
  • 11
  • 3
0
votes
1 answer

Loop through recordset to populate listbox with results of SQL query?

I have a multi-select listbox which I want to be the source of a sql query with results displayed in a listbox. Currently I have the results going to a recordset which is displayed beautifully when only one 1 field is selected. For instance, if the…
JenPhyllisB
  • 133
  • 1
  • 7
0
votes
1 answer

Run SQL query on each item in multiselect listbox and show results in another listbox?

I'm running a "select distinct" query on fields selected in a multiselect listbox (the listbox is populated with fields from a table). The code worked fine before I made it multiselect, and now the SQL query is not functioning. For example when I…
JenPhyllisB
  • 133
  • 1
  • 7
0
votes
1 answer

READ ONLY pop-up when opening Access mdb, but in fact it is not according to Properties

Any idea on why I open certain MS Access mdb file(abc.mdb), msgbox pop-up saying that it is READ ONLY, but in fact it is not when I right-click the mdb to view "Properties"? The folder where mdb locates can write folder/txt files in it. I copy a…
Tsui John
  • 107
  • 3
  • 21
0
votes
3 answers

Populate list box from a table in vba

I am developing a vba form for employee database, in that there is a search criteria for userid and employees name with the userid should be displayed in a list box control which comes from a single table I need to populate a list box with value…
SmartestVEGA
  • 8,415
  • 26
  • 86
  • 139
0
votes
1 answer

Why does this SQL statement ask for a value?

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 the user clicks ok, the name should be stored in a…
Ish
  • 671
  • 5
  • 21
  • 36
0
votes
1 answer

MS Access Form Load

I have a form with two combo boxes and couple of buttons. One of the buttons (called "Roll Over") is for rolling over data from the previous year. When clicked it should be able to grab the data from the previous year and insert in the form for the…
Ish
  • 671
  • 5
  • 21
  • 36
1 2 3
…
53 54