Search results

Thanks jdraw, I will try that out. If I have no luck I will post some screen shots of what I have and what I hope to achieve. Cheers

Good Evening Jdraw, Yes, I have a Local Access 2003 Database that is linked to excel spread sheets that are updated by users from numerous locations. I have to compile weekly reports from the data complied in those linked tables. One of those reports is a Status report of all engines under 20...

Good Evening All, I have a table that is linked into access 2003. This table is updated by personnel in another location and I have to run a weekly report on engines that are below a certain performance level. The column heading is MGT Margin and I have to list all of the engines that are...

Good Morning All, I have been able to get this form working, but I now to to get additional information from the query onto the main form (AF Hours, date last updated, APU S/No) Can anyone help in getting this data across. Cheers

I have one table the same format to that attached in the first post of this thread. I would like to display the data from that table in the same format as achieved previously. (One Form with 4 subforms, 1 for each engine) I have used the same format as before but can not get any data to display...

Thanks CJ. I might not have been to clear on what I actually want to do know. Previously I was using data from two forms via a query to display data in one form with 4 sub forms. Now I just want to display data from one table onto one form with 4 sub forms without using the query. Can this be...

Originally Posted by awade Good Evening CJ, Thanks for your help the other day in getting my query and 4 sub forms sorted out it has allowed me to display data in a way that has never been seen before on it has impressed a lot of people. Due to this I now would like to display similar data the...

Thanks for the response :( I will just use colours instead..

I have 2 excel spread sheets that are directly linked to Access 2003. These two spread sheets are put through a query to enable the data from both of them to be displayed on one sub form located on a main form. There are columns in each spread sheet that contain hyperlinks. I have the text...

I have tried to change the sub form on its own, and the main form on its own, and the transparent symbol is still greyed out.

I have an excel table that has 16 coloums and 100 rows. in each cell is a number. I have used the =INDEX(MATCH..... formula to allow me to input a number corresponding to the first number in any of the columns (pressure) and using the first number of one of the rowns it corresponds to an...

Does anyone know if the background color on subforms can be changed to transparent? I have a form which contains 4 subforms. The main form has a picture that likes up with the 4 subforms, but when i go to make the sub form background color transparent it is greyed out. Cna this be done, or...

You can probably hear me in the UK now, jumping around yelling "IT WORKS" Thanks for your help with this CJ. Im sure as I get further into this I may need your help with other problems I may encounter. Appreciate all your help and patience. Cheers awade

CJ, I have labeled, renamed, changed all of the parameters as suggested and still get the "enter parameter value" pop up box with no data being displayed in the columns. I have attached some screen shots of what i have done. Sorry, for all of this, but i am very new to access, but thanks for...

Also I am struggling to find what a control is let alone the control valve.

CJ thanks for the info so far. I have dragged 4 lots of the form onto the main form, and I know only have one coy of the dragged forms that I can add information to. the other three "children" are just white boxes, that when I try and drag any information into then it places it on the forma...

Thanks CJ. I keep getting a "the specified field '[Tail Number]' could refer to more than one table listed in the FROM clause of your SQL statement" What does that mean.

CJ, I have managed to get the Query working with the two tables supplying data to the one form. Thanks for that... Please find attached the screen shots you requested. The form screen shot is where i want the positions to display data from 1 through 4 from right to left. This would happen when i...

CJ, from an early test it looking ok. I will just have to play around with formatting to see if I can only get 4 sets of data to display, as it now displays all of the data in one large column. Thanks for all your help so far. Cheers

Thank you for your response. I am having trouble getting it to display the data I want in a format that is required. I apologise but I am very new to access and am still coming to terms with how to get things to work. What I am after is that I have 4 columns each with 10 text boxes. what I am...