Replies

“You can export a table to an external file (File | Export…), but the exported file will be completely separate and independent from the Access database.”

You can, however, link Excel files stored outside of the Access file so that they act as tables within the database. For more info, look at this:
Import or link data from a spreadsheet and follow the instructions to link (rather than to import).

The secret lies not in the design of the form, but the design of the query. If you’re designing the query in design view, you can set the values in the Criteria row to the values of the fields on your form, like this:

[Forms]![MyFormName]![FirmSizeComboBox]

As long as the query runs while the form is open, it should work. If the form isn’t open, the user will be prompted to enter the parameter values for each of the criteria.

My understanding (which may be wrong) is that each user has their own account on the Citrix server, and can store their personal.xls and similar files there.

I suppose it’s possible though that you could set the Citrix version of Excel up to look at locally stored “customisation” files – that way they could use the same files that they use when they run Excel locally, avoiding duplication of the files and meaning that any changes made will affect both their Citrix and their local use. This might have a detrimental effect on the running speed of Excel across Citrix though.

This could work even if my understanding in paragraph 1 is false. If everyone is accessing the same instance of Excel, the pointer to the personal macros workbook etc. could still be set to a destination on a local drive. You’d then have to make sure that all your remote users stored their personal.xls in the same destination folder . Then it should work like a relative hyperlink, picking up the current user’s individual personal.xls workbook from their own machine.

Sorry if this is a bit garbled – let me know if I need to give a better explanation. I’m sure it can work!

Could it be that your Normal.dot document template has the property set to true? (Another guess) If you’re not getting the problem with other documents, it’s unlikely to be this though. You could check that this particular document isn’t using another template instead (Tools > Templates and Add-Ins…)

Here endeth my limited knowledge

I’m guessing here, but it could be that the folder in which you’re saving the document has the “Folder is ready for archiving” property set to true, and so any file you save in that folder inherits the property. Try checking the folder properties (in the same way that you can check the document properties) to see if this is the case.

Cheers,

Hi Jo

Trust me, Stuart’s solution is the way foward. The date will display in full if the height of the task bar allows it to. If you reduce the height of the task bar by dragging the top edge downwards, you’ll see the date disappear and just the time left behind. Dragging the top edge of the taskbar back upwards again, increasing the height, makes the date reappear.

You can make the date and time disappear completely if you wish:

1. right-click on the task bar
2. uncheck the “Show the clock” box
3. press ok

Hope this helps,

Ah, I see what you’re after – and unfortunately I don’t think it can be done. A control is either visible or not at any time, so if you’re trying to hide a control in some records and not others, in Continuous Forms view, you’re stuffed I’m afraid.

What you can do though is copy that code from Private Sub optPDetails_Click() to Private Sub Form_Current() so that as the user moves from one record to another, the controls will appear or disappear according to the optPDetails box for the record they’ve moved to.

Finally fixed it! The second article I posted says:

When you compile the project, you receive the following error message:
Compile Error:

Procedure declaration does not match description of event or procedure having the same name.
The following line appears highlighted as the cause of the compile error:

Sub Form_RecordExit()

This is incorrect. When I compiled the project , I did receive that message, but the the line that was highlighted as the cause of the error was just a bog standard event (in my case, Sub Combo171_Afterupdate() ). So I cut this sub, and repasted it (I changed Combo171_AfterUpdate to Combo171_Change too) and suddenly everything is working properly again.

Sometimes I just want to phone Bill Gates and say

The “extracted files” are actually a single Word document, if that helps you choose.

For once I’ve been able to answer my own question, by (even more shockingly) searching the msdn site. The word document at the end of this link explains all the budding artist needs.

My apologies for not trying MSDN first – usually it’s so unhelpful that I didn’t even bother this time!

No, actually you’re right – I’ve been really thick. Although there are three links to the site map on every page, all three are generated by javascripts (d’oh!). And I’ve been incredibly lazy – there’s not a single tag anywhere on my site! I think I’ve taken too many shortcuts… time to start putting some tags in…

Thanks anyway

Don’t forget to check out the prices for other domains, such as .org.uk (if the organisation is non-profit), .org, .net, .tv, etc.

As someone who lives in Southampton (the real one, in the UK ) either one seems equally memorable to me. Personally I’d prefer to see Southampton rather than Soton, but that’s just me. Alternatively, you could try a more regional approach – variations on South Hampshire, South Coast, Solent, etc. might be worth looking into, and would come across as more inclusive to people outside of the city boundary (Eastleigh, Romsey, etc.)

Not sure if this will work for you, but give it a try:
http://www.twiga.ltd.uk/rdu.asp%5B/url%5D

Works a dream. It also seems that you can edit the properties using that .dll, too, although I haven’t tried that yet. My organisation has just introduced some new rules around file handling, stipulating that the document properties have to be filled in for every document, spreadsheet, etc. – doing it en mass in VBA is going to make life SO much easier. Thanks again, Hans, you’re a hero!

Excellent! Thanks again, I’ll give it a go.