That was a real fast reply.
Thanks worked perfect!
Ive another code problem, al post it, any maybe you might spot this one as well.
Thanks again
Man chun
chungiemo
Last Activity: Oct 17 '08, 12:43 PM
Joined: Jul 12 '07
Location:
-
Help with a error msg in a Search form
Hi Everybody,
I am using Alan Brownes Example of a search form example and I keep getting an error of the following:-
Enter Parameter Value Msg Box with the entered Value "Mar" and I re-enter "Mar" the value is displayed. Then the query works.
I don't know why this msg box keeps on displaying. Hopefully somebody can help me with this.
A bit more info down below........ -
Database Design DVD Movie Collection Database
Hi Everybody,
Apologies if in wrong section
I am designing a DVD Movie Collection Database for my own personal use and requiring a little help.
Brief description: The key tables are tblMovies, tblLoans with the following key fields
MovieID (Autonumber)
MovieTitle
Status: Available or Not Available
LoanID
MovieID
MemberID
LoanStatus: Status... -
Help for Access VBScript compare 2 db with partial ID
Hi
thought I would do another thread as this one is a bit different from the previous problem
I am looking for a solution to the relating problem
Comparing 2 access databases with 2 tables, they are non-related tables, but should have been related by the ID, and reason for this was due to the poor data entry standards. I am trying to compare both databases with a Partial ID in Table 1 and match it to the... -
A BETTER EXAMPLE OF THE FORMAT OF WHAT AM TRYING TO MATCH WITH THE PARTIAL ID
Table 1
ID: WIG737976, Firstname: SARAH, Lastname: NEVANS
WIG995472 STEVEN DORIS
WIG995473 LEE HANNAH
WIG995476 PAUL GOWRAN
WIG998787 TRACY ...Leave a comment:
-
Thanks for the reply rossmrn
It worked for what I posted on the forum but what if the numbers do not match in their relative position, as some records in Table 2 ID have been entered by the 6 first numbers, while some have been entered by the 6 last numbers taken, in addition some records in table 2 ID contains either 10 or 9 characters in the field.
Table 1
ID: 50998787E
Firstname: John
Lastname:...Leave a comment:
-
Partial Search and compare between 2 Access Tables
Hi
I have a project with access
it has 2 non-related tables in access, which should have been related by ID, due to the poor data entry standards I am trying to match records from table 1 to table 2. I hvae tried the simple "Like" operator in SQL but it does not like matching to another table but instead a specified criteria
Example
Table 1
ID: WIG102898
Firstname: John...
No activity results to display
Leave a comment: