Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: anujkmehrotra
  • Content: Threads
  • Order by date
  1. anujkmehrotra

    Add and Update records in subform

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

    Stop Duplicate Values for Different Ids

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

    Duplicate entry not working

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

    Combo Row Source List Problem

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

    Current date to bound date filed

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

    Auto Database Login

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

    VST Office 2003 Installation problem

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

Part and Inventory Search

Back
Top