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: *

  • Users: symze
  • Order by date
  1. symze

    MS query - Date Problem

    Skip, I have used the following code and am getting some success. I can get the return value from my input box OK, however in my query code I get a run time error saying OBJECT REQUIRED. This is my Input box and return function: Public Function IptBox() Dim InputBox As String InputBox =...
  2. symze

    MS query - Date Problem

    Skip, My apologies I just took the Change() bit after the textbox 1 name as part of it. OK I am now getting Compile error: Variable not defined and it is highlighting Textbox1 Cheers P.S. my head is now ready to explode.
  3. symze

    MS query - Date Problem

    Hi Skip, Thanks for your help so far on this. I have simplified my query and changed it to reflect your changes, however when I run my Macro I get an error: Compile error Expected function or variable. In Debug it highlights the Textbox1_Change part of the code. Am I to assume then, that I...
  4. symze

    MS query - Date Problem

    hi thanks for your reply, However, I am still a bit confused I tried the above and must be doing something wrong, here is the code for the query, it is the date parameters that I would like to be able to be changed as per my input box: ActiveSheet.QueryTables.Add(Connection:= _...
  5. symze

    MS query - Date Problem

    Hi, I am a complete beginner with VBA so any help would be appreciated. I have setup a query using MS Query to pull some periodic call data from an ACD database. In the query I have specified a date and time from which to collect the records. As this has been recorded as macro the date...

Part and Inventory Search

Back
Top