Recent content by wodonnell

TransferText was the one - worked a treat.

A variation on this question... is it possible to bypass the wizard to import a CSV file, if you know all the parameters in advance?

I would like to have a control on my form which displays the opposite value to that stored in the table. ie, if the table says "TRUE" then the form should display false. Having the value displayed is simple enough. I have two fields on the form - Field1 is the value from the table and is...

If there any way to display the Lotus Notes Address Book using code, let the user select a name and return the name to Access? I am using Access97. I have tried reading the address book into an Access table. This worked but was so slow it will be impractical. The address book will contain...

Perfect! Thanks for the fast response!

Is there any way of either: (a) locking a combo so that the dropdown does not work without setting enabled=false, or (b) enabled=false but control not grayed? I have set the backcolor to a different color when the controls are locked but do not want the dropdowns to function. I can prevent...

It looks like my problem was because the form was a pop-up. When I make popup=No it seems to work!

OK, I have decided I can live with having the textbox displayed. This way I will be able to display some other "useful" information at the same time. I have a form which contains just a textbox (text0) which already contains some text. The textbox is not hidden or disabled or locked. I have...

It doesn't! I just get an error message saying I can't set the focus - presumably because the control is not being displayed.

Is there any way to copy a string of text to the clipboard. I do not want the text to appear on the screen so accmdcopy is no use. In Excel there is a function called PutToClipboard (or similar). Is there anything like this in access? Thanks.

I have opted for simply changing the text color to a light grey. This way it is easy to see at a glance which records are important and which can be ignored, but also the "rejected" records are still fairly easily readable.

Example of report (my actual report is quite a bit more complex than this but this should give the basic idea): Firm | Date of Application | Status --------------------------------------------------- My Firm | 11-10-2003 | firm 2 ltd | 10-09-2003 |...

Is there any way of setting the strikethrough property of a font used on a report. I would like to be able to "cross out" certain values on a report if certain criteria are met. I have been able to change the actual font, or the size or set bold/italic/underline, but there does not appear to...

I have managed to find a sort of answer at Microsoft.com It basically says that the image will be static, however, you can see an updated version by pasting into a form, opening MS Chart, saving the chart(!), then copying and pasting from the form back to the report...

I tried all the usual tricks of closing the report, then closing access itself. I think I even tried closing down my PC but it still gave the defaul chart in the design view.