Search results for query: *

I was requested to build a form for the assingment of monthly work shifts. Both the workers and shifts are flexible per month. I need the form column header to be the worker, the row header to be the shifts and the values in the "table" to be a text filled by the user. I built a table that is...

Im familiar with VBA in ACCESS. I would like to write a code for POWERPOINT presentation event on_open and on_close. I managed to open the VBA window in powerpoint but I dont know how to reference this code to the events. Thanks

I have several continues forms and one general toolbar for all these forms that contain ms filter , a-z sorting ... each one of the forms have a print button that opens a report. how can i open the report with the same sorting that the user chose on the form ? the filter works fine with the...

Thanks mate, That was my question , how to handle unbound checkbox, because I want to change only the front application.

Hello, On a continuous Form, I put an unbound checkbox, and in the form footer I have a buttom that should print all the ticked records. How can I tick an individualy box, with out having them all ticked ? thanks

any sugestions how to summerise short time ?

thanks for the fast reply PHV I tried to put the sql statement in a query but was not accepted by the jet syntax error MichaelRed what if it is unknown amount af values ?

I have a table with a short time fild that indicate how many hh and nn some thing was on what will be the sql to add a long list of this values ? like: 01:50 10:20 02:30 ----- 14:40 thaks

I had to use( where T.ID=I.ID) only one id needed thenks again

thenks alot worked perfect

Hello friends, I have a table with fields: clientID, enterDate ... What will be my sql first find a clientID's record then the latest date from those records thenk

How do I create a keyboard hook that would reject the prnt scrn key??? thenks

I have a powerpoint presentation,wich I would like to lock, Is there an option to prevent the print screen key to oparate ??

Hello all While trying to create new access database (using accessXP) this error appear "error in loading DLL" ???

Thenks Frink, In this case the main form is just for background and nice title the 2 subforms are individual with no logic connction There are some options for the user to choose from and by this I would like to open the subforms record (make any sence ?)

Hi, I have unbound main form with 2 bound sub forms. On the load of the main form I want to specificy the subforms record by the open args of the main form (I saw similar threads, I manage to get to the subform but it seems to be close for nevigation between the records) thenks

Where do I put the 1+DMax("[record ID field]", "[table name]") in the Append Query I can't manage to do it

try this: DoCmd.Hourglass True DBEngine.CompactDatabase myPath & "\" & datName & ".mdb", myPath & "\" & tempDatName & ".mdb", , , ";PWD =" & DBPassword Kill myPath & "\" & datName & ".mdb" Name (myPath & "\" & tempDatName & ".mdb") As (myPath & "\" & datName &...

thenks for the help I tried to make it with an append query,with no success, probebly VBA is the way

I have a table with a field which is primery key (no duplicate), data type = number. I use this field as the records ID , insted of AutoNumber. My question is : Can I run Append Query to add one record ? how do increase the number of this field by one ?