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

    Access pass-through query can't recognize form date...pls help

    I've searched throughout this site and googled also and have not found any posts that resolves my issue. I have this sql in a pass-through query in Access 2010...I need the sql to use the date the user enters in the Access form...I get this error however: ODBC--call failed. [Teradata][ODBC...
  2. ScorpioMCN

    Need code to move data to new worksheets

    I've searched the forums and elsewhere but can't locate an answer to my specific issue. Here's what I'm trying to do in Excel...I'm fairly new at VB code though :( I have one tab full of journal line data on roughly 20 different g/l accounts (more to be added later) starting in row 8, column...
  3. ScorpioMCN

    How do I add a calendar drop-down control to a text box ?

    I have a form in Access 2000 with a date field - I want the user to be able to click a down arrow and bring up a calendar to easily select a date if they would rather not type it in. I've searched a lot of posts on calendar control but nothing seems to fit my issue and I'm not a code wizard so...
  4. ScorpioMCN

    Date() does not work in my text box

    I have a form in Access 2000 and I'm using the formula Date() as the default value but I get this error in the date field when I add a new record #Name? Now() works but I do NOT want the time - only the date. How can I fix this? Would appreciate any help.
  5. ScorpioMCN

    Need to join two fields together from same form

    I apologize in advance if this has been asked before but I could not find a similar post in a search. Here's my issue: I have Access 2000 and a Contacts database and a Form where the user enters new contacts*. I have one field for the firstname and another for the lastname. I have a third...
  6. ScorpioMCN

    Need to suppress a portion of total unsuppressed groups

    This might sound easy however I'm using a bunch of criteria (incl. a shared subreport value) to determine which items (based on their ABC code and last date counted) get picked for cycle counts in the current week. The report totally works great however being that there are 20 weeks left in the...

Part and Inventory Search

Back
Top