Search results

  1. M

    How do I make the subform stay on top

    The code's pretty simple... Private Sub gymcentrezoom_Click() If gymcentrezoom.Caption = "+" Then 'Perform the zooming operation 'add_gymcentre.width = add_gymcentre.width add_gymcentre.Height = add_gymcentre.Height + 1220 add_gymcentre.BorderColor = vbRed add_gymcentre.BorderWidth = 2...
  2. M

    How do I make the subform stay on top

    I've got a form which will have several subforms in it. I've got a button by each subform with a '+' sign on it. When the user clicks the '+' sign, the subform gains a red border and is enlarged over other controls, that '+' sign then becomes a '-' sign and when pressed returns everything back...
  3. M

    Access Hell - A programmers nightmare

    Thanks for the help, compacting worked
  4. M

    Access Hell - A programmers nightmare

    Here's my dilema: Here's what I can't figure out: How did this file get to be 27MB with no data in it? Here's what I'm going to do: How do I get out of this mess? (I'm going to completely rewrite it) Where do I start normalising? (hopefully the redesign will help)
  5. M

    Simple Validation Question

    Sorry, I wasn't clear enough in the last post. All I want to do is only allow alphanumeric characters in this field. EDIT: I just reread this and it looks a little rude, I assure you all it was not the intention, I've added a comma after the 'sorry', should read better now.
  6. M

    MySQL and Access

    Of course you will need to install the MyODBC drivers so that Access can play nicely with MySQL. These are available in the 'Downloads' section of http://www.mysql.com
  7. M

    Table design question

    Yeah, normalisation helps. I'd also recommend drawing an Entity Relationship diagram, it helps you think in 'many and one' style. Here's an example of an Entity Relationship Diagram: A user can be a member of Many Groups A user can have many 'prodlink' records. A product can have many...
  8. M

    Simple Validation Question

    Hi, this is my first time posting and I have a really stupid easy question, how do I build an expression which allows letters, numbers and an underscore? Much like (in PHP): $regex = '^'. '[_a-z0-9-]+'. /* One or more underscore, alphanumeric, or hyphen...
Back
Top Bottom