Search results

attached is a word document that has screen shots of the two linked tables, "DATAEXPORT_5" and "Accumulative km"

Uncle Gizmo, thanks for your reply. Both tables "Accumulative km" and "DATAEXPORT_5" in my original database are linked tables to excel files, so there is little I can with them, only for the purpose of posting sample1 DB I have made them normal tables. I have attached a screenshot of one of the...

Hi all, I'm not sure this post is in the right category, but here goes! I'm still getting to grips with Access, so please bear with me. I have form "front page 2" from which I can select 2 numbers from 2 combo boxes. The 2 combo boxes refer to the 2 halves of a train, known as north and south...

thanks for your interest. The original data comes from table DATAEXPORT_5 which in my database is a linked table. This table gives the km for a given wheel position on a particular date including wheel diameters. As I tried to explain in my original post, all I am aiming to do is reduce the...

jdraw, thanks for your reply. As an overview, I work for an underground train system, where part of my job is to be able track and monitor wheels fitted to any train in the fleet. Each train consists of two units, and north end and a south end. North end units are numbered 02 up to 94 and are...

I have a database that is used to track wheels fitted to trains. each train has 32 wheels. At present I have 32 queries that give me the data for each wheel position in a particular train, I then have a further 32 queries that use the DMax function to return the last record for each wheel in...

Thanks ridders, so simple when you know!

I have a combo box where users can select from one of a number of even numbers, located in a table. The problem is users can also type a number into the box, they could by mistake enter an odd number, which would return incorrect data. My question is, is it possible to add a clause somewhere in...

Thanks Mark, so obvious when its in front of me.;)

Hi all, This is a follow up from a post I made some time ago. On a form I have a combo box that gives me the option of selecting from one of the next 5 Sundays; Private Sub Form_Open(Cancel As Integer) Dim I As Integer cboSundays.RowSource = "" For I = 1 To 5 cboSundays.RowSource =...

Thanks, CJ_London, it makes a lot more sense

Evening all, I have a form training_edit_dates1 that allows me to add training types and dates for each operator, which is then saved in operator_training1. When a training type and date is added for a operator I would of thought the field trainingtypeid in operator_training1 would show the id...

ridders, you are a genius. This is exactly what I need. Many many thanks

Gasman, thanks again for your input. I have just double checked the last record in the table, it does open as expected from that table. The Google record now opens as I have added the http:/ etc. I will search this site as you suggest for other options. As a last resort I will create a number of...

Gasman, thanks for your reply. I have added third entry in the table for a file located on my PC. the combo box is unable to open this one, could you please enlighten me. Many thanks

Hi all, I have a database in which I require the users to be able to access risk assessments on the company's server. To do this I have a form risk_assessments, with a combo box. This combo box needs to list the refno and risktype, but not show the actual hyperlink. I have attached a db, with...

Thanks for your help, I have tried all the suggestions but unfortunately the problem of not updating the required still exsists. As a way round it, I now access operator_details whilst either of the 2 forms are closed. This then means the updates take place. Although not what I was after, it...

Thanks MarkK, I have tried your suggestion and it seems to give the same result, ie I have to close the form operator_details twice for the change to take effect on the forms that are being refreshed/requeried. As I'm an absolute beginner at VBA I'm at a loss as to how to resolve this. The code...

just a follow up on my post. I have applied a similar code to requery another form, so that the signin form is updated from changes made to operator_details form. The peculiar thing is that the changes only happen if operator_details is closed, then reopened and then closed for a second time...

moke123, thanks very much for the code, works a treat.:)