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

Can't add records in form

When I am trying to add the new record in the McAccess form, I receive this message: "The current field must match join key in the table that serves one side of the one-to-many relation. Enter record in one side table with the desired key value then…
Hell_77
  • 69
  • 2
  • 3
  • 9
0
votes
1 answer

searching for filtered duplicates in access query

i have the following problem in MSACCESS 2003 i have a query called A_Gravur which 3 columns SP1, SP2, SP3 now i want to search for duplicates. query A_Gravur: SP1 | SP2 | SP3 64 | CB75000 | 3 64 | empty | D 70 | CB70010 | 1 70 | CB70010 | 1 119 |…
user2153413
  • 15
  • 4
0
votes
1 answer

DB Access search textbox

StudentID > Number StudentName > Text StudentCNIC > Text StudentDOB > Date/Time I am trying to create a search textbox where the results are show in of the text boxes. I have a named a button calling it FindBtn where user enters of either…
bucketblast
  • 437
  • 4
  • 14
  • 37
0
votes
3 answers

Access 2003 SQL Switch breaks data types?

I'm running Access 2003. I'm using Switch to select date fields based on a boolean criterion: Switch(, Date1, 1, Date2) i.e., if "criterion" is true, then return Date1, otherwise return Date2. Date1 and Date2 are Date/Time type…
mph
  • 790
  • 7
  • 20
0
votes
1 answer

Microsoft Access 2003 - Expression Builder

When the user click the add button on the form, everything else is saved except for the field that uses expression builder in its control source. I understand the control source is the main source of saving the field into the table. How do i (or can…
GuessWho
  • 99
  • 2
  • 2
  • 10
0
votes
1 answer

MS Access Rounding issue

I have 3 values saleprice, productprice and reward_price. I need to have it look for saleprice first and if there is no saleprice then look at productprice. Then grab it and round it up or down by 50 cents. Soo.. 4.49 = 4 reward_price = 4 4.50 = 5…
Kristian Vazquez
  • 13
  • 2
0
votes
4 answers

Speed up MSAccess 2003 and MSSQL

I want to move my current DB from MDB to a MSSQL server. When I have done this through ODBC, queries became particularly slow. I have red that it's caused ODBC, that doesn't support group by and JOIN, join and so it has to do multiple queries and…
M4rk
  • 2,172
  • 5
  • 36
  • 70
0
votes
1 answer

How to write join select query in MSAccess?

Say I have these tables with field names underneath. DailyLeaveLedger dldEmployeeID dldLeaveDate InvoiceHeader invEmployeeID invWeekEnding InvNumberWeeksCovered So I want a query selects leave days where an invoice covers that leave ie…
Malcolm
  • 12,524
  • 28
  • 89
  • 125
0
votes
1 answer

how to publish a vb project?

I've finished a system using vb 2008 with an access database. now my problem is I have no idea how to publish it for a user testing. Could anyone help me/ teach me how to publish it.
mis_PG
  • 29
  • 1
  • 6
0
votes
3 answers

MS Access to SQL Server - Newbie needing advice/direction

So I have been working with multiple different MS Access apps at work (about 8) for different departments. And it looks as though there are going to stand up a SQL Server at work, which makes sense from a capacity/integrations…
Justin
  • 4,461
  • 22
  • 87
  • 152
0
votes
0 answers

How to Connect SQL Server Express 2008 to MS Access 2003

Im trying to connect the two applications above. I've already set up the database on the SQL Server to act as the back-end for the overall application and I need MS Access 2003 to act as the front end. I managed to do it using MS Access 2007 which…
Katana24
  • 8,706
  • 19
  • 76
  • 118
0
votes
1 answer

Getting contents of textbox in custom form

Currently I've attached a function to a command button on my form which retrieves what the user inputs into the textbox on the form; this works fine but I want to emulate this behaviour with the ENTER key. How can I go about doing this? I tried the…
Katana24
  • 8,706
  • 19
  • 76
  • 118
0
votes
2 answers

VBA Access New Record When Submitting Form

I'm working on a form that contains 6 fields, and all must be filled out before the form is submitted and a new record is created. Instead of loading a form with each field hardcoded to show up blank, I used: Private Sub…
Grant
  • 903
  • 1
  • 16
  • 24
0
votes
1 answer

ms-access 2003 form data entry stopped working

I have a form with a subform that at one point allowed for data to be modified. It now gives an audible "bing" when I try to change a field. My save cmd button now displays the error "The command or action 'SaveRecord' isn't available now." My…
Desert Spider
  • 744
  • 1
  • 13
  • 31
0
votes
1 answer

MS-Access Between Dates Query

I have a query that is working fine with the exception of not calculating between certain dates. My initial Query SQL is SELECT Roster.UserID, SchedulingLog.Category, Sum(IIf([CatDetail] Like '*Gain*',[Value],0)) AS Gain, Sum(IIf([CatDetail]…
Desert Spider
  • 744
  • 1
  • 13
  • 31
1 2 3
…
53 54