Recent content by sathandle

********* You may want to consider exporting your data to a fixed length text format instead. Set the field length for the memo field to the maximum length + 100. ********* Access also has an upsize wizard that "upsizes" the Access database to SQL Server. You may want to look into that. Look...

It seems as if someone else has had similar issues. r937 answered my post in the SQL Server Programming Forum and I thought it would be appropriate to post the answer here as well (I posted in both forums). see thread 701-553683 in "Access Queries and JET SQL Forum" It has been a GOOD day...

THANK YOU!!! It worked like a charm!!! To add to the efficiency of the creation of the integers table: DECLARE @Value int SET @Value = 1 create table tblIntegers (i integer) WHILE @Value<=100 BEGIN PRINT @Value insert into tblIntegers (i) values (@Value) SET @Value = @Value +...

I have an order fulfillment application that is trying to generate multiple copies of the same order so the order document can be placed on each individual box. How can I create a data source that duplicates all of the orders a given number of times. Therefore, if I need 7 copies of Order...

I have an order fulfillment application that is trying to print multiple copies of the same order so the entire order document can be placed on each individual box. How can I have Reporting Services print the order X times with a number on each print? Therefore, if I need 7 copies of Order...

This would best be done at the .NET interface level. Don't beat your head against the wall unless you know how to plaster.

I have a db that has several linked tables. They are currently linked to SQL server (MSDE Client). I want to change the properties of the links to link the tables to an Access db. When I run code that will automatically link the tables that includes the following Dim oCat as Catalog Dim...

Controls on a tabbed form are referenced the same as a control on the form itself. Use Me.ControlName Don't beat your head against the wall unless you know how to plaster.

Have you considered to save the document automatically and not allow the user to enter the file name? Pre-established file path example: &quot;\\servername\clientID (or Client Name)\2004\&quot; & templatename & now() & &quot;.doc&quot;, where templatename is based on the 5 pre-established...

Words are so inadequate sometimes to fully explain a process... Here are the step by step processes completed thus far. On computer A (550 MHz, Award BIOS, Soyo 5EHM, circa 1998): (1) Hook up drive to secondary IDE Controller, master (2) BIOS recognizes drive (drive's specs are listed when...

I have an older IDE hard disk that has a confirmed failure that is being recognized by the BIOS, but the BIOS fails to assign the failed drive a drive letter/allow the machine to recognize the drive/add the drive to the drive table so I can run my data recovery software. I am running Award BIOS...

In the AfterUpdate or LostFocus of the last control on page 1, add the following line to your code: me.tab2.setfocs me.tab2control1.setfocus Good Luck :-) SATHandle Don't beat your head against the wall unless you know how to plaster.

I'm out of 'viable' ideas. You may try a blank record for each customer that becomes the first record in the group??? This isn't very elegant, but doable - Like I said, I'm out of 'viable' ideas. :-) Don't beat your head against the wall unless you know how to plaster.

Why not export to XML? I have Access 2002, so I am not certain if this is available in previous versions of Access, which I am sure it is not. :-) Don't beat your head against the wall unless you know how to plaster.

I have a form that is running code when it is being opened for editing in design view. The steps I am doing is as follows: 1. Open database using shift key bypass. 2. Highlighting form. 3. Click on Design so I can make changes to the form 4. I am now prompted for my territory (i.e...