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 TouchToneTommy 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: Saxie1
  • Content: Threads
  • Order by date
  1. Saxie1

    syntax for "on the fly" date/time query

    I am using the following query to select qualifying records: SELECT tblOrder.OrderNum, tblOrder.CloseTime, tblOrder.BusinessDate FROM tblOrder WHERE (((tblOrder.CloseTime) Between #2/11/04 4:01:00 am# And #2/12/04 4:00:00 am#)); Since my users are not very adept at writing queries, I want them...
  2. Saxie1

    Copy a date from one column to another with a macro

    I am working with an Access97 database that I did not write, but need to edit large amounts of data in. The two columns of interest are adjacent to each other. The first column contains a valid date but the second does not. Column 1 Column 2 6/16/2003 12:16:12 AM...
  3. Saxie1

    Excel 2000 - can't find form control code

    I have inherited someone elses spreadsheet. It has a bunch of comboboxes embedded in it, but right clicking on the combobox doesn't do anything. Even in VBA edit mode I still can't get to the code. I'm pretty sure they are form controls and not active-X. I can insert a new combobox, right...
  4. Saxie1

    >Multi-colomn combo box

    I've looked through all the help files but can't find anything on this. In Access97 I want to have a combo box with two columns, one with abbreviated month, the other spelled out. What is the syntax to reference the second (unbound) column, so that I can click "Jan" and put it in a...
  5. Saxie1

    Problems with activexctl calendar

    Has anyone else had a problem with the calendar working great for a few weeks, then suddenly just quit working? I haven't figured out what is causing the calendar to transfer dates correctly to a table one day, then not transfer any dates to the table at all. If anyone knows how to correct this...
  6. Saxie1

    PrintOut...print only the the current page of a report

    From the print preview screen, I have my report set up to print OnClose. What syntax do I use to print only the record currently displayed, not the whole report?<br> In MsWord I know I can use<br> <br> PrintOut Range:=wdPrintCurrentPage<br> <br> to do what I want, is there a similar command...
  7. Saxie1

    setting textbox default value at run time

    I am using an option control to set the value of a text box in a form. When I add the record to the database the value transfers to the data base but the text box goes blank for the next record. How do I get the textbox value to stay the same in the next record unless the user changes it? This...

Part and Inventory Search

Back
Top