Search results

not yet, but my vba is not very good , that's why I asked for an explanation as to how it works ,

ok thank you , can you show me how your vba works in your datasheet view please

I say tick boxes so the user can remove or re instate a field

can you use tick boxes for his instead of a list box? is can you show me please

great, how do you hide the column labels as well?

hi sneuberg could not get your demo to work for me , and I think you are right about hiding the subform , any idea why your demo didn't work for me ?

but I need the user to be able to select the fields/columns before the subform opens

hi all can you help please , I would like the user to be able to display in a subform only the columns that they want , so I was thinking maybe a list of all columns and tick boxes along side so they can choose what is displayed in the subform (or is there a better way?), is this possible ? and...

thank you for your response IIKhoutx , I have decided I do not need this in my project , thanks again

hello all , can yu help please, i am thinking of building a new project , one of the things i would like to be able to do is print all the links (pdf files) in all the records of a subform, is this possible? if so how do i go about this please:confused:

hello minty , thanks for you quick response , one question how do I get it to record when I log on and not other users?

hi all can you help please , I created a database that uses the "lngEmpName " number to give user permissions , what I need is to be able to disable the running of the database (or main form)and show an error message using vba if I have not logged in for around two weeks is this possible ? if...

the file page is the tab at the top, file, home, etc.

hi all , can you help please , I have built a front end back end database that work fine , I want to place it on sharepoint , how do I import a access database on to the cloud? I can import the tables from the back end on to it but not the database itself:confused:

hi all can you help please, I want to learn to make ribbons , can you suggest good easy to use with tutorials software for doing this :)

hi all can you help please. I have never used variables before in vba so I am not sure how to do this. I have a textbox on a sub form [signed by] I want to use the un click event that will place any values in the text box into the a variable . can you help please, this will be used as a local...

burrina, I think we have crossed wires , the tabs I am on about are the tabs in the main ribbon (home , create external data, etc. ),these are the tabs I want to restrict not the tabs in a tabbed form does this help?

hi burrina, I have a option explicit set up (this is the 1ngEmpID) I have tried the If lngMyEmpID = 1 Then Me.AllowAdditions = false Me.AllowEdits = false Me.AllowDeletions = false all this does is stop the user from adding, editing, deleting anything on the form . does not stop them...

hi burrina, tried this but kept getting compile error, method or date member not found, you say a better way would be form permissions and a global variable , I am not sure how to do this , can you show me an example please?

the user has to login with his password , each has their own 1ngEmpID, I want to on load use the 1ngEmpID to restrict the user , example, if 1ngEmpID = 1 then (restrict tabs ) its the restrict tabs bit I am stuck on, how di I do this ? and how do I just restrict certain tabs?