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...
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
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
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
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
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 ?
My reports have ToolBar, when I open a report from a modal form it hides behind the form.
I tried to make the report popup, then it came to front but lost the tollBar.
How can I bring it to front without losing the ToolBar ?
hi,
I have a text box bound to a memo field,
and a bottum that opens a report bound to the same table
Is there an option, like in MS word, to let the user choose the font propertis: size, color, bold ... that will be on the report ???
hello ,
I am trying to print a word doc with a picure as a background
but its print it without the picure how can I print it like I see it in the screen ???
sela
I have a field in a form that the user can enter a date
I would like to pass this date to a criteria of a report
so I will see only these dates records
I have somthing similar that I use between[forms]![fName]![fieldName]and [forms]![fName]![fieldName]
when I'm trying to make a criteria of exact...
Hello
I have a report wich using the reportHeader,PageHeader
detail(contain subreport),page footer, reportfooter
I would like to make backround from jpg file to cover the whole page (behind all the segments )???
hello, I have a Continuous Form that has a string fild which the user put in pathes(locations) of files that he wants to open on click
what will be the code to open the file ?
I am working with a few users, each has his own FE mde linked to one BE .
how can I open a notice (form) in one user after another user entered some relevant data
thanks for any help
I have a continuous form with a toolbar for sorting and/or filtering the records, and a command button than open a report
i would like that the report will carry the same sorting and filter like the user choose in the form
i treid :
DoCmd.OpenReport "rName", acViewPreview, , Me.Filter...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.