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 Rhinorhino 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: chippyles
  • Order by date
  1. chippyles

    File Download and Second IE Window opening

    I am using IE because I am using a program called SiteKiosk which blocks people from the operating system. So startups in window do not work. I have to use IE which is the core of Site Kiosk. It would be the second window. And what do I do about disabling the filedownload warning?
  2. chippyles

    File Download and Second IE Window opening

    I have a computer that loads Internet Explorer anytime the computer reboots or powers up. the below code is also attached to the html so I can start up an application automatically. Two things happen that I do not like. A seperate IE window pops up and I get a pop up msg about file...
  3. chippyles

    date picker

    I would like to create a date picker for an unbound text field called Start and one for End. I would like to have the calendar for Start (Calendar1) and the calendar for End (calendar2) to be only visible when the cursor is in the text box. then I want the user to pick the date and the date...
  4. chippyles

    Data Criteria

    I would like to put a BETWEEN START DATE AND END DATE in the criteria of a query I have. The start and end will be from an unbound form, but the person does not have to enter the start or end date all the time. This code works only when there is data in the combo box. Between...
  5. chippyles

    Date Criteria

    I would like to put a BETWEEN START DATE AND END DATE in the criteria of a query I have. The start and end will be from an unbound form, but the person does not have to enter the start or end date all the time. Between (Like nz([forms].[fQA_Raw_Materials].[START],"*")) And (Like...
  6. chippyles

    Clearing Combo Box Results using VBA

    I have 6 combo boxes at the top of the form and people can come in and click from a list what they want to see. They click 'go' and the results are displayed at the bottom of the page. I would like to create a button that clears the combo results. What would be the VBA for clearing the 6...
  7. chippyles

    Creating a Global code

    The only problem is the Screen has to be active. The screen is 99% of the time closed. When I open it I get a debug error saying the screen needs to be active.
  8. chippyles

    Creating a Global code

    This is the code I used as a function I got an error stating. Compile Error: Invalid use of Me keyword What now?? Public Function FormProcess() DoCmd.SetWarnings False DoCmd.RunSQL " INSERT INTO LOG_REPORT ( [DATE], [USER], HOST ,TASK, DB )" & _ "SELECT now() AS [DATE], environ('username')...
  9. chippyles

    Creating a Global code

    I did what you asked and I am now getting an error. Compile Error: Expected variable or procedure, not module
  10. chippyles

    Creating a Global code

    I have an On Open event procedure in VBA that I would like to make it global to every form or report open. How can I go about doing this?
  11. chippyles

    Retrieving the name of the DB in VBA

    This SQL command in VBA computes the user name, host name, time stamp and the task as the Form or Report name. Answer this riddle... Form or Report is to Me.Name as Name of DB is to ??? I need to capture the name of the Db the person is using so I can differentiate the forms and...
  12. chippyles

    Retrieving Data from Criteria

    I have 6 combo boxes on a form that determine a query. Each of the fields in the query have a criteria (Like nz([forms].[tQA_Raw_Materials].[SID],"*"). I was advise to use this criteria because it would still return a value if the combo boxes were null. The only problem I am having now is...
  13. chippyles

    Refreshing MS Access Data

    forget it now. Everyone kept telling me to do Me.Requery I just put in DoCmd.Requery and it works now. Thanks!!
  14. chippyles

    Refreshing MS Access Data

    I just did the wizard and it seems to be refreshing the Form Header and not the Detail section. If I press Shift F9, it works. the button however does not. How can I create a command that similates the shift F9 or does the Me.Requery on the detail from the form header?
  15. chippyles

    Refreshing MS Access Data

    Me.Requery does not work.
  16. chippyles

    Refreshing MS Access Data

    neither of the codes you sent worked
  17. chippyles

    Refreshing MS Access Data

    have a button on a form that I want the user to be able to refresh the data, but I can not get it to work. This is the code I am using. When I click the button nothing happens. What is the code that I should be using? Me.RePaint or Me.Refresh do not work
  18. chippyles

    Refreshing MS Access Data

    Me.Refresh and Me.Repaint do not work
  19. chippyles

    Refreshing MS Access Data

    Repaint did not work either. I did try the Me![subform control name].Form.Requery, but the details section of the form is not a subform. It is called detail. I plugged detail in the [] section and I am getting an error. What do you suggest I do?
  20. chippyles

    Refreshing MS Access Data

    In the details of the form the data comes from test query (there are the two fields Vendor and Heat with your criteria of 'Like nz([forms].[fQA_Raw_Materials].[Vendor] and .[Heat]'. In the form header are two combo boxes with a refresh button (me.requery) on the side. I can select the data I...

Part and Inventory Search

Back
Top