Insert series/sequence of numbers1194 (4/12/2007 2:08:52 PM) comp.databases.mysql I have a mysql database where I want to bulk insert a series of numbers. Is there a way to insert 1000 records (with one sql statement) where a field called fld_listnum starts at 2223 and increments up to 3223... tdmailbox
Simple 3 table query failing.216 (8/25/2005 4:52:06 AM) comp.databases.ms-sqlserver I have a database with three tables tbl_listings - listings of houses on for sale tbl_intersted - table which tracks if a user is interested in the listing, it has two columns mls(the key for tbl_listings) and... tdmailbox
Read only version of a form.236 (8/1/2005 2:08:07 PM) comp.databases.ms-access I have an access form that has VB code to enable and disable individual fields depending on the state of other fields. That works great. However, now I am looking to create a read only version of these forms ... tdmailbox
Searching Child Forms128 (6/27/2005 3:24:18 AM) comp.databases.ms-access Is there a way to use the built in access find/replace to search values in a child form accross multiple parent records. IE.. If have a parent form has a record for every baseball team with summary info and ... tdmailbox
Field Length for text box in form128 (6/27/2005 1:50:23 AM) comp.databases.ms-access Is there a way to set field length on an access form? I have a text box that I want to make only one letter long(it stores a middle initial). Or is there a way to set up a validation rule that only allows one... tdmailbox
Specifying parent child form by name422 (6/13/2005 12:25:45 AM) comp.databases.ms-access I have form with subform that has a button(one in parent, one in the child) that calls the microsoft access find/replace object. In order to make it a find only object I need to set the allowedits property to ... tdmailbox
Pulling out data between <TD> tags using regular expressions2070 (5/26/2005 10:04:18 PM) comp.lang.perl.misc If I had this tag and wanted to return 123 how would I do it? I have tried countless methods but can not get the only the 123 without the tags 123 After 3 hours I am giving up and asking the experts. ... tdmailbox
Error when user submits form with ; in value329 (2/21/2005 12:54:54 AM) comp.databases.ms-access I have a function that hashs the value that a user entered in a text box and stored that hash value as a password. All is well unless a user enters a password that when hased has a ; in it. If a user entered ... tdmailbox(42)
Specifying parent child form by name422 (6/13/2005 12:25:45 AM) comp.databases.ms-access I have form with subform that has a button(one in parent, one in the child) that calls the microsoft access find/replace object. In order to make it a find only object I need to set the allowedits property to ... tdmailbox(42)