Search results

Could anybody please help with a problem I have regarding extracting data from 2 tables. I am currently building a database that will allow users to complete their details to enter an event. I am building a register / log in section, a user enters their personal details on the database including...

Could anybody please help with a problem I have regarding extracting data from 2 tables. I am trying to build a database that will allow users to complete their details to enter an event. The way I would like it to work is for the user to register their personal details on the database including...

Many thanks for that, I suspected it would be quite straightforward, but I just couldn't figure it out. Once again the forum has proved to be invaluable. Keep up the good work. :)

I am trying to find a solution to what seems quite an easy task, but it is baffling me. I have a database which provides a manual back up timing for sports events. My main form of timing uses an RFID system, linked to a separate database, however I wish to add the manual back up as extra...

Thanks for your answers to my question. I tried the data entry option and it works as I wanted it to, although I was alarmed when all the previous records seemed to disappear. As I had it bound to a table I realised the records were still there and showed in the table, but now hidden in the form...

The form is in datasheet view, as the rifd is detected and recorded in the 1st field, named "ChipID" the 2nd field, named "Time" automatically records the time and date, keeping a record of which rfid was recorded and when. Many thanks.

Yes, it is a form I wish to open, not sure what you mean by continous form mode, but each entry does go onto a new record. I collect the information from the reader via a piece of software called BC Wedge. This places the rfid identity number into the next available record in the first field...

Hi there I hope somebody can help answer this seemingly easy question, although only easy if you know the answer. I wish to open a form on start up of the PC. This part is simple enough, however I need it to place the cursor in the next available row in the first column. When I open the form...

Hi Jal That is just brilliant, I do appreciate the time you have spent on this problem, I certainly would never have got there on my own, however it has made me more determined than ever to try and grasp the sql language. As far as performance goes, I shall test it with more records, I expect...

What can I say Jal but thanks very much, that is just amazing that you have solved that problem, I shall test it through with a whole load of records and times but from the initial results it seems to be achieving what I wanted from it. I have tried adding the final INNERJOIN statement as you...

I would really like a little help with an amendment to an SQL Query I have. Jal very kindly sorted out this Query for me, which produces one list of recorded times from 2 tables. However, using this method, I have encountered a problem, if the objects were to travel around a circuit and be...

Many thanks Jal That is exactly what I was looking for, it works perfectly. As regards the "date" portion of the datetime field I don't actually have that stored within the database, I can't ever see it being a problem as I don't expect any of the race times would fall either side of midnight...

Yes, that is what I thought, I need to have some way of building the Lap Number column, this has to be done automatically without a user having to type in each lap number. I had thought of using something like an IF THEN statement, stating :- IF RaceNo = RaceNo AND Time > (previous) Time THEN...

Could anybody please help me with a problem I have come across. I am currently working on a project database to distinguish lap times from a bunch of athletic competitors. The database includes 2 tables, namely, Competitors and LapTimes. In the LapTimes table there are 2 fields which simply...

Okay, everything is sorted and working brilliantly. When checking the SQL code I realised that the tables Zone 1 & Zone 2 only have 2 fields each, namely BadgeID and Time, so I simply omitted the extra non existant fields (Zone1 & Zone2) from the code, and hey presto it works. Many many thanks...

I have checked the pasted SQL code, for some unknown reason when I copied and pasted it into SQL view, it replaced the first and last brackets, with square brackets, having changed these back to how your example shows, it now works fine. Thanks very much, I really appreciate you're help. :)...

Hi Jal Many thanks for posting a reply. I have tried pasting the SQL into the SQL view, however when I try to open the query it replies with the following message "Invalid bracketing of name "SELECT BadgeID, Time, Zone1 as TheZone FROM [Zone 1". Not sure what this means, unfortunately my...

Could I please ask for some help with a current project I am working on. The database, named “Zone Detect” at the moment is made up of 3 tables, these being “Items”, “Zone 1” & “Zone 2”. Both tables “Zone 1 & Zone 2” are linked externally via a separate access database. I then use the link...

Hi, I hope somebody can help me with this seemingly simple problem. I currently have a database that keeps a record of competitors details and the results of their performance in a race. I would like to have an option that any competitor can enter their race number into a form. The form would...

You are an absolute star CraigDolphin, I have spent hours trying to sort this one out, with much frustration. I only just discovered the forum a couple of days ago, what a superb source of information. Keep up the good work, you have certainly helped me out. Many thanks. Paul:):):)