Search results

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...

Its numerical - a long.

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.

Was it just adding an index to the teble or did you do anything else? (Had to kick users out before I could add index to table in BE)

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.

Yes - I'm just trying to get it to scroll to the entry. I've attached a cut down version. Thanks so much for your help.

Hi RG, Thanks for the suggestion. I had tried that but it didn't do the trick. AutoExpand is set to yes.

Hi, This is the source of the combo box: SELECT M_RequisitionOrders.ReqOrderID, M_RequisitionOrders.FieldReqNo, M_RequisitionOrders.OrderDescription FROM M_RequisitionOrders ORDER BY M_RequisitionOrders.FieldReqNo; The bound column is the first one. However, I would like users to be able to...

Basically you would put an unbound text box in the page footer or the group footer section of your report. Example: I will assume the field you want to add is in the detail section of the report and is the name of the text box is txtExpenditure. -You just go to the page footer section and add...

Hi, I am trying to put 2 columns in a report as in the attached word doc. Its not working tho - the second one just appears below the first one. Here are the settings I've applied: I went to page setup and changed the number of columns to 2 and the width of each column to 11cm.The total...

I have written some code to write the text from column(1) of combo boxes rather than their value to the log: http://www.access-programmers.co.uk/forums/showthread.php?p=540871#post540871 Many thanks to Ghudson and to Uncle Gizmo for the code.