Search results for query: *

Thanks a lot MazeWorX.

Thanks for your kind response but it is still not working on any event at all. Same error is coming. Thanks & Regards, Anuj

Not working dear. it returns an code error on Form open: "Method or data member not found" and focus goes to Me.cboService.RecordSource = strSQL Please guide. Thanks & Regards, Anuj

Thanks MazeWorX, I'm new in VBA, but I could not understand tblServiceStatus process. I don't have such table and you did not mention to create it. So, I tried alternate: http://www.tek-tips.com/viewthread.cfm?qid=1678183 But, this is not the solution what i'm looking for. If you help me to...

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("*"...

I got it: Private Sub Service_AfterUpdate() Dim stLinkCriteria As String stLinkCriteria = "Service = """ & Me.Service & """ And ChasisNo = """ & Me.ChasisNo & """" If DCount("*", "tblSerJobCard", stLinkCriteria) > 0 Then MsgBox ("You have already done this service to the customer.")...

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 all, Thanks for your replies, but i share my problem once again: I have two tables: table#1= tblModelService Fld#1= ModelNo = Alba (SampleData) Fld#1= Service = First;Second;Third (SampleData) table#2= tblJobcard Fld#1= JobCard_No = 1 (SampleData) Fld#2= ModelID = Alba...

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...

Thanks MazeWorX, it worked well and I will keep your logic and suggestion in my mind. Thanks & Regards, Anuj

Thanks for your reply, but i'm little weak in VBA. can you reply exactly what should i do? because I tried your suggestion, it didn't work at all. Thanks & Regards, Anuj

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: ----------...

Thanks dear. Thanks & Regards, Anuj

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...

Actually, I'm unable to find the matching product for support of VST 2003. Thanks & Regards, Anuj

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...