Recent content by dbc1

Thanks, Col - with SetValue?

I need to create a form with an "authorise" button on it which will retain the username of whoever clicks a command button plus the date. How do I get the username to pass to a specific field - e.g. AuthLevel1? Many thanks in advance.

I need to create a form with an "authorise" button on it which will retain the username of whoever clicks a command button plus the date. How do I get the username to pass to a specific field - e.g. AuthLevel1? Many thanks in advance.

You need to set an option in Word: in Tools; Options, tick the box "Confirm conversion at Open". This will allow you to decide the connection method (e.g. dde) and then see all the tables and queries in the database you choose.

The only way I have found to do this is to export the field contents in two halves and then put them back together with a macro in Excel. The following splits the data into two separate parts in a query prior to export, where CINATURE is the field name: Expr1: Mid([CINATURE],1,250) Expr2...

The only way I have found to do this is to export the field contents in two halves and then put them back to gether with a mcro in Excel. The following splits the data into two separate parts in a query prior to export, where CINATURE is the field name: Expr1: Mid([CINATURE],1,250) Expr2...

Many thanks - that certainly seems to replicate the problem on my PC. I'll pass it on and let you know if that fixes it. Have a great day.

A colleague of mine suddenly has all her numbers in Excel displayed as what looks like percentages - but without the percentage sign; e.g. 10 displays as 0.10, but 0.5 shows as 0 (presumably as display is set to two decimal places). This affects all old as well as new worksheets - but if she...

Hi, edtab. I tried your suggestion, but this only displays the last record, rather than all the records and the last entry in the specific field. I really need the balance to show accurately and dynamically for each record, rather than every record diosplaying the current balance. Apologies...

Excellent - thanks for your help; I will post back when I have tested it.

Hi, hope you can help me with a small problem. I have a subform (datasheet format) which shows payment and fee records with a current balance displayed for each record. I'd like to only display the balance on the final record, but can't work it out. Can anyone help by pointing me in the...

Creating Outlook appt Well, if you don't need to update it all the time throughout the day, you could import the file to Outlook; say, at day end. Just go into the calendar and use Import/Export; import from another program and then choose the Access file. Really simple and effective. You...

Try 16119285.

Is the link to a .pps file or .ppt? A .pps file is a slideshow and so wil run immediately it is opened.

Usually you need to switch the macro security to low. (Tools, Macros, Security).