Recent content by GrunleStan

So I have a column, that I would like to hide and not allow some users the ability to unhide this column. column-name.columnhidden = true should do it. now how do you not let them unhide it ? or am I trying to do something Access doesn't know how to ? TIA

apologies for reopening this old Thread, but if I were to test for a form to be open as Read only, what would I test for ? me.allowedits ?

I find having to have my Property windows open and double checking tons of forms to edit a caption very tedious. And so I was able to set the captions of a form via VBA code! Hooray ! But when I tried to do it for a Header label, the code seems to fall flat on its face :banghead:. I have the...

There are no stupid questions... I learn from the issues other people face. So keep asking. and congrats on the baby (18 months late). Kids are the best before they learn to answer back.

I have 2 styles of reports. Both of these reports will have its summaries in a table form. I basically have to 2 problems. 1. Best way to fill the numbers. I can do it as a form and export it out to an excel or PDF but that is not a report :( 2. How do I force a report in to Landscape mode ...

same answer a minute a part !!

its your Condition in your query... from Like "“*”" & [Forms]![SearchF]![DesigTeacher] & "“*”" to many quotes double quotes. change it to Like "*" & [Forms]![SearchF]![DesigTeacher] & "*" as a matter of fact when typing the criteria in to Access, leave out the "", the Design window will help...

It is working now !! The latest shows up as intended... I can't believe I was foolish and left the date field as a short text type.... :banghead: Thank you to everyone !! Especially ArnelGP, June7 and everyone who helped with this. Now... how do I marked this solved ?:confused: hrmmm. .. ...

Update : Thanks Everyone, I managed to get Arnel's SQL working; then something strange happened. I added more data in to the payscale just to test it out. And all of a sudden, it just stopped working and kept showing the old results. I had added a later date (previous date for one of the staff...

the original Query was uneditable due to the DMAX call as well. so its no worries... Its just so I can get some information quickly.

I keep the branch there in case the person has been reassigned to another branch. That way I can keep track of branch specific information. Its a strange world. Did I mention that this was meant to sit on a Sharepoint site since their IT dept doesn't want to touch this with a barge pole...

All latest records please, and yes I do have an autonumber PK.

I've been using databases since FoxPro and I don't remember that one ... only one that I liked on an Apple was Filemaker Pro. welcome to the forum

This is a great site for picking up tricks.. I'm self taught on VBA.

So I have a table_payscale with ID <- Primary Autonumber key Staff_ID<- Foreign key to another table PayScale <- important information DatePayScale <- Date important information last changed. Branch <- branch person is in. What I require is to filter out all the old information from the table...