Thnx for reply. What is the Access equivalent for this code and where do I put it?
deejow...
deejow
Last Activity: Aug 12 '07, 01:41 PM
Joined: Jul 21 '07
Location:
-
Code to look for and match a text string in a field
Hi,
In a new record in a "Jobs" table, I enter the "ClaimantID " (the person who this job involves) but I want to know whether or not this particular Claimant has had jobs done on them previously, and if so, who the person responsible for working on that job was (found in a separate field called "PI").
Can I write code that asks the database to:
- search for and match a ClaimantID... -
For those interested. Here is the final code used...
Private Sub Form_Current()
If Me.NewRecord Then
Me!ClaimantID = DMax("[ClaimantID]", "Claimantmaster ") + 1
End If
End Sub
U guys rock!...Leave a comment:
-
Thank yopu so much.
For those interested here is final code used...
[CODE=vb] Private Sub SubjLastName_Lo stFocus()
If DCount("[SubjLastName]", "Claimantmaster ", "[SubjLastName]= '" & Me![SubjLastName] & "'") > 0 Then
MsgBox "Name Is Already In Database!"
End If
End Sub[/CODE]
Thnx again!
deej...Leave a comment:
-
That is one of the coolest things I have ever seen...erm...I need to get out more.
Thnx dude...Leave a comment:
-
Yes,
It is simple when you know where to look. The problem was fixed by going to: Control Panel > Regional and Language Options > (tab) Regional Options - select your region correctly then > (button) Customise > (tab) Date - change options to suit your needs.
An input mask of 99/99/99 was also used where '9' indicates a number from zero to 10 is required.
Thnx to all for helping....Leave a comment:
-
Mmmmm. I like the sound of the calendar control. How do I create such a blessed thing?
deej...Leave a comment:
-
You are deserving of your expert status. Your input was informative, valued and helpful. Do any of you guys live near Melbourne because I might have some Access database work for you....Leave a comment:
-
Thnx so much for ur help. It is so satisfying when it finally works....Leave a comment:
-
Date Format
Hi all,
How do you make the date format comply with dd/mm/yy?
When I test dates entered it changes 13/07/1968 to 07/13/1968 (to place month first) but if you type 02/03/1968 where 03 is the month it assumes 02 is the month and does not switch them causing errors.
Also I want the year to be 2 digits (07 representing 2007) but sometimes if I enter a date as 13/02/07 it assumes the year to be 2013 returning... -
Thnx for your suggestion. The field in question is set to number at the moment so I am not sure if this will work. I want to change ClaimantID from number to autonumber without losing the data already in there.
I tried following the instructions and created a module but nothing happened and the option to run the module was greyed out. I am not sure what to do....Leave a comment:
-
Yes [ClaimantMaster].[ClaimantID](1) is linked to [Jobs].[ClaimantID](many)
[ClaimantID] data type is Long Integer
Data was previously entered manually.
The last 12 values of [ClaimantID] in the ClaimantMaster table are sequential from 1850 to 1862. The problem is this field is set to Number data type and not all entries are in sequence because the numerical sequence was not strictly followed. For example...Leave a comment:
-
Thnx for your help Nic. I think this is just what I need. But the code returns a syntax error. I have deleted the spaces in the names to "ClaimantMaster " and "ClaimantID ". Do I need an = sign before the code? Do I type Me as it is in your code or do I substitute me for something else? I was trying to enter the code in the default value (design view) of ClaimantID in the table. Should I enter it here or in the form?
...Leave a comment:
-
Autonumber for a field with existing records
U guys/gals are awesome!
I have a "Claimant Master" table with a primary key called "Claimant ID" set to number data type. It has existing records linked to an enormous "Jobs" table. There are thousands of existing entries and some Claimants have several entries.
I want to leave the existing entries untouched and get the database to fill in the Claimant ID automatically from now on. Can... -
Want Access to notify me if a record already exists
Hi,
I want Access to return an error message that says an identical entry already exists. I do not want to set the field to 'no duplicates' because it is a name field and it is possible to have different entries with the same name.
It is for a Claimant Master table in Access 2007. Each claimant could appear in the Jobs table many times but should only have one record relating to them in the Claimant Master table. When...
No activity results to display
Leave a comment: