Recent content by fryguy5049

here is the table: CREATE TABLE `pymnts` ( `Front_Filename` varchar(58) default NULL, `Account` varchar(17) default NULL, `SizeFront` varchar(100) default NULL, `TranCode` varchar(8) default NULL, `rec_leng` varchar(45) default '00512', `rec_type` varchar(45) NOT NULL default 'M000'...

windows 2000/MySql 4.1 I have a table that has a couple varchar fields set to default values. When I run an insert statement the default value fields fill as expected. When I use an INFILE statement to add data to the table the fields set to default values don't fill properly. Any ideas how I...

I am creating an extract for a mainframe application that requires fillers between certain fields. I wanted to just specify the field "def_spc" when I needed a 8 space filler.

MySql 4.1/ Windows Server 2000 How can I set a field to a defualt value of spaces? For example I need field "def_spc" to equal 8 spaces. This is just a filler field and it would never change for any record. Also, what's the best data type for this type of field? Thanks

Awesome! Too much back and forth testing and i forgot to put the parameter in the query back to : Between [Forms]![fdr_batch]![startdate] And [Forms]![fdr_batch]![enddate] Instead of a "hard" parameter. Thanks so much for taking the time troubleshoot w/ me & for the debugging tip.

message box pops & says 0.

The name of the form is "fdr_batch". The name of the first text box is "startdate" & the second is "enddate".

Tried that and I get the same error message-"item not found in this collection" Any other things I should check? Thanks!

I don't see how that can be incorperated into my code. Should I just add this code? Where at? Sorry I am pretty new to this. I am not sure if the textboxes are already referenced. Thanks 4 your patience

I am receiving the error "Item not found in this collection" The parameters I am attempting to pass to this code are in 2 text boxes of the form(start date & end date). The form is open when I try to run the module & I am using Access 2000. The code fails on this line: qdf.Parameters(1) =...

Thanks. I believe that cleared up that problem. Now I get the error "Run-Time error 3421: Data Type conversion error". Any clues to what causes this error? Thanks again for working with me.

I get the same error as mentioned above. Does this code need to be inserted in a specific spot? Thanks

I am using Access 2000 with an Access db,forms,querys,modules. I have a command button on a form that executes VB code/module. The form also has 2 text boxes to use as date parameters(begin & end date) in the query. How do I get those parameters into the VB code? I get the error "Run time...

I have crosstab query that uses a where clause to limit the data retrieved. Is there a way to add an additional column to the crosstab that isn't limited by the where clause? Ideally I would like the results of this query as a column in the main query: 'select accstore.store ,count(date) from...

CR 10 & MySQL 4 I have a DB with new data everyday except there is no data on saturdays. There are no nulls in my date field, just not a record for any date that falls on a saturday. how can I write a formula that pulls data from the 9th day of every month and if the 9th falls on a saturday...