Hi Rabbie,
Thanks very much for that. The number of notes won't be a problem in this case - the one with the most is 35 and on average it is less than 10.
Just on the xml option - am I right in saying its not really possible to get it to show many notes for each customer? This is what I get...
Hi all,
I have a table called Customers and one called Notes. The Customer has a CustomerID. This is the fk in the Notes table. The Notes fields include NoteDate and Note (which is a memo field).
I need a query which will display the data as follows:
CustomerID | NoteDate1 | Note1 | NoteDate2 |...
Automatic Repair and Backup
Hi,
I have been working on this more recently so thought I would post the code as it is now. It may help someone else:
Option Compare Database
Option Explicit
'Needs reference to Microsoft Scripting runtime
'Needs reference to Microsoft Jet and Replication Objects...
Thanks for that Dennisk. I did try your suggestion and I was able to import it fine.
Anyways I just found the problem - there was a combo box in the report - its rowsource was a look-up table. I changed it to a textbox and changed the underlying query to include the data from the lookup table...
Analyze with Excel doesn't work when tables are linked!?
OK - I am going to list the steps I took.
Ok I tried doing this in VB instead using the following code:
DoCmd.OutputTo acReport, "Job Numbers and Positions", acFormatXLS
First I was getting strange errors like "2455 You entered an...
I'm actually having the same problem. I can click Analyze with Excel with any of my reports except this one.
Its only 6 pages long and is based on a query. Going to File/Save as and trying to export it to Excel doesn't work either.
I don't get any error message - just teh screen flashes up to...
Hi,
Most of my users use Access 2003 and there are no problems with it but one user has Access 2002 and when he goes to open a form thats already open it crashes the database.
Basically I have a continuous form with a list of instruments and when the user clicks on the button beside one it...
Thanks for that Pat.
It was happening even if you only changed the data (i.e. without changing column widths or sorting or filtering). I've created forms for most of the tables now though.
Thanks,
Rcurtin.
Thanks for that Treason.
I would have thought it wouldn't ask you to save tables when you open them in data view and you do not have Open Exclusive permission.
I will do as you suggested and create forms.
Basically I have a secured split database. Each user has a copy of the FE on their local drive and the BE is on the server. I have 2 main user groups: FinanceUsers and purchasingUsers
Both groups of users edit data directly in the invoice table ( believe me it was not my idea - I am slowly...
Hi RG,
I see what you mean. They must have become aliased when I exported it to the new DB.
I don't know why it didn't work originally but it does now so I'm happy. It was a very long list for my users to be scrolling thru.
That is perfect RG. Thanks so much - I was trying to do that for ages. I didn't know that having an index in the table had anything to do with it - I was sure it was a property of the combobox.