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

Manipulate Form Controls at Record Level

I have a continuous form that is bound to a table. Beside each record of my form I have an "Edit" button. I want to know if I can manipulate the form controls at record level, meaning: when user clicks "Edit" button, the locked property of the…
got2nosth
  • 578
  • 2
  • 8
  • 27
0
votes
1 answer

SQL SUM on access 2003

I currently have the following query that i wish to execute SELECT Buyer.nCustomerID, Order.[Order Number], SUM(Order.[Order Total Cost]) FROM [Order] INNER JOIN [Buyer] ON Order.nCustomerID = Buyer.nCustomerID GROUP BY…
Liam Sorsby
  • 2,912
  • 3
  • 28
  • 51
0
votes
2 answers

Access VBA Object Required Error

This has probably been answered before, but in looking, I could not find an answer that suited my situation. I am coding an Access 2003 form button to run an If/Then and do some commands based on that statement when clicked. However I am getting…
user3208525
  • 1
  • 1
  • 2
0
votes
2 answers

Access subform unbound control #Error

I have a subform embedded in my main form as a datasheet. The subform's data gets populated after I select some filtering criteria and click "search" button. Everything works fine except one control I have in this subform. This is an unbound control…
got2nosth
  • 578
  • 2
  • 8
  • 27
0
votes
1 answer

Assign control source dynamically from a different recordset

I have the following VBA code in my access. Dim subform As Object Dim formFilter As String formFilter = "..." 'a SQL statement Set subform = Me!my_subform.Form subform.RecordSource = formFilter subform.field1.ControlSource =…
got2nosth
  • 578
  • 2
  • 8
  • 27
0
votes
1 answer

i have chart and i want fill it by searching between 2 dates ( my database is MS Access 2003 and i am using Vb.net Forms )

i have chart and i want fill it by searching between 2 dates ( my database is MS Access 2003 and i am using Vb.net Forms ) the error in SQL statment and the image link down shows the error my code is Try Dim MyStringDate1 As Date =…
Mak Haj
  • 37
  • 1
  • 2
  • 6
0
votes
1 answer

using wildcard to find records of a textbox linked to a query

I have a Textbox that requires me to type a number and then click a button to find the related values. but now what i need it to do is if i type 3 numbers Ex."123" it will return all the numbers that are related to any record starting with "123".…
Dre488
  • 23
  • 5
0
votes
2 answers

SELECT query causes "expression is too complex to evaluate or there is an error"

Initially there were 1000 records to evaluate.Now there are 40000.Please help! I'm only trying to obtain the week number of a transaction based on transaction date and start date. SELECT…
Vivek Adi
  • 1
  • 3
0
votes
1 answer

Is there a journal in MS Access? Can I disable it from C#?

Is there a journal (or transaction logs) in MS Access? If so, can I disable it from C#?
JohnVias
  • 1
0
votes
1 answer

MS Access 2003 - VBA for Parameter box that open after code is run: auto "ok"?

So there is a parameter box that open after a button click event runs an sql statement in vb for a list box to populate data. something like: me.listbox.rowsource = "SELECT tblMain.ID, TblMain.FirstName, TblMain.LastName, tblMain.MobileNumber FROM…
Justin
  • 4,461
  • 22
  • 87
  • 152
0
votes
2 answers

MS ACCESS 2003 - Question about passing information from an unbound form to a report

I use something like below to pass information from one unbound form to another (excuse the no error checking): Sub Button_Click() Dim db as DAO.database Dim rs as DAO.recordset Dim sql as string docmd.openform "NextFormIamAbouttoUse" sql =…
Justin
  • 4,461
  • 22
  • 87
  • 152
0
votes
2 answers

MS Access 2003 - Auto assigning an Identification Number

So I have a little db that is used for new hires in terms of who, where and what they are issued. One thing that is issued is laptops with little barcode/ID numbers, and I would like the db to auto assign an available ID number when the user is…
Justin
  • 4,461
  • 22
  • 87
  • 152
0
votes
1 answer

MS Access Adding a Filtering ToolBar to Form

I have Microsoft Access Form where I have table of data I want to be able to add a filtering toolbar to the form in MBE mode. Note MBE not in the designer mode of MDB. I.e. I want a filter on the distributed MBE file. In Form.Open event I …
user1119116
  • 837
  • 1
  • 8
  • 17
0
votes
3 answers

ms access 2003 - Text boxes on a form: not jumping to any text box

Ok so I add all these text boxes on an unbound form, and everytime you open a form, it sort of jumps to the first text box so you can enter some information into it. How do I get rid of that, because I do not want it to auto jump to the first text…
Justin
  • 4,461
  • 22
  • 87
  • 152
0
votes
1 answer

As Access Traverses A Recordset Does It Slow Down As The Index Increases, And Why?

I have the following scenario and was wondering if it was effecting the speed of execution Select statement pulls 100,000 rows and puts it into a DAO.recordset The recordset manipulates, we'll say, 5000 of those records at a time doing the…
Elias
  • 2,602
  • 5
  • 28
  • 57
1 2 3
…
53 54