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!

Recent content by sacsadmin

  1. sacsadmin

    Query By Week Properties

    Is there a way to set the start week in a query that is filtered by week? Example: Our fiscal year starts on February 01, not on January 01. So I need week 1 to be started on February 01. Also, is there a way to control the formatting. On my report is shows the week output as a number of...
  2. sacsadmin

    Call Calendar Control From SubForm?

    sacsadmin@sacsdistributors.com
  3. sacsadmin

    Call Calendar Control From SubForm?

    Trendsetter, I have done as you suggested. I created a seperate form just with the Calendar on it named FrmCalendar. In the double click field of the Date text box I created an event procedure of DoCmd.OpenForm "FrmCalendar". How do I get the actual parameters passed back to the...
  4. sacsadmin

    Call Calendar Control From SubForm?

    Using Microsoft Access 2000 I have the following: Database: Trailer Inventory Table: Tbl_TrailerNo Field: TID (AutoNumber, PrimaryKey) Field: TrailerNo (Number) Table: Tbl_DateDetails Field: DID (AutoNumber, PrimaryKey) Field: TrailerNo (Number, ForeinKey) Field: TDD (Date)...
  5. sacsadmin

    How do you delete ODBC database name?

    NOS: MS Windows NT 4.0 Service Pack 6.0 Steps: Control Panel > ODBC Data Source Administrator ODBC DSA > System DSN Tab > Add Create New Data Source > Select Pervasive ODBC Engine Data Source = Demo1 Description = Demo1 Database Name = ( ) This is where the list is showing all the past names...
  6. sacsadmin

    How do you delete ODBC database name?

    RHill7, Thanks for the reply. However, I think my question has been mis-understood. I know that you can delete DSN records as stated in youre reply, but... When creating a new DSN Engine Setup from the ODBC administrator, In the ODBC Engine DSN Setup screen there is a section called...
  7. sacsadmin

    How do you delete ODBC database name?

    When creating a new ODBC Engine DSN, I get the error: "The database name must be unique. The specified name already exists. Please specify another database name." The drop down list is getting rather long and I would like to recycle some of the names. Does this make sense?
  8. sacsadmin

    Recommend Software?

    What is the forums best recommendation for development software. I need to develop an inventory tracking put away retrieval system, but want to utilize either Palm OS wireless or Pocket PC.
  9. sacsadmin

    Counterpoint POS

    If we are talking about issues with counterpoint that provide good information to the forum I would stick to the forum. If we just want to general chat about CP I would rather do that thru email direct. Are you using dial-up (phone) or going over the internet for your remote sites?
  10. sacsadmin

    submit button to control new browser window?

    I have a form with a submit button. When the user clicks the button it calls page.asp, which opens in a blank window. This all works fine, but I want to be able to control the browser size depending on the amount of data returned from the asp query. for example, I do not want a toolbar, but...
  11. sacsadmin

    Counterpoint POS

    How was the user conference? feel free to contact me about CounterPoint if you want. sacsadmin@sacsdistributors.com
  12. sacsadmin

    Message display when query returns no records

    onpnt: You are outstanding! I was getting close, maybe in a few days I would have been able to get it right after I finished the box of oval-teen and sent off for the secret decoder ring. Thanks.
  13. sacsadmin

    Message display when query returns no records

    I am trying to follow the logic of this. My understanding of an IF statements...If this is true do a, if this is false do b. So if I am already running a loop until EOF, where to I located the If statement. If I do as follows it won't display. My thought behind this is you do the loop if...
  14. sacsadmin

    Message display when query returns no records

    Currently I have the code listed below. When the query runs the ASP code produces the correct output if there is a record match, if there is not, it just generates a blank screeen. How do you get a screen to display "no records found in search" instead of the empty screen. Is this...
  15. sacsadmin

    convert date (string) to actual date

    synapsevampire: This worked out great! Thanks for the Info.
See more

Part and Inventory Search

Back
Top