tdmailbox's articles:

Items(32) /4 Next >> Last >|

Insert series/sequence of numbers 1 194 (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. 2 16 (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. 2 36 (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 Forms 1 28 (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 form 1 28 (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

Displaying hyperlinks (as hyperlinks) data stored in linked table 0 41 (6/24/2005 4:00:27 AM) comp.databases.ms-access I have a access database appliaction that links to a sql back end. One column has a field that is always populated witha hyperlink. Since it is a linked table though it is stored as a varchar in sql. How can ... tdmailbox

Searching for data in child forms, across multiple parent records 1 27 (6/16/2005 2:17:56 PM) comp.databases.ms-access I have added search buttons to some access fomms. I have a seach button in both the parent and the child form. My issue is that when I search for a last name in the last_name field of the child form I want t... tdmailbox

Specifying parent child form by name 4 22 (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 expressions 3 19 (5/26/2005 10:05:18 PM) comp.lang.java.programmer 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

Pulling out data between <TD> tags using regular expressions 20 70 (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

tdmailbox's replies:

Items(8) /1

Access Form Null Checking with Linked SQL / ODBC Table 4 40 (10/4/2004 2:31:42 AM) comp.databases.ms-access I have a access form that is connected to linked sql table via odbc. I have some fields that I dont want to allow nulls when data is entered via the form. I can set the null checking on the SQL server databa... tdmailbox (42)

Displaying first record of subform in parent form. 5 20 (1/23/2005 3:32:39 PM) comp.databases.ms-access I have a form with a child form. In the child form there is a list of names that can grow quite large. On the parent form I want to display the first name from the child form. I set up a test box that is po... tdmailbox (42)

Validation rule for number 3 24 (2/1/2005 2:00:02 AM) comp.databases.ms-access What is the proper way to set up a validation rule to only allow numbers? I want to allow both 1024 and 1024.25 ... tdmailbox (42)

Disabled Shift bypass key but want certain users to have table /query access 3 26 (2/17/2005 6:24:25 PM) comp.databases.ms-access I set up my code to disable the shift bypass however for certain users I want to allow them through a button no a form to be able open up the list of tablies and queries. Is there a vb command to open up the u... tdmailbox (42)

Error when user submits form with ; in value 3 29 (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)

Using Access 2003 package wizard to package a database for a Access 2000 client 3 19 (2/21/2005 11:37:18 PM) comp.databases.ms-access I developed an access database in access 2003(keeping my database in the access 2000 format). It has been fully tested to be access 2000 compatible and works great. I am trying to package the final version ho... tdmailbox (42)

DTS of data between two tables, same field names but differnt datatypes 3 18 (5/6/2005 2:12:15 PM) comp.databases.ms-sqlserver I need to migrate data from one sql database to another. The second DB is a newer version of the "old" database with mostly the same tables and fieldnames. In order support some reporting queries in the "new"... tdmailbox (42)

Specifying parent child form by name 4 22 (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)