Search results

  1. G

    Datasheet - Secret Column

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

    Header Titles from with in VBA

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

    How do you fill out a table based reports ?

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

    How best to Select the Latest of entry ?

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

    Requesting for help in improving performance

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

    A quandary regarding form events

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

    Just Joined

    I'm kinda new here... just joined after trawling the site for the longest time. very informative and helpful people around on this site... also forgiving to those newbs (like me) who don't exactly google their answer correctly.
Top Bottom