Search results

anyone got a 2007 version of this please. thanks

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

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 :)

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...

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...

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

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...

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...

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 =...

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.

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...

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

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

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

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

Added an image so people understand what I'm trying to do. I just want to select the first X amount of records. any one got any ideas its driving me mad... Cheers

Hello All if I have thirty records and have the end user select the first 8 or what ever amount they want, could be 3, 14, 9 etc, is this possible via a form ? thanks

That worked. Thank you very much. :)

yep, trying to work it out all day :confused: How do you set MyTime and what is it, a global variable? mytime is an unbound field which is set to look at the time constantly so that the postdate field is correct according to time/date

Hi All I have a form that needs to have the date automatically entered depending on time, I have it set on form load and new record, so far I have this but if I change the time to test it doesn't work?? Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec If Mytime <= 1500 Then Me!PostDate =...