Recent content by SDB

  1. S

    Convert Access web database template into a desktop database

    anyone got a 2007 version of this please. thanks
  2. S

    Microsoft Access is redundant technology and no longer supported by Microsoft

    sounds just like HMV..unless its excel it ain't worth looking at :)
  3. S

    Cute or unusal dog/cat names

    dogs called bonnie cause the boat at the time was call clyde, due our first baby in Jan and the current boats called pie, somehow she won't accept chips mash or steak as a kids name :)
  4. S

    DBPix help

    Hi All posted this thread yesterday http://www.access-programmers.co.uk/forums/showthread.php?t=145770 And have found that using DBPix will do 95% of what I want. But does anyone know how to put the Boolen Imagepaste () command onto a button. Or how to paste it direct without right clicking...
  5. S

    Paste image from clipboard

    Hi All, i'm capturing an electronic signature via a graphics tablet which copies it to the clipboard but i'm having trouble trying to paste it into a form. tried doing it through a macro 'Runcommand Paste' but drew a blank. Ideally would like to have a text box where the persons name is typed...
  6. S

    Nearly there just one line of code needed...

    Thanks namliam, Thats just what i needed. Again thanks for you help, been on this for four days on and off..
  7. S

    Nearly there just one line of code needed...

    Morning, We have a soratation machine that holds 120 sacks, when each sack is full its taken off the machine and placed into a york. once the york has nine sacks in it, it is then weighed and put to one side awaiting collection. The post office arrive and collect eight yorks and sign for them...
  8. S

    Nearly there just one line of code needed...

    the database is used to keep a track off all the royal mail sacks that are collected throughout the day by the post office. each time they collect x amount of yorks( nine sacks to a york) they have to sign to say they have collected x amount at x amount weight. at the end of the day the lot is...
  9. S

    Nearly there just one line of code needed...

    Hi All I have the following code and wish to change the Weights.Collected field to True from false in the new query (expr3: ) in the new query. Thanks Private Sub cmdBuildQuery_Click() On Error GoTo Err_BuildQry Dim strSQL As String Dim qdf As DAO.querydef strSQL = "SELECT TOP " strSQL =...
  10. S

    Porting to Mac

    not sure but can't you use filemaker and have it point at the data on the server :confused:. again not sure I was going to try to do this on one of my macs just never got round to it.
  11. S

    select first x amount of records

    here you go Private Sub Command2_Click() On Error GoTo Err_Command2_Click strSQL = "Select Top " & Weights & " *FROM Collecting Yorks Qry" (think its here) DoCmd.RunSQL strSQL Exit_Command2_Click: Exit Sub Err_Command2_Click: MsgBox Err.Description Resume...
  12. S

    select first x amount of records

    have tried this but with no joy getting an error message syntax error in FROM Clause. cheers
  13. S

    select first x amount of records

    Sorry Moniker, geting more confushed by the minute, is your code seperate from Raskews code? Will have another look in the morning Thanks
  14. S

    select first x amount of records

    sorry for being slow (Full of head cold) does this give the user the chance to put in what ever amount they want or is it hardcoded at that amount?? Thanks
  15. S

    select first x amount of records

    I've just found that post and I think it will do what I need..just trying to get my head around how it works. thanks Raskew
Top Bottom