It's Same,,
Thanx Jack,
It's Same If Access AutoNumber Or My Own Autonumber, the problem once the user is opening the form and get the RecieptID, The New Record Will Not Be Saved In Momently.
I Have Table Wich Has Around 45000 Record's, I Have Form And Subform Wich Linked By [Reciept ID], What Is Going Is:
* The [Reciept ID] Is AutoIncremening By Dmax(......).
* When Both Of User Opening Form The Problem Is Starting..
- Both Of Them Will Have The Same [Reciept ID],,,,,:(((...
Dear L4serK!LL,
It's realy better to send me ur db by zip file and i'll do it for u,,,
because i have no controld + form and subforms name.
Sorry,
Ready To Help At Any Time....
Saam
As long as u did not clear ur request well, i guess as i under stand to have a combo box for the user to select the article which he/she need at that time other fields will be filled Automatecly.
For Example:
Private Sub ArticleComboBox_AfterUpdate()
Me![Ur Field Name From The Table] = Me!Ur...
ID Field
Hi OMA
U have to have a releationship between Form And SubForm A Such TBID, so ones u select the form 1 the subform will display and filtering only the field which = the field in the main form.
Hope That Helps
Haitham
Hope That Helps
Dear Friend,
Private Sub cmdAddCustomer_Click()
Me.sfCustomer.Form.Recordset.AddNew
[sfCustomer].Form![Customer].SetFocus
End Sub
Hope That Helpful
Haitham
Dear Friend's
I'm using SelLength with TextBox, How Can I Select Multi Word In One TextBox ,,,,,,,,,,,,,,,, Ie.
The Boy Said And The Boy Wen And The Boy Came,,,.
How Can I HighLight All The "Boy" In That.
Thanx In Advance
Sam
Dear Friend's
I have a form with memo String displaying a kid's stories....:)))
I create a command button to let the kid's search for spesefied word, is there any way to HighLight the resault in even thogh it's repeated some where else in that memo string?
Thanks in Advance
Sam.
I Just Modefy And Working Like Charmy,
Thank You,
Public Function NumInstances() As Long
Dim arData As Variant
stSplit = InputBox("Enter the Search String")
Set rs = CurrentDb.OpenRecordset("Select * from [Sheet2]")
If rs.RecordCount > 0 Then
rs.MoveFirst...
Dear There,
I have a table with memo field wich contain hug duplicate text,
i need code to search the word that i specify in inputbox in each and every that memo field and goto next record and count it also.
Thanx in Advance
Yes Sam,
There Is Way To Do That, You Have To Do That On Timer Of Any Opening Form, And Run A SQL To Look At You Table For The Need Condithion, If Yes Then Do Let Say Beep Open A Form ...... Etc.
If That Is Far For You, Please Feel Free To Clear More For Me Or Send ME Your DB Ore The Way You...
Dear There, Access XP
In Macro I have created a full new Menubar, but what is the way to Create a SubMenu at any MenuItem, also Let That Work By KeyBoard Key's.
For Exp.
Under Record -------- New -------- Delete -------- Modefy and if i click on New i Want also Menu To show Record -------...
Brows Folder
It's I Guess Easy,
Dim BrowsFolder
BrowsFolder = Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE " & "C:\Any Folder", vbNormalFocus)
End Sub
Don't 4get The Space After (Iexplore.exe).
Good Luck