Stack Overflow
Stack Overflow

Questions tagged [ms-access-2002]

Questions regarding the Microsoft Access 2002 database management system.

14 questions
5
votes
2 answers

From main form, run VBA to validate total in subform

I have a form in MS Access 2002 with the following snippet of code behind a command button. 'Requery subform to make sure total is calculated Me.fsubUpdateShipments.Requery DoEvents 'Confirm quantities have been entered If…
Aiken
  • 2,628
  • 2
  • 18
  • 25
2
votes
2 answers

MS SQL 2008/Access 2002 VBA - Check DB for current record, if does not exist then enter it

I'm trying to create an SQL string that will check the table Notification for the current record criteria (two different ID values). If it finds a record with both of these values, it won't enter this record into the table. If it doesn't find it, it…
user3608243
  • 63
  • 6
2
votes
2 answers

Edit a query with left join tables

I'm having some trouble in Access 2002... I have two tables, one containing around 60k occurrences and one with a column and the foreign keys to make the join. In my form, I set the source to a query with these two tables joined (left join on the…
Estarius
  • 1,219
  • 3
  • 13
  • 24
1
vote
1 answer

MS Access 2002 / MS SQL 2008 R2 - Problems deleting records based on certain criteria

I'm trying to get my code to delete records from an access 2002 database table that is linked to an MS Sql 2008 database table through a form event. I just want it to delete all records where User is null and Date is null. Here's the snippet…
user3608243
  • 63
  • 6
1
vote
0 answers

Access 2002 without outlook send emails

I developed desktop application which generates bunch of reports. I want to add functionality to send that report via email. The only problem is, not all clients using outlook for sending emails. Is there any other way to send emails using my own…
Ricky Patel
  • 329
  • 3
  • 13
0
votes
0 answers

Merging two MS Access Forms with Git

I have two .mdb files with one being a copy of the other. When there are made changes to the original mdb i want to merge them into my copy, which itself may have changed meanwhile. As I require to use access 2002 Version Theres a lack of helpful…
MyLifeWasBetterB4Coding
  • 43
  • 4
0
votes
0 answers

Receive Error while running Access database on Windows 10

I have a database created in Access 2002 which was working fine until 2 weeks ago (2019-02-15). I am running Windows 10 with MS Access 2013. I received a compile error: The code in this project must be updated for use on 64bit systems. Can anyone…
Nouman
  • 1
  • 2
0
votes
1 answer

Access 2002 VBA - Getting an Append Query error when trying to enter a value into a table

I have a form in Access 2002, with its fields being fed by a query. It displays record data row by row. There's a check box at the end titled Acknowledged. The goal of this form is for the user to acknowledge having seen the record. On the…
user3608243
  • 63
  • 6
0
votes
1 answer

How do I capture a DCount of a query before a form updates it in Access 2002?

I'm trying to capture the DCount of four different queries before a form can update them in VBA in Access 2002. The hope is to compare the old record count for each query with a current record count after the Save button has been clicked to see if…
user3608243
  • 63
  • 6
0
votes
2 answers

Access 2002 VBA: Creating an incremented Item Code

Ok, here's the deal. I have a previously existing SQL Server 2008 database linked to an Access 2002 database via linked tables/views. Up until now, the item code has been a nvarchar type. I have a SQL query which casts the item codes as Int and an…
user3608243
  • 63
  • 6
0
votes
2 answers

mssql-statement to append a record into a table with check for duplicates

I need a query for adding a data record to a table. I would like to check in advance whether the record, which is to be inserted into the table, already exists. Here is my code (it works): INSERT INTO table1(field1, field2) SELECT 'value1',…
rushifell
  • 11
  • 3
0
votes
0 answers

Access 2002 - how to link two data entry forms?

I have a form for users to enter contact (customer) details, and I want to add a separate form to enable users to add phone numbers to the data. They would open the second form by clicking on a button. Contact details are stored in a contact table…
Steve Cooke
  • 447
  • 1
  • 4
  • 14
0
votes
2 answers

Display only last characters in a textbox

I have an Access 2002 database/application where my clients can enter multiple information about their own clients, including a code which follow some rules. However, when they view these information after they have been entered, I need to hide…
Estarius
  • 1,219
  • 3
  • 13
  • 24
0
votes
2 answers

How to find a Label with Caption = "XYZ" in MS Access 2002?

In MS ACCESS, I can't find an approach to search over the Objects. I want to write a script or find a plug in for MSAccess 2002 to find objects by his property values I'm doing maintenance to a huge app in ACCESS and I'm dealing a lot to find the…
celerno
  • 1,367
  • 11
  • 30