Search:

I have a document which, on first glance, appears to contain a number of fields; however, closer inspection reveals the 'fields' are just text surrounded by double angle quotes.

Many of the...

No idea what's going on then. Like I said, if I copy/paste this data into a new workbook, the new file opens quickly as expected.

Just sent it to two colleagues. On one, it opened straight away....

Here you go. This is unchanged from what I received.

Sorted, thank you.

Now I just need to re-write some code. I was writing a string (an access database path) to a custom document property. This doesn't seem to work with the add-in.

I guess I...

There don't appear to be any Links.

I haven't got a clue what querytables are (help returned nothing on that phrase) but I suspect there aren't any.

The user assures me they just typed and...

I've read some of the article. The bit on adding an item to a menu seems to imply I need to write code (copying the example) to both add and remove a menu item. It doesn't explain from where (or...

Doesn't appear so. Biggest is 59kb.

This file took about 10 seconds to open

Thank you, still a bit stuck though.

Right, the original xls workbook has an extra code module containing a single sub (to show my form).

I've saved the workbook as an add-in, opened a blank...

I've been given some filled in spreadsheets which are acting wierd.

For me even, moving between worksheets is slow. Working in the VBA editor is slow and the code I wrote seems to run in slow...

Ok, I'm not very familar with Excel and am a bit confused with where things needs to go.

In my test spreadsheet I have a simple sub in the 'This Workbook' object.

Sub showPlantForm()

...

I am trying to loop through the rows in a selected range.

This works fine if the range is continuous. However, if the range is discontinous e.g.Sheet1!$A$8,Sheet1!$A$10:$A$12 which it will more...

I get what you mean about the table. I really only need to make a new table with 3 fields - the original ID (to join back to the other info), the new ID (with i, ii etc.) and the single requirement....

First I'll have to look for commas. In the example above this would give "THIS" and "THAT and THE OTHER"

Then in the last (in this case second) substring, look for "* and *" to give "THAT" and...

I have table containing information about plots of land, each having an alphanumeric ID e.g. 2a.

One of the columns decribes the reason the plot is required for the project. This may be a single...

If you mean that your questionnaire has more than 100 questions, you might consider a design where each reply is a separate record in a subtable instead of a field in the main table. The subtable...

Some colleagues at work want to start using pocket pc's to collect data. I'm aware there is no 'pocket Access.'

I've been reading about a product called HanDBase which might do the trick but it...

Sorted, thankyou

I have records with a duplicate value.

I need to append these to another table.

I have a totals query grouping by the duplicated values field.

Rather than use First, Min etc I need to...

Thankyou.

I'd managed to find in Excel you use a ~ but couldn't find what to do in Access. Quite surprised I've never needed to do this before.

I have some text (in multiple fields) that contains a leading asterisk( *).
I'm trying to write a function I can use in an update query.

How do I check for the asterisk rather than vba assuming...

It just says 'Access 2003 database' on the spec sheet.

I'm guessing that if I handed over a 2000 format db created in XP that no-one would even notice.

I'm currently using Access XP but every database I create (or work on) is in 2000 format. So far I've had no reason to think about changing this. Most people in our company have XP.

I'm just...

Might just let them have it (with invisible apostrophes) and see what happens.

The trouble is, the overall range that the cells occur in have perfectly valid periods.

I guess I could copy over...

Mike

I'm sure I tried that but could see the apostrophe.

(Edit - just tried again and I can't see it - so far so good)

But, the data will be used in a rather mail merge - would the...

I have some labels in the style 1/1, 1/1a, 1/1b, 1/2 etc.

The data is imported in from Access. I have to add a period/full stop to the labels which don't contain a letter (e.g. 1/1.) otherwise...