Search results

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...

a function ? Sorry.. I've been hitting my head against the wall too much with this problem.. could you suggest some sort of psuedo code for this function? or a different way to get teh latest date from table ? AS i use this for reports I could perhaps have Branch based searches or grab all...

Basically for reports. If I needed a report with everything, this would be where I look for the information. All sorts of HR reports that span the Organisation. And also as a form a really easy and not really "quick" access to the organisation wide data. Now a Make Table would be a nice idea !

All suggestions readily accepted. So background. I have a HR database that has to be hosted on a whole bunch of Sharepoint List. Each branch staff & private staff information has to be in a separate table/List. We can't have branch looking into other branch. So to join all of them into 1 table...

Hey guys thanks for all the suggestions. I'm really learning more just by reading this forum compare to the stack one.... I went through the code and suddenly realised I had called the code under a condition. Since the first condition did not apply it was skipped during the onload event. I...

I have a bound form that opens and loads all its wonderful data in its wondrous glory for all to see. However there are some bits of data that have to be displayed. Now if I were to bind this form into a query, this bound form then becomes un-editable, as the query will have to make use of SQL...