Search results

MyODBC and Access - one step closer Ok this is really bugging me (because I just can't figure it out). I'm using Access with MyODBC (an ODBC driver). Every time I click the new record button, enter some data in and proceed to enter some more data in a sub form in the same form I get...

Ok for searching I want to use the 'filer by form' method in Access. When this user clicks this tool bar, the form goes blank, the user type what they want in the fields they want and when they press the 'Close' button: Access adjusts the filter to records that are LIKE what the user...

I have a form called 'Form_show_login' Inside is two textboxes, one called ownerName and one, ownerPassword Also is a button called 'frmlogin' I have two tables, one called DBOwners which has the fields, DBOwnerID (autonumber), DBOwnerName, DBOPass, DBGroupID (f-key) and DBAdmin (bool) And...

Ok, all I want to do is perform an SQL query in access to count the number of records in a query and return that to an integer. I want to run an SQL query like: Dim SQL as string Dim RecordCount as integer SQL = "SELECT COUNT(TrackID) FROM tracks WHERE FacilityID = " & FacilityID.Value...

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

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)

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