Search results

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

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

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

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

Hello all, I am trying to use a magnetic card swipe reader to log staff coming in and out of the building but I am stumped on one thing,( which i know I have seen on these forums but can't find) how do I selct only certain data from the magnectic strip, eg dfsdfsXXXXdtgedwwsmmimshur 123456...

morning all, I have 59 employees working a seven day week rota over a four week period, so at the end of the fourth week there rota reverts back to the first week for another four weeks. my question is how to i put this into a table with out having 25000+ records eg employeeName rotadate...

Hi All, I need a query to tell me how many staff are on holiday on the same day..here what i have so far. A query with name, startholsdate,endholsdate, totaldays, etc, etc,, records showing; employee A books 01/01/06 to 14/01/06 and employee B books 10/01/06 to 24/01/06 C books 01/02/06 to...

Hi All I have a form for booking employee holidays and in that I have a subform that displays their current holiday entitlment, which work great until I enter in a new record on the main form to book some holidays and I'm ask for a Name from a parameter box?? which I press cancel or ok at which...

I have read more post than i care to think about but I can't stil get my head round the following problem. I have created a database (with this forums help) but I am stuck on the following query/form/vba etc.... Our staff holidays run from 01/05/05 until 30/04/06 and i have a query that...

Hi Guys and Girls, Does anyone know if it is possible to have a button assigned a value from a table/query record, (I need to use a touchscreen so can't use a combobox.) eg button one = record 1, button2 = record 2 etc when pressed the value of the record is passed to another field. thanks...

Hi Guys and Girls, While doing a rabbit DB for the missus I have hit a problem, if one of the does gives birth to 3 babies i wish to have the details entered onto a form (not a problem) but i would like to do this: if number of babies = 3 then fields to display to enter details is 3 on the...

Okay ket me start from the beginning, once upon a time... :) , I need to keep a track of all my staffs work progress throughout the day, they currently pack items into envelopes and count up how many they have done at the end of the day..I have started a database that will scan each package with...