Replies

Thanks Hans
I’ve download the program, manual and sample apps from their website. I’m just trying to work out how to set the interface programmatically, rather than via their selection screen. Have you used this before? Do you have any sample apps you can post?
John

Turn off autoarchive. You may have been asked if you wish to archive on a regular basis – if you click yes, then your old appointments may be in your archive folder (seach for archive.pst – remeber to tick the box to look for hidden folders too)
You can set auto archive to do it’s job at set periods, going back for set periods of time.
Have a look in Tools….Options…Other tab……AutoArchive and play with the settings in there. This should also tell you where your archive.pst folder is

You can open you archive.pst folder via File…Open…Oulook Data File… and give the location

John

If you click on the “More Settings” option you can enter a reply address. This should give you what you are looking for

Thanks Hans, no joy from that, or resetting other tick boxes either.
Eventually traced the problem to upgrading the PCs to IE7. Needed to add the location of the file in Internet Explorer via Tools…Internet Options…Security…Local Intranet…Sites…(remove the tick here against ‘automaticaly detect intranet network’, leave the remainder ticked) Advanced then Add the file location. Once this was done on each of the machines it worked without a problem.

I’m not really sure why this allowed it to work. I would have assumed that ANY access via the workgroup would have been prevented, rather than just multiple access to the file. Maybe it was just the ”automaticaly detect intranet network’ part that resolved the issue – not there to test it again at the moment but I’ll check on my next visit.

I know with others who have IE7 and share Access databases in the same way it has not been a problem – oh well, sorted now

John

You could create a blank table each time to which you append records in a loop starting from the start date of the report and ending with the end date.
This way you wouldn’t have to make any changes to the table if they wanted to report before/after the first/last date you have manually entered.

Edited by HansV to make URL clickable – see Help 19

Steve
The epson dot matrix printers are generally controlled using ESC/P and then later the ESC/P2 printer language. You can use to this control all aspects of the printers operation. It is possible to define the page to a specific size, move forward by a certain distance, change fonts, etc.
The following link will give you a lot more information about it. http://www.epson.co.uk/support/manuals/pdf/ESCP/Part_1.pdf%5B/url%5D
I used to use this a lot a number of years ago (don’t think I’ve done anything with a dot matrix for 5 years or so), but the programming language hasn’t changed much in that time.

Your problem may be getting the grumpy programmer to bother to add it to your code for you!!

It is very simple to include in code as the printer “intercepts” the control language and carries out the instructions it receives.

Let me know how it goes

John

Is it enough to simply re-enter the index information – or should i remove then re-enter more information that this? If the system table has been damaged once is more likely to corrupt again, or are such errors fixed by compact/repair ?

The database seemed to be complete apart from a number of tables where the index/primary key information was missing. I have a print of the table structure from Tools…Analyze…Documenter so had the information for all the indexes. I just went through each table and recreated any indexes which were missing.

I DON’T have it split as frontend-backend – one of those things I know I should do but never got round to for this one. It’s used by a few people who populate various tables within the database.

I do backup the database each night (and tested the restore too), but as the data was intact it seemed better (quicker) to reindex rather than reverting to data from the previous days backup.

I was surprised that the indexes were removed in such a “clean” way – all the indexes from a numbr of different tables. The relationships between the tables remained and I didn’t need to do anything with these to get the database to work again. I presume that somewhere within the database structure Access holds a secret table of index information and this is what was corrupted – or is this too simple a desciption of what happens? My only other thought is that someone removed the indexes manually (accidently or not), hence my concern about the clean way in which the indexes disappeared, but to do this across a few tables would be less than accidental!

I am also presuming that re-entering the index information will have cured the problem, though as it has happened twice I can’t be 100% sure of this.

OK, I can see how I can use this to delete any particular entry I need (create a delete query with criteria for subject as like “1234 *” .

For editing, how can I find out the date, start time and end time of the calendar entries if they aren’t displayed using the link to Outlook from Access. I need to be able to pass any updates to the events table, but nothing I’ve found so far allows me to pick up these details. Is that what you mean by “this is Outlook VBA not Access VBA”. Do I need to run this routine in a different place? Is there no way to grab all this information within an Access table?

John

I looked at creating a link to the outlook calendar but was surprised to see that it doesn’t show all of the fields when I link to this table – particularly, it does not show the date of the calendar entry, the start time or the end time – fairly important parts!

I’ve linked via Outlook, presuming that this would be the same using Exchange.

Am I missing a trick somewhere to show more information? Is there some VBA reference I need to link to to view this additional information – I’ve included Microsoft Outlook 11.0 Object Library.

John

Thanks for the pointer to CDO – not something I’ve used before.

When I have added new calendar entries into Outlook from Access, I have maintained a table of the entries as these give extra information which I don’t need to show as an entry in Outlook (these are the records I mentioned).

As it is possible that people will have moved entries in the Outlook calendar, I wanted to be able to retrieve the calendar entries from Outlook, import them into a new table and use this to update the data held in the original Access table. I have an autonumber field in the original table. This number would be the first part of the description of the calendar entry so I was hoping to use this to control the update of the data. eg. A calendar entry might be “1234 – Install new computer for Fred”, so I can use the 1234 as a link to the record in the original table.

The complete series of events I think I require is:

1. Create a new record in the events table in Access and add this as a calendar entry in Outlook – DONE
2. Import Outlook calendar entries to currentcalendar table in Access (need description, date, time etc of entry), update records in the events table in Access

As an extra to this, I will need the ability to delete a calendar entry based on knowing the value of the autonumber field in the events table. This may involve importing the Outlook calendar entries to the current table file again, finding the specific calendar entry and deleting this from the Outlook table – it’s the format of the command to delete the message I don’t know.

Hope this sheds a little more light on my requirements

John

I know the answer, but the question is wrong!!

It is not “whilst 8 of them also cost” and “they sell 16 of them for the knockdown price” but simply “whilst 8 also costs” and “they sell 16 for the knockdown price”.

“Of them” indicates it is a quantity!

Was bored so thought I’d have a go at this. There is no specific way of doing this, no unique results and no “formula” to work it out each time but a variety of ways to simplify things. Best quick tip is any thing divided by itself equals 1, therefore if you use small numbers for the add, subtract and multiply and keep 2 of each number and a 1 for the division it makes life simple.

I’ll leave a few lines before my answer just incase you want to try yourself with the above tip.

Best of luck

John

Q1.
22 + 44 = 66
99 – 88 = 11
3 * 4 = 12
753 / 753 = 1

Q2.
8 + 2 = 10
61 – 50 = 11
3 * 3 = 9
110 / 110 = 1

Q3.
1 + 2 = 3
68 – 57 = 11
9 * 9 = 81
111124 / 111124 = 1

I had a similar problem with labels a while ago – never seemed to print within the label spaces.
You would assume that when you set the paper size to A4 in Control Panel, Printers & Faxes, that it would become A4 – but NO.
You need to check that it is changed in all the printer options in the Device Setting tab, then in the General tab under Printing Preferences, and then check the Advanced tab for Printer Defaults. Your printer may have different settings tabs, but generally the A4 entry will be in more than one location within them.
Once these are all set for the printer, you can then set them in the application you are using (if it doesn’t pick them up automatically)
Hope it works for you
John

If I understand correctly what you are trying to do, you could try nesting the if statements:

If Not mcr.Name = “AutoexecUpsize” Then
If Not mcr.Name = “BufferAutoexec” Then
DoCmd.TransferDatabase acExport, “Microsoft Access”, DBName, acMacro, mcr.Name, mcr.Name
endif
endif