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 gkittelson 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: yakdogs
  • Order by date
  1. yakdogs

    VBA Msg Box to Text Box on Report

    I have a report that has a parameter written in VBA. The powers that be would like this parameter listed on the report. This is part of the code. strBegDate = InputBox("Beginning Date") strEndDate = InputBox("Ending Date") I would normally build it in a query but...
  2. yakdogs

    Main form and Subform

    I have a main form that has a field called received date, and I need to copy the information to a subform received date as soon as a field has gotten focus. I can not use parent and child links as the user needs to connect the information in the main form to the records that display in the...
  3. yakdogs

    Convert Date

    I am rather new to SQL and could use a little help. This is my problem. I have a report that needs to pull up when it reaches the current date. Meaning that the user enters a date and then in 60 days it pops up in their follow up items when it equals the current date. This is the SQL stmt...
  4. yakdogs

    ?Current Date to pull information

    Is this what you are looking for? I am missing something but cannot figure it out. Private Sub Form_Load() txtDate.Value = Now() End Sub
  5. yakdogs

    ?Current Date to pull information

    I have a form with a date field that I am trying to set up so that it only pulls in the current date information OnLoad. Can someone give me a sample? Thanks
  6. yakdogs

    Days in a SubReport

    Thank you so much. It was a great deal of help, and it is working just fine.
  7. yakdogs

    Days in a SubReport

    Hello; I have been working on a database that the employees sign in to and which will generate a timesheet. My problem is getting all 14 days on one sheet. Each day has multiple punchs. Management wants to see all punches. I figured in order to get all days on the sheet that I was going to...
  8. yakdogs

    Store Procedure within Access Project

    I use this code with a view and it works but when I change it to a stored procedure it does not work. I assume that a stored procedure has be handled different. Can anyone help me. Const stmt = "Select * from vwDeferred_rpt where Client_ID like '[Client_ID]' " Dim varClient As...
  9. yakdogs

    SQL Sum's

    Thank you so much. I knew it had to do with ISNULL but did not know how to write it. Have a great day!
  10. yakdogs

    SQL Sum's

    I am really new to SQL. I have two colums that I am doing a summary on then adding the two sums together to come up with a balance. Problem, if one sum is blank it does not add across to the balance. How do I do this? I have listed below an sample I have been playing with...
  11. yakdogs

    Button colour on form

    I had a form that needed a few command buttons but did not like to looks of all of those buttons. So what I did was to use a label, and then put an event procedure on the on_click. This way I can format the label the way I wanted, and it still functioned as a command button. Thought that...
  12. yakdogs

    Key Codes

    Thank you very much, it answered my question.
  13. yakdogs

    Key Codes

    Maybe someone can help? I have been trying to find a list of keycodes, and have not been able to do so. I want to disable some items, but need the keycodes to do so. I know that page up and down, is 33 and 34. Can someone point me to the right direction. Thanks
  14. yakdogs

    Seconds to Minutes and Hours

    Would this go into the control source of the field?
  15. yakdogs

    Seconds to Minutes and Hours

    Hello; I have a field in a report that is coming across as seconds how can I show this as so many hours and then minutes. I have never done this before. Can anyone help me?
  16. yakdogs

    Minute Calculation

    I have a csv file that I am importing and it has a field that I must calculate the amount of minutes, and seconds on. The field in the csv file is set up as 00:00:00. I am importing the field as: .Fields("Call_Duration") = IIf(Len(Tokens(1)) = 0, "00:00:00", Tokens(1))...
  17. yakdogs

    Date Picker Calendar Control

    I dont know if anyone can help, but thought I would give it a try. I have a form that I use the Microsoft Date and Time Picker Active X control. When I set the control source where the date needs to be held I get this error: Cant set null value when checkbox property = false. Everything I am...
  18. yakdogs

    Combo box with Text Box

    I am not sure how to start this so maybe someone can give me some help. This is what I would like to do. I have a combo box that when a specific item is picked that a text box pops up, and the user then needs to input the item name. Otherwise the text box is invisible. Can any one help...
  19. yakdogs

    Calendar Control

    I have a Active X calendar control which when a date is pick saves to a field in the table. My question is, the calendar is visible all the time, how can make it visible only when needed for that field?
  20. yakdogs

    Force a Number Input

    I have an access project front end.

Part and Inventory Search

Back
Top