Here is the full code for the event
============================================================
Option Compare Database
-----------------------------------------------------------
''Subroutine to create the pipe delim file from the 9000 using text box input
Public Sub createpsv(client_name...
I have an on click event the calls three separate subroutines, subA subB and subC. I need to make sure that subA ends before subB beging, and subB ends before subC begins. Currently, when running the on click event all three subroutines run simultaneously with disasterous results. Does anyone...
I am new to an office that shares a single POTS line with five phones connected to it. We also have one PC with a cable modem, and 4 pc's with no internet connection. I did a little digging into the walls and found that the phone extensions are all wired with CAT5e wires, using only a single...
Answered my own question.
I checked the option "Don't Optimize Column Width" on the MyODBC Data Source I am using and can write to the db with no problems.
Kevin M. Douglas
kevin@easternresearch.com
http://www.easternresearch.com
Using Frontpage, I am tying to create an asp page with a form for inputing data to a MySQL db. Things seem to be working except for one curious problem, records entered with a length greater than a record already established in the database are not stored.
For example I have a TEXT field...
I have a table from which I want to select the X most recent entries. Usually this is not a problem, I can set the query to select the top X records. My problem is that I want to select more entries based on the number of records in the table. Specifically here is what I want.
1 to 6 records...
I have a combo box (cboStudyCode) in a subform (named ProductionSubform)that runs off of a query. The Query has two fields JobNumber and Study Code
The criteria for this query is taken from the input of a text box (txtJobNumber) on the same form.
[Forms]![ProductionSubform]![txtJobNumber]...
I am trying to export a table to a csv file with header names. I have one field which is named "FILE #" When I export to csv (or Excel for that matter) the name of that field is changed to "FILE ." Does anyone know why this happens, and what I can do to have the field name...
In a data Access Page using frames I can filter records for viewing purposes. I would like,<br>
however, to set a value on the target page based on the source frame. When<br>
adding a new record, the field in the target should be set automatically to<br>
the choice in the source frame. Is this...
Using frames I can filter records for viewing purposes. I would like,<br>
however, to set a value on the target page based on the source frame. When<br>
adding a new record, the field in the target should be set automatically to<br>
the choice in the source frame. Is this possible? If so...
I need to find a way to automatically caluclate what week of the year a date is contained in. Excel allows a WEEKNUM function to do this, and according to Access Help, access should too. However, when I try to the use this function I get a "Undefined Function" message. Could someone...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.