Search results

  1. T

    Exporting all tables in access database to excel at once

    I have a database with roughly 100 tables in it, and I would like to essentially "back-up" all of the data in the tables by exporting them to excel spreadsheets (one spreadsheet per table). I know I could manually export each table one by one, but this is not really what I was goin for. Anyone...
  2. T

    User Level Settings Locked Me Out

    So, I have a rather huge problem right now. As of this morning my database was unsecured, so I decided to try and mess with/get used to the user level security settings/wizard...maybe not the best idea. What appears to have happened to me is that I can no longer edit my security settings because...
  3. T

    Creating a User Log from Login Form

    Hey everyone, I currently have a login form. Consists of a username combo box which gets the UserID and UserName from a table (call this the UserName table...the UserLog table is different!...see below). Below is a password form, which of course the user enters. Upon clicking the Login command...
  4. T

    Press Enter While In Textbox to Activate Command Button

    So I have a password textbox where the user enters their login password into. After they enter it, if they press enter it essentially "highlights", or gives focus (as if I tabbed over to the button) but doesn't actually click/activate it. Is there a way to have the 'Login' button activated when...
  5. T

    Switchboard Problem

    Hey everyone, Got a little problem with my switchboard... When I start my DB it goes to my splash page, then to a login page, then finally to my switchboard. Switchboard looks great when it is first opened...(maximized, no boarders, buttons aligned). Heres the problem... As soon as I click...
  6. T

    Update Date/Time Field OnClick?

    Hey again, Ok so I have a tabbed form with a subform under each tab. The date/time field on each subform has the default value: =Now(), however the user may take a while before entering data into the subform (due to them collecting the data first). Is there a way to update the date and time...
  7. T

    Default Value Problem

    Hey guys, I currently have the default value for one of my fields set to =Date(). I wanted to know if there is a way to add a space after the date, so in the text box linked to this field the user only has to press [CTRL]+[SHIFT]+ ; to add in a timestamp (not [SPACE] then [CTRL]+[SHIFT]+ ; )...
  8. T

    Multiple combobox selections to open subform

    Hi, Below is a screen shot of the layout for what I want to do will look like. I have absolutely no VBA knowledge, although I will be reseaching it extensively today and in the days to come. What I am trying to do is select any combination of choices from the three combo boxes at the top (I...
  9. T

    Text box with vertical scroll bar

    Hi, I would like to do something along the lines of this: 1) Have a button on my current form that either opens a specific word document (in word) or opens a form that displays a scrollable text box (read only) that I have filled with text. Any idea on how to do this?
  10. T

    Data from specific tabs to specific tables

    Data from one form to multiple tables Hi, I have a question concerning the database that I am working on for a company I am interning with. I started with absolutely no access knowledge, but I have been teaching myself via forums and online help (and the obvious trial and error) over the past...
Back
Top Bottom