Search results

hi all can you help please, after making some text boxes that are lookup's , they are on a subform, I have set them up so I can add to them as I go along , but for some reason they are not working, I have the small square with a v in it when I click on the textbox and it opend up a blank square...

thank you for your quick response , can you give me an example please

hello can you help please , is it possible to access a column in a query using vba ? I have a query that has a lot of tick boxes on it , I do not want the tick boxes to be shown on my form but would like to access them to find out if true or false . cheers

thank you CJ London, multi select list box looks a good way to do this, but not sure on the code , if I have three columns [column1] [column] [column3] how do I get it to hide [column2] for example

hello all , can you help please , I have a subform that I want to produce a report from, but I do not want all the columns to be on the report . I would like the user to be able to pick what is shown on the report , (I was thinking of using tick boxes in some way) or is there a better way of...

hello all can you help please i need an update query that when run shows the following columns id , stat, date, update, what i am trying to achieve s when the query is run the stat column can contain either "positive" or "negative" i want to be able to change the update column to "accept"...

thank you again arnelgp, for your response , i will try this mate

hi all can you help please, I have a form [mainfrm] with a sub form [subfrm], on the main form I have a text box [status update], on the sub form a text box [status] , when i select a new record on the form I want to be able to look the [status] text boxes (there could be many or just one...

hello all, can you help please ,i have a form with the following fields [calibration date](date field) , [calibration period](number field) and [calibration due date](date field) what i am trying to do is after the date has been entered into the calibration date field, the user puts the number...

sorry if I am repeating my messages , having issues with internet here

cheers mate works a dream

hello arelgp, how are you today? my post is in the forms forum called subform column selection . spikepl posted a demo that let me select items from a list box and the sub form then changes to hid the selected. this works great . but if the user closes the application and re opens it all the...

hello arelgp, how are you today? my post is in the forms forum called subform column selection . spikepl posted a demo that let me select items from a list box and the sub form then changes to hid the selected. this works great . but if the user closes the application and re opens it all the...

hi arnelgp, have you had chance to look at my problem yet please?

hi arnelgp , hope you are well, I have posted a topic on the forms section titled subform column selection, my initial question was answered , can you look at it please as I have asked another question about it , and it was suggested I ask you for help in producing some code to solve my problem...

hi sneuberg, had a look on internet ,(found interesting stuff on list boxes , multi select , etc ) , but could not find out how to save the selections on a lisbox to a atable and then use this when I re load the form, any help please?.

hi all, how would could this be modified so when the database is re opened it will show only my selection and not all the fields in the subform please?

hi all , I think I've cracked it , I will post how I did it later after I have tested it fully , its a very long winded way but it seems to work.

how would you apply this to change a button color on the same form and save it please

hi arnelgp, I found this https://msdn.microsoft.com/en-us/library/office/ff845076.aspx and it works ok (had to disable the shortcut menu though as when you right click and message is closed it goes auto to menu shortcut ) but this is not a problem as I intend to disable this anyway, thanks