Hi all,
I have a concern. I want to add and update both from a table to another table from a button:
I have two forms having subforms:FrmEstimate(tblEstimate & tblEstDetail) and FrmBill(tblBill & tblBillDetail= same as tblEstdetail)
FrmEstimate has JobID in main form and in subform...
Here is an example to stop user to enter or choose Duplicate Service value as per Different ChasisNo (Not UniqueID).
Code:
Private Sub Service_AfterUpdate()
Dim stLinkCriteria As String
stLinkCriteria = "Service = """ & Me.Service & """ And ChasisNo = """ & Me.ChasisNo & """"
If DCount("*"...
Hi All,
i have Duplicate problem in this way:
Two fields (ChasisNo & Service) Datatype are Text and ChasisNo is not and UniqueID because so many services will there for the same ChasisNo.
Now, what i need is that tblSerJobCard has ChasisNo (abc1234) and Service (First;Second;Third).
I want...
Hi,
I have to update a combo Row source list. My Structure is as below:
tblModelService:
ModelNo = Alba (PK)
Service = First;Second;Third
tblJobcard:
JobCard_No = PrimaryKey
ModelID = Alba
cboService = ?
ChasisNo = UniqueCode
Problem#1
Now I tried to update row...
I'm getting an error in the following line:
Me.LicLogDt = Date
I want to update LicLogDt(bound date field) to get current date of system on form load/open, but error says "Can't assign a value". It is working on Form Close but not on Open/Load. Please guide to do so.
----------
Code:
----------...
Hi,
I have BE (pwd secured), but i have to login it every time when i open it. i set a fixed database password "Password" in it, so i want it to open automatically when i open it directly not from FE, but when someone tries to import or Link BE, it should ask database password.
Can anyone...
Hi,
Can any tell me any way to install "VST for Office 2003" because I am getting an error msg while running setup from MS office 2003DE CD:
"Setup cannot detect required version of Visual Studio .Net on this computer. Before you install this product, you must install a matching regional...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.