Search results

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

    Issue with DateDiff

    I'm having some really weird returns that don't make any sense whatsoever and don't even add up correctly. I've had no luck reading through pages and pages of google searches looking for the solution. I have two text fields on my form.. txtTime1 and txtTime2. Both are set for Short Time...
  17. P

    Conditional Formatting Based on Number of Times Name Appears in Report

    Weird. It seems to work just fine that way. If I don't have the Abs() it returns a negative number, which I don't want. And thanks for your reply on the other thread. I'll push the button.
  18. P

    Conditional Formatting Based on Number of Times Name Appears in Report

    I kind of ran into this issue before. What I have is a yes no field and I wanted to count how many times yes appeared in the query and how many times no appeared in the query under the same field. I used the expression: =Sum(Abs([FieldName]="Yes")) And I put that in a text box on my report...
  19. P

    Help with creating averages field

    Hello! I'm creating a report based off a query. The report lists all of the fields specific to that query. I have one field that is technically a text field under the table design but displays yes/no/not applicable. On the report, it takes all reports with "Yes" listed and displays the result...
  20. P

    Working with times in VB.

    Hey all! I can't find much literature beyond the basics on this subject, or the literature is far more advanced and complicated than I need for this project. I've got a textbox that uses the =DateDiff function to determine the elapsed time between two other textboxes. Essentially what I'm...
Back
Top Bottom