Search results

hi all, can you help please , I want to restrict the users to only be able to access certain tabs in the ribbon . example "user1" cannot access the external tab and the create tab, but can access all others , can you help please?:confused:

I have put this in the status control source properties and it works , but it does not change the values in the subform table to the same as the sub form, ( record 1234 status in the subform is now showing "active" , but in the subform table record 1234 still shows expired) do you know how to...

Galaxiom, I have tried putting this in the subform on update properties but still no joy when the subform updates with new records nothing changes , am I missing something here ?

Galaxiom does the "current" mean that if the condition is not met then the status value will stay the same as before?

burina you misunderstand me I think, I can look at the date in the six month update field by using <=date() , this tells me if the date is past todays date , I need to know is how to set the status field to "expired" if this condition is met , and set this up so every time the subform is updated...

hi all can you help please, I have a subform that contains several fields , in particular are two fields [six month update] ( date field) and [status] (text field), my problem that I cannot solve is this when the subform is updated then I want the status value to change according to the date of...

madefemere, is it possible to assign this so when ever the subform is updated/ refreshed that this automatically runs? if so how? please

madefemere thanks works great how would I use this as an expression to put it on the textbox 3 as conditional formatting please?

hi all, can you help please, I have three textboxes , textbox 1,textbox 2, and textbox 3, I can change the value of textbox 3 based on the date of textbox 2 by using if me. textbox2 < date then me. textbox 3 ="expired" end if but I need it to look at textbox 1 as well and only change...

thanks , works great

hi all, been coming here for help now for a long time , and I have built a database that I have taken it as far as I can, but I know it can be improved on big time , does any one here look at peoples projects to help them out and suggestions on how to build it better and improve it ? if you...

hi , can you help please, I have a subform that has two fields one called 24 months(date field) and one called status(text field), what I am trying to do is after the suborm has been filtered if the date field and is <=date then it will place "expired" into the status text field . any ideas...

hi all can you help please , I have a subform that if it has lots of records in it and I scroll down then I cannot see the column headers, how do I get it to always show them?:confused:

hello all, can you help please, I have a combo box "updated by" this has a list of all employees that use the database, they all log on and have a lngEmpID number , what I what is that if tom smith logs on and uses the combo box then it will only update if he uses his name from the drop box...

vbainet , thank you for your response but this is all above my head, all I want is to be able to save a report as a pdf using the report name and adding the date to the name, if this has to be done in vba then can you show me in an example how this is done ,iy will be better for me to follow...

can you show me how to do this in vba?

sorry I do not understand what you mean , I save the report through a basic macro object type "report" object name "test" outputformat "pdf format(*.pdf)" this saves the report as a pdf called test but I need it to add the date and time to the name. any ideas please?

hi all can you help please? I am trying to save a report via a button and a macro, this I have achieved. but how do I get it to also save the time and date in the name of the pdf instead of just the name of the report? example, report name "test" pdf needs to be called "test [todays...

hi pr2-eugin , thanks for your quick response, how do I go about that? do I use the same button that opens the report to open/export it as a pdf?

hi all , can you help please , I have limited users to not show the ribbon, but I need them to be able to print of reports or export them as pdf files how do I give them access only to do this ?