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

  1. johncb

    Very Big file edition

    if you know where the character is to be placed you could use awk to read the file, write to a new file and add the character at the appropriate point - assuming that it is a text file and that you can uniquely identify the insertion point. John
  2. johncb

    A little help with this parameter expression!

    ...Simply change the criteria to [Forms]![frmCriteriaDivPM]![txtRegion] and you will only see data for that region. i.e. remove LIKE, the "*" and the ampersands (&). Using LIKE "*1*" means you want to get everything with a 1 in it such as 1, 10, 11 , 12 up to 19 then 21, 31...
  3. johncb

    Breaking autoboot sequence

    You can get back to the SRM by issuing: shutdown -h now This will shutdown the system in an orderly manner and halt at the SRM console. Regards, John
  4. johncb

    import access db into mysql

    Hi, This link should help: http://www.kitebird.com/articles/access-migrate.html John
  5. johncb

    scsi controller

    try: scu scan edt John
  6. johncb

    check for Null

    Try if isnull(strOld) then doSomething else doSomethingElse end if John
  7. johncb

    need to create incremental file number

    Create a table with two fields: NextNumber and SetDate. Each time you create a record you get the NextNumber, save it with the YY from format(date()"yy-") and rewrite NextNumber to its table after incrementing it by 1. In the OnLoad event of your main form put in some code to compare...
  8. johncb

    Form page lenth??

    In the report design drag the bottom of the detail section down so that it takes up all of the page. You may need to do a little testing to get exactly the right size. hth John
  9. johncb

    how do ypu make the coach biger

    steroids?
  10. johncb

    Need help to identify the patches installed

    You could also use dupatch to show what patches have been applied. John
  11. johncb

    Open a till draw

    First, the till drawer. Usually this will be done via a serial port. You would open the port, say COM1, and write a string to the port. You will need to know the communication parameters required by the till; data bits, stop bit, speed and parity if my memory is correct. Look at OPEN COMx in...
  12. johncb

    to dim or not to dim

    You could try: if not isnull(FieldName) then FieldName = int(FieldName*100) / 100 endif this only acts on a non-null fields. John
  13. johncb

    Search for # with most occurances

    This may help you to start: assume your # is 302 in a numeric variable named intNumber 'create an array DIM intNumbers(6) as integer txtNumber = str(intNumber) ' convert to a string intNumber(1) = txtNumber '302 intNumber(2) = left(txtNumber,1) & right(txtNumber,1) &...
  14. johncb

    Dialog Box for selecting Path/Filename!!!

    If you go to: http://www.mvps.org/access/api/api0001.htm you will find the code you need. It invokes the standard Windows file Open/Save dialog. Regards, John
  15. johncb

    Dlookup help Please

    Try this for your dlookup: varFreightCompany = DLookup("[FreightCompany]", "tblFreightCompany", "[FreightCompany] = '" & FreightCompany & "'") You will notice the pair of ' around the field name you are using to compare with [FreightCompany]. This...
  16. johncb

    Date validation happening before BeforeUpdate

    You could try putting the validation on the ON EXIT event for the date field. John
  17. johncb

    4.0D Installation and X Server

    You will need to have an SVGA monitor, kbd and mouse direct connected to the Alpha. Check that the SRM has SET CONSOLE GRAPHICS. good luck
  18. johncb

    Checking if a Date field is empty

    Try: If isnull(StartDate) then DO STUFF endif John
  19. johncb

    Validate text field

    You could put some code onto the ON EXIT event of your text field. You could then test the field for your required contents and display an error message using a message box if it is incorrect. John
  20. johncb

    System Backup

    try /sbin/vdump -C -u -f /tmp/MY-BACKUP -D /directory-you-want-to-backup John

Part and Inventory Search

Back
Top