Search results

thanks mate, think you are right , will try the read only route

both, some users will only be able to access certain text boxes, they will be viable but not editable

its ok folks got it

hi all can you help please I want to know how to change the title of a for to show the name of the person that is logged in . the person who logs in is given a specific number for example I would be a 1 and my name is tom jones . how would I do this please

hi pr2-eugin, all of the above are text boxes and what I am trying to do is stop them being written to by the user who's lngMyEmpID is 2

hi all, please can you help, the code below works ok but how do I make it smaller , it looks very long at the moment and there must be a way to make it look better. cheers for looking. 'If lngMyEmpID = 2 Then 'Me.ShortcutMenu = False 'Me.WPQ_record_number.Enabled = False...

adobe works fine outside access but not when pdf opened in access

hi all can you help me please when I open a pdf through access weather it is by hyperlink or attachment it always opens the full size of my monitor, if I open a pdf outside access then they open ok , how do I set the size that access opens the pdf the size I want, any ideas please?:confused:

thank you JHB for your response I will try this to see if it will work on a subform

hello all, can you help please , In my sub form I have two combo boxes named [wps] and [process ], I want to be able to filter process based on the value in wps, if you can help me can you show me how in an sample database please?:confused:

jdraw thanks for your response it solved the problem

hi cj london, thank you for prompt response but i think you do not understand what i am asking for , i know how to use conditional formatting , but not i do not know how to write an expression to complet the task (how to tell it to look at value in [status] and if "expired" then change...

hi all, can you help please, i have a subform with two fields [status] and [process], i am trying to get the backcolor of procces to change to red if the status field contains the text "expired". i have tried vba. plced on the after update if me.status = "expired" then me.process.backcolor =...

hi pr2-eugin how do i update the links please?

hello all and happy new year to you all. i have a database that has a hyperlink on the table, my concern with this is that if the folder with the linked items(pdfs) is moved to a different location then does that mean that all the links will not work? if this is so is there a way to get the...

hi all, can you help please. I need to save a report to pdf and have it use the contents of two text boxes as the pdf name all on a click of a button. example text box 1 contains "testing" text box 2 contains "123", name of the pdf will be "report name testing 123 pdf" if this is possible can...

hi all, I am running the following code Private Sub SearchResults_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "monthly report" stLinkCriteria = "[record id]=" & Me![searchresults] DoCmd.OpenReport stDocName, , ...

hi all, i am new to vba and need some help please , i have the folloing code Private Sub Report_Load() If lngMyEmpID = 1 Then Me.pm1.Visible = True this works ok but what i would like after checking lngMyEmpID to see if its true i also want to be able to look at another cell [date1] and compare...

hi all, can you help please, how do i select one record from a subform and open it on a report please? cheers:confused:

hi all, I have a list box that is that gets its data from a query "tube stock query", when I go into properties > visible and change it to yes , instead of just displaying the header it displays "tube stock query" then the header name , I have done this in lots of forms and they just display the...