Recent content by Pis7ftw

  1. P

    Type mismatch error on DMax function using dates

    Thank you sir!
  2. P

    Type mismatch error on DMax function using dates

    Been awhile since I've asked a question! (Must mean I'm getting OK at this whole VBA programming thing ;) ) Anyway I've got a type mismatch that I can't figure out. dMaxLstReq = DMax("reqNumb", "FlightLog", "Month([txtDate])='" & frmMonth & "'" And "Year([txtDate])='" & frmYear & "'") In...
  3. P

    Determining a new month, run procedure.

    Now that is something I didn't think about. My database utilizes a couple of vbScripts already. Shouldn't be a huge issue.
  4. P

    Determining a new month, run procedure.

    I want to run a procedure at the beginning of each month. Automatically.
  5. P

    Determining a new month, run procedure.

    I've been stumped for the past couple of days trying to discern a method for a form to determine that it's a new month and run a procedure and only run it on month change. My initial thought is: Open recordset move to the last record compare the month in a date field within the last record to...
  6. P

    A solution to a specific front-end updating scenario.

    I call it...beating your database into submission with a digital stick.
  7. P

    A solution to a specific front-end updating scenario.

    Another issue that someone might run into, like me, is when you've created an Access 2010 database, but the work computer only has 2003, and the back-end is on a network drive. The solution is to install Access Runtime, create an EXACT match of the paths to a fake backend, and have the...
  8. P

    A solution to a specific front-end updating scenario.

    Ran out of space. Here is the code for the .hta files. Use a text editor and save as blabla.hta or something. The .hta code: <html> <HTA:APPLICATION Caption = "no" > <script language = "VBScript"> Sub Window_OnLoad...
  9. P

    A solution to a specific front-end updating scenario.

    While the explanation is probably more complicated than the code itself is, I'll try to be brief. I've pulled a lot of information from the net to put all this together into a solution that works for my scenario, but I think it can be modified to fit other weird scenarios. I have an Access...
  10. P

    Populate TextBox with Listbox Selections

    holy frog balls. Not a expert on VBA but I think I might know enough to modify this in a few days :)
  11. P

    Populate TextBox with Listbox Selections

    Have a form with a listbox and a textbox. Listbox is multiselect with multiple items. Would like to have the selections from the listbox displayed in the textbox. The code would be under the AfterUpdate event of the listbox. I would also like a separator (comma) in between selections. Searched...
  12. P

    Issue with DateDiff

    Understood and this is a strange circumstance where I would like to. Essentially the Form tracks the times during a flight mission. Dispatched: xx:xx On Scene: xx:Xx Leave scene: xx:xx At destination: xx:xx Available: xx:xx with a bunch of other times in chronological order between those...
  13. P

    Issue with DateDiff

    That's what I was looking for. Thanks for the info. Now it displays in hh:mm format which is great. But it saves in the table as hh:mm:ss AM/PM. I would like it to save in the table as hh:mm in 24 hour format.
  14. P

    Issue with DateDiff

    Bump........
  15. P

    Issue with DateDiff

    Yeah..I tried something else just now. DateDiff between 00:23 and 01:45...it gave me 12/30/1899. :banghead:
See more
Back
Top Bottom