Search results

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

The answer is to carry out the process in Word rather than Access. Don't go to a report - use the underlying query to provide data (including email addresses) into the Word mailmerge. Carry out the mailmerge in Word and instead of using "letter" as the medium, choose "electronic mail" within...

Hi, I'm trying to put together a database for our street markets, including cash and out; reconciliation sheet etc. It needs to be done fairly quickly and I wondered if anyone has anything with a similar function which they could let me cast my eyes over. A starting point would be really...

Do you want to do the mailmerge as a report in Access - or via Word? Both ways are easy - but it depends on who will be carrying it out (admin people generally prefer via Word).

Thanks - my email is sent as a result of a macro. How do I code the action to the button? dbc1

I am trying to build a macro to send an email when new data is entered into my db via a data access page. The email part is OK - but how do I generate the message - i.e. how does the db know when new data has been entered? I would appreciate some help.