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!

Register Log in
  • Congratulations derfloh 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: *

  1. PMrider

    Calendar Control should be easy!!!!!!!

    DaveMac, I have a working calendar that you can use as doubleclick, Afterupdate or on got focus. It works just like you want it to. email me if you want it akolln@megalink.net
  2. PMrider

    Creating a mult-search tool/form

    Hi Steve, Can you please send me the copy of this MDB file too. Thank you Alan akolln@srt.com
  3. PMrider

    Adding to a value after clicking a button

    Hi Gazer44, Sorry it took so long to answer your question. I've been busy. It looks like you are missing some code Private Sub ButtonA_Click() If Forms![form1]![Answer] = "A" Then Forms![form1]![TickA].Visible = True Forms![form2]![Score] = Forms![form2]![Score] + 4 ElseIf...
  4. PMrider

    Previous Previous Record

    Put this in your control source of your [FirstReminder] textbox =DMax(&quot;Date&quot;,&quot;DateTable&quot;,&quot;[Date] < [txtDate] AND[KeyFieldID] = [txtKeyfieldID] &quot;) On form rename [ID] textbox as [txtID], but leave the control source the same rename [Date] as [txtDate] but leave...
  5. PMrider

    LDB Files do not close when Access quits unexpectedly

    I've had this same problem. My fix to it all was to delete the lbd and then rename my database so it creates another ldb. It works if you don't do anymore designing, just using. the DB this happened to me on is still working fine without any problems. Alan
  6. PMrider

    How to put a message in record navigation bar at bottom of form

    I have a form with a subform and a subform in the first subform. I have 3 record navigation bars showing at the bottom of my form and I would like to put a message in each bar so user can determine which bar is for what. Does this make sense? Also if I disable the record navigation bars, is...
  7. PMrider

    Searching in a subform

    PUT THIS IN YOUR CODE BEHIND THE FORM Private Sub AddToWhere(FieldValue As Variant, FieldName As String, MyCriteria As String, ArgCount As Integer) ' Create criteria for WHERE clause. If FieldValue <> &quot;&quot; Then ' Add &quot;and&quot; if other criterion exists...
  8. PMrider

    Potentially speed up form operations dramatically

    What a great find. I have MANY databases I built that open slow, but not no more... THANKS!!!!
  9. PMrider

    Form Title Bar Change Basicsss

    Or if you don't want anything the title bar then put a space in the CAPTION
  10. PMrider

    Adding to a value after clicking a button

    On Form where Buttons are at Create 2 command buttons #1 Command button Forms![FormName]![Score]= Forms![FormName]![Score]+1 #2 Command button Forms![FormName]![Score]= Forms![FormName]![Score]-1
  11. PMrider

    Here is how to filter a subform and still have the record on main form

    In GENERAL code behind form put Private Sub AddToWhere(FieldValue As Variant, FieldName As String, MyCriteria As String, ArgCount As Integer) ' Create criteria for WHERE clause. If FieldValue <> &quot;&quot; Then ' Add &quot;and&quot; if other criterion exists. If...
  12. PMrider

    How to use Multiple select list box for reports

    Thanks 930Driver for your help. I got it to work and this is what I did I put this in the GENERAL part of the code behind the form Public Function ListBoxWhereClause(lst As ListBox, strBoundFieldName As String, _ Optional strDelimiter As String = &quot;&quot;) As String Dim...
  13. PMrider

    How to use Multiple select list box for reports

    I read the .ItemsSelected and tried to use the code above, but I'm not really sure where to put the code. Do I create a command button and put it there? Also how does the items selected on list get to the report without some kind of query for the report to pull the info from? I'm not real good...
  14. PMrider

    How to use Multiple select list box for reports

    I've looked at the ItemsSelected help in access and am not sure how to apply it to what i'm doing. Can anyone send me a model on how this works. akolln@srt.com Any help will be greatly appreciated Alan
  15. PMrider

    How to use Multiple select list box for reports

    I'm trying to print in a report only the records that I selected from a multiple select list box. I got it to work if the list box has the multiple select set to none. But its not working if its set to SIMPLE or EXTENDED Here is the query i'm wanting to use SELECT T_Name.NameID, T_Name.Name...
  16. PMrider

    Calculating #days between 2 records 1 field

    Sorry, email is akolln@srt.com
  17. PMrider

    Calculating #days between 2 records 1 field

    Rod.... I tried the code in an unbound text box in the Control Source on the subform and I also tried to put it in the Query SQL and they both got #Error. I feel like i'm sooooooo close to solving this but I think something might be wrong with my subform...here is my email.
  18. PMrider

    Calculating #days between 2 records 1 field

    This is an LP database that tracks deliveries to customers and it also figures out when the next delivery date will be. I got that part down though. The clients are on one table and the deliveries are on another with a one-to-many relationship. the form with the deliveries is a subform named...
  19. PMrider

    Calculating #days between 2 records 1 field

    ok, Here is my problem. I want to be able to calculate the number of days between deliveries on my subform. The fields are: InvoiceID, Winter/Summer, DateOfDelivery, GallonsDelivered, PriceperGallon, RateStatus, Driver, Remarks. The final result i'm trying to achieve is to...

Part and Inventory Search

Back
Top