Search results

  1. O

    HOW TO: Declare Global Vars for Usernames

    How exactly do you declare these in VBA? Currently I have a log on page which I want to include 2 user access levels. At the moment you can type in "administrator" and the password admin or "tutor" with the password "tutor" and currently, it takes you to the same page with the same privs...
  2. O

    How to Delete "Properly"

    Thanks guys, adding a "deleted" or "retired" field is a great way around the problem, I really don't foresee the database breaching 100records so size isn't an issue! Thumbs up! --- I did understand this, my tone probably masked my words a little, however nicely described in the event of...
  3. O

    How to Delete "Properly"

    I have a Manage Staff form. This form allows you to view staff and edit them. However, If I want to delete a member of staff who is linked to another table, (e.g. 1 staff member can assess MANY Student applications) it will obviously blurt out a rather helpful, but annoying message. What is...
  4. O

    Adding a new record to a form

    are you able to post a zipped version of your DB?
  5. O

    Reports in a Combo box (Simple)

    Excellent it works! Thanks!
  6. O

    Adding a new record to a form

    That's what I was getting at ^^ --- If you've already tried recreating the form by binding it to the correct table then I have another suggestion involving list boxes do your combo boxes just contain a number of values that you have input yourself which you believe will commonly be used?
  7. O

    Adding a new record to a form

    You may be better off spending 5minutes recreating the form? if you just have 2 combo boxes and an add record button, you should have it all linked up in no time!
  8. O

    Reports in a Combo box (Simple)

    I thought that too, but I can't seem to see where that is, not sure if the option is available (using access 2007 by the way)
  9. O

    Adding a new record to a form

    Could be a stupid post but..after you press the button perhaps the form should change all fields containing values and actively null them? So if nothing else works try ---- Private Sub Form_after update() If Not IsNull(combo_box.Value) Then combo_box = Null combo_box2 = null End If End Sub...
  10. O

    Reports in a Combo box (Simple)

    this is a shame! tried it with a list box first, worked a charm, then tried it with a combo box and for some reason with a combo box it doesn't block out the "rpt_" this poses a little problem as the list box demands more space, where as a combo box i expandable any ideas? Or should I bite the...
  11. O

    Reports in a Combo box (Simple)

    Looks like exactly what I want, (I'd start all mine with RptStaff_ or the like) However I don't quite understand the query he uses as the row source of the list box. I understand that a field has to contain the criteria "rpt_" but I don't know or understand what ''Left([Name],4)'' means...
  12. O

    Reports in a Combo box (Simple)

    Wasn't sure if this was a form or reports question, but eitherway, how do you put reports into a combo box? I've been able to successfully google how to look up records from a table in a combo box, now I need to be able to give a drop down list showing several reports In my modify staff form...
  13. O

    forms/subforms/tabbed forms

    Thanks a lot guys, modelling and normalising is easy..It's just the UI that gives me trouble! This will form the main meat of my application so hopefully I can get something set up! so basically the idea is: One form, one subform. In that one subform you can have multiple tabs grouped by...
  14. O

    forms/subforms/tabbed forms

    It's not quite a simple 1:M relationship as there are multiple tables, it's more like 3, 1:M relationships with Application_Line being the intersection entity 1 student can have many application headers 1 application header can have many application lines 1 course can appear on many application...
  15. O

    Default Values for a Form

    I thought if you right click on the text box in the form design view and then go to properties, click on the data tab and about 4 boxes down is "default value" That may work? Alternatively if you have several possible default values you could use a list box for alternatives AND still designate...
  16. O

    forms/subforms/tabbed forms

    I have Access 2007 and I'm creating a student admissions database. One student can create one application per year So over several years one student can create many applications. Each application contains three Course options How do I (or can I) create a form which I can add the students...
  17. O

    Basic Form Aesthetics

    Great, didn't even see that "access options" button. Easy to miss!
  18. O

    Basic Form Aesthetics

    In the old(er) Access of around 2000-2003 you used to be able to create a form, set it's size, where it pops up on the screen and it's general appearance. I see most of these features still exist however, I'm having one major problem. All the forms I create, seemingly appear maximised to take...
  19. O

    Password Protecting Buttons

    I see! You've been a great help, thanks
  20. O

    Password Protecting Buttons

    What's the general idea with the code? Is it something like: Password = PasswordTextBox if Password = Admin then ViewStaffPayrollButton = ViewstaffPayrollButton.Enabled (NB: Obviously in VBA not pseudocode)
Back
Top Bottom