Search results

Hi, I have a table called tbl_Admin, this has 2 fields in it that identify the users of my database, these are "Loginname" & "userpermissions". I am looking for a way to enable and disable certain textboxes on a form depending on the criteria in the userpermissions field. The db opens on a...

Hi all, I have an unbound listbox named Listbox19 on a form, it has 5 columns in it of which one carries is a recordId. I also have a query named drilldown that also has a recordID field. I was hoping to find a way that a user can double click on any item in the list box and it will run the...

Hi, I have a table that has 3 fields in it, these are autoID, Date, and username. Is there a way that I can auto fill these fields each time the database is opened by a user. I do not want any user input and for date I will set the default value to =Now(), the username to capture the...

Hi Is there a way I can auto run a macro that will import once in the morning and also delete the same table in the evening. My company have disabled and will not authorise anyone to have Windows task scheduler on their profiles. At the minute I have an excel workbook that is dumped into a...

Hi all, I am currently using MS Access 2007 and am trying to reduce the amount of userforms in my database. I have one large table that imports each time the db is opened. From here I have a form with 5 separate command buttons ( like a switchboard) each of these buttons opens a form...

Hi All, I have an MS Access 2010 db that has a main form called switchboard. This has 4 command buttons that open diffrent forms. Also on the main switchboard form i have an unbound textbox called TxtUserName that captures the users environ"username" when the switchboard form is opened. I...

Hi all, I have a command button on a Access 2010 form that i am using as my switchboard. On this form i have a hidden unbound text box that captures the users environ"username". When the user hits a command button on the form the code looks at the name in the hidden textbox that captures the...

Hi all, I have a form that I use as my switchboard for my access 2010 db. I have an unbound textbox that picks up the current users name using the environ username on the load event. This textbox is not visible to the user. I have a table called "access users" that I enter the staff's names...