Search results

Many thanks, as always. The same old problem - if I knew what I was looking for (common dialog) I could've found it myself! Thanks once again.

PS, this is not the "name auto-correct" bug as it does remember margin settings, just will not go as low as zero.

If anyone does know how to override, please tell us. I have a very similar problem, albeit with a mimimum bottom margin of 4 mm (I need zero). It's not that I'm printing in that area, but I'm printing cheques (checks) 3 to an A4 sheet) and the third one insists on going to another page. I can't...

User defined filename for DoCmd.TransferSpreadsheet? My colleagues can't be trusted to import the data into a table using file->get external data -> import! Everything works using: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tablename", "Excelfilename", True But can I get a...

Many, many thanks. I was trying to do it throught the hyperlink properties, but this works very well indeed. Thanks again.

I'm trying in vain to correctly create a hyperlink from a query result. I have a form based on the query result with a command button to do the search using Hyperlink address. I'd like to search Companies House. The URL for a search is...

Here's what I'm trying to do: I am trying to take a customer's mobile (cellphone) telephone number and a text message to create a table that will be exported to our SMS (short messageing service) sending application. When on the customer’s record to whom the message is to be sent, the user...

Many, many thanks.

Thanks Mile-O-Phile. There is a field for each element in both tables. So I really can't see why I'm finding it so hard today!!

Thanks barbarossaii, but it doesn't help much - too many duplicated records. I have got the joins right by the way ;-) Also, the specified criteria would get duplicated this way. So I'd get: Alan Jones, 55 The Street Alan Jones, 55 The Street Bert Jones, 55 The Street when Bert lives at 22...

I have two tables: Table a containing personal details (1000 records) Table b containing some of these people who have done xyz this week (50 records) I would like to run a query to show those in table a whose surname matches table b. So if table b contains: Mr Colin Smith Mr Alan Jones...

Ah, I found this thread. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=41650 Very, very useful indeed. Thanks Pat, and thanks Jon K for that thread.

Thanks Pat. You've been really helpful. I have created 10 append queries and now have a table: Item - Owner - DateTakenOver -------------------------------------------- Item1 - Mr A - 31/10/02 Item1 - Mr B - 01/01/03 Item2 - Mr B - 28/02/03 Item3 - Mr C -...

Hi Pat, and thanks. Yes, it is an inappropriate structure, but I have to work with what I've got; I'm just a junior "tinkerer" ! It has probably been set up this way for simplicity. When a new owner comes along, the user types in his reference and transfer date on a form and the old owners are...

I’m really stuck! I have a table of current and previous owners of certain items. What I have in the ownership table is lots of rows like this: Item - Owner - DateTakenOver - Last Owner1 - DateTaken Over1 - LastOwner2 - DateTakenOver2 - etc.. to Last Owner10 and last date10 Eg Item 1 - Mr A...

Thanks to both of you.

My query concerns editing an Access 97 database in Access 2000. I do not want to convert the 97 database as it is the underlying data behind a commercial application. When I open the 97 db in Access 2000 it reports "you can't make changes to the database objects". All I want to do is to...

Maybe I didn't make it clear? I'd like to subform to always display.

Thanks, but no joy. For some reason when there is no result, the subform does not display. PS The properties for the subform are already set to visible.

I have a subform on my main form that contains one field, which is the result of a query. The subform may or may not, therefore, have content; ie the result may be a number or may be null. My problem is that the subform is only displayed on the main form when the subform has content. Can...