Search results for query: *

********* 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...

In Form_Load for the subform, DoCmd.GoToRecord , , acNewRec Don't beat your head against the wall unless you know how to plaster.

ControlSource for calculated control: =([timeout] - [timein])*24 Format for calculated control: Fixed or General Number Decimal Places for calculated control: 2 To populate hours field, use a macro with setvalue or: 1. Have a second control that is invisible for the storing of the hours...

In the underlying recordsource for your subform sort your records by your Last Update field or your last touched field. Alternately, in the order by property for your subform type in the date field that you would like to have sorted by (i.e. Last Update) and then DESC. For example...

Not to bring up old issues, but what happens if you don't have a bmp on your background and you are still having the problem. Please advise. :-) PS Thanks for posting the KB articles. I did use an AutoFormat on the form, but it is one that I created??? Puzzled, SATHandle PS SR1/SR1a for...

I have a combobox control on a Form that has been &quot;losing&quot; it's properties. The font is re-setting itself to 25856 and the list rows has been re-set to 25088. The width has been re-set to 0&quot; from 2.44&quot;. The original name of the control was cboModelName and there was an...