Search results

  1. arnelgp

    VBA and ChatGPT

    watch out.. DanielP, is watching..
  2. arnelgp

    VBA and ChatGPT

    people might construe, that he did all the effort. even if you write a book, and you quote it from another book, you put the reference on the footnote. or you copy someones code, you put attributions.
  3. arnelgp

    Moving objects on form

    expanded the table and CF for some colors.
  4. arnelgp

    VBA and ChatGPT

    don't you think you need to give acknowledgement/credit to ChatGPT on your presentation after all he does the heavy lifting?
  5. arnelgp

    Moving objects on form

    just another option. this does not move the label but has fixed label and only change the color or hide the label. open form frmMapStatus.
  6. arnelgp

    Field to enter ONLY time.

    the format is: hh:nn:ss you can create a form (datasheet or anything) against that table and set the format of the Textbox on design view of your form.
  7. arnelgp

    Field to enter ONLY time.

    the field is Date/Time (so it is Date + Time). you can suppress the Date portion by Editing the table structure and adding hh:nn in the Format Property of the Date/Time field. but this is Only for display, the Date portion is still there.
  8. arnelgp

    Field to enter ONLY time.

    isn't it Dec-30-1899? since this CDate(0). and Format(CDate(0),"mm/dd/yyyy") = 12/30/1899 this is what CoPilot explains: In Microsoft Access, 01/01/1900 is often seen as a default or placeholder date—but it’s not the true "zero date" in Access. That honor actually goes to December 30, 1899...
  9. arnelgp

    Moving objects on form

    add an "anchoring point" in your map. you can add 50 invisible label controls on each States on your map. name them same as the State Abbrev they are in, eg: "lblWA". then you can just "move" your labels/checkbox to the "anchoring point" if checkbox WA (chkWA) is checked and want to move it...
  10. arnelgp

    Print Report based on lstbox rowsource

    how does the listbox get pupolated by the combo, show us the code.
  11. arnelgp

    Moving objects on form

    with those numbers, sad to say, it will soon, and you need to backup often.
  12. arnelgp

    Top of screen occupied

    the usual disclaimer applies that it is at your own risk..
  13. arnelgp

    good for you vhung, if you have level up your programming skills! good luck with your endeavors.

    good for you vhung, if you have level up your programming skills! good luck with your endeavors.
  14. arnelgp

    Solved DCount Date field for duplicates giving Error#

    i was guessing to do the DCount() on table tblShiftsMachinesRan? and add the EmployeeID on the Criteria: DupDateCount: DCount("1","tblShiftsMachinesRan","ShiftDate= #" & Format(tblShiftsMachinesRan.[ShiftDate],"mm/dd/yyyy") & "# And EmployeeID = " & tblShiftsMachinesRan.EmployeeID)
  15. arnelgp

    Queries stopped working, & the tool bars disappeared in MsAccess 2003

    as i remember, Nicole is the one who is trying to work on your db, you should ask her.
  16. arnelgp

    Solved Form Filter in VBA

    how did you saved the filter?
  17. arnelgp

    Help make commands to adjust texts in forms and reports

    it is. since it only add Space on each character and not really justify the text.
  18. arnelgp

    Report in unbound Form needs dynamic Recordsource and Filter

    that means to Re-open the report. you can remove the: subform.sourceobject="" to minimize the flicker.
  19. arnelgp

    Report in unbound Form needs dynamic Recordsource and Filter

    I tried it but it does not Refresh the report with the new "filter"
  20. arnelgp

    Report in unbound Form needs dynamic Recordsource and Filter

    I maybe wrong, but, you can't change Recordsource/Recordset of a Report once it is already Loaded. your best option is to use subform for your report and just mimic the design.
Back
Top Bottom