Search results

OMG, that worked a treat. Thank you sooo much. You have saved me hours and headaches. :o

Hi Paul well, that's not a bad Idea. How do I do that? How do I capture the login on the log in form and use it as a value in a field when a new entry is made?????

Mike I didn't make my comment to be anti-homosexual. And I don't want my addition to this thread to be taken as such. Natural selection, as a phenomenon in its own right, by it's own volition, operating at a level outside of our control,,,,,,would have eradicated the gene. Homosexuality...

yes, you are correct. If not genetic, then the factor, or trait cannot play a role in natural selection. But the G&L community are trying hard to get it proven than their preference is in fact genetic rather than something they choose. So, pre-supposing they are proven correct, then, we...

I have a database that I have developed for the management of health and safety on an industrial site. It is split. I have developed a log in screen to keep unwanted people out. There is also a reminder's table that serves three tables - Contractors, Accidents and Employees. You will see...

Hi there. Interesting thread. Natural selection? Homosexuality is the conundrum for the Natural Selection theory, and, the reason for my rejection of the same. Natural selection would have eradicated the anomaly as being useless to its purpose. Yet, throughout recorded history...

Yes, macro's may be the issue (level wise). However, I've heard that when you make your DB for the web, vba code is not helpful. I have to do more research on this, but.... any comments?

Thank you all for your answers. I'm going to be working on the DB over weekend so shall post feedback on the results. Many thanks for taking the time to help me. Alastair.

Hi there CJ. Thank you for taking the time to reply. So is it: [Forms]![mainformname]![Subformname].[form]![secondsubform].[form]![Control] Because, if it is, access wont show me available controls after the last .[form]! and if I just type it in, it doesn't work. Thanks in...

Database help needed. Ok. Putting it out there. I need some help. I've googled till I'm blue in the face - literally. I have a sub form within a sub form and I need to reference a combo box on the sub form. Access only seems to write to the first sub form level. Here's my syntax...

Hello I am building a hazard management data base for health and safety. I'm not sure If I'm using my junction table correctly. The tables are for Job Safety Analysis to assign risk,harm and control. Here are my tables. I've attached the DB also. (table) JSA_ID PK JSAtask (table)...

Hi I've given you a copy of my Database. If you look at relationships you'll see the main tables Hazard class. Join. Specific hazname. Control data. Control is a sub sheet of specific. One to many relationship from Spec to Join and From Haz Class to Join. Join contains other data like...

thank you for your reply. not sure If I understand. By (dubform) I take it you mean sub form? I'm going to back up a bit. I have an employee's record form. To make it smaller and manageable, I put the fields (or controls). onto separate tabs. The main body of the form hosts buttons for...

I have a tabbed form. It has 6 Tabs. It is based on my employee's table. Each tab captures various bits of info on the employee. If you move through the controls on each tab (Name, middle name, first name) using the Tab Key (as in doing data entry), it defaults to new record rather...

Really enjoying being a member of this forum. I've learned so much and, I'm really amazed that people with all this knowledge want to help others like me...awesome!!!

My report produces multiple copies of the same record. I know why, but don't know how to fix it. I'll explain from scratch. EmployeeTable. With a one to many relationship with TrainingTable (via employee PK as FK in trainingtable). Training table has a one to many relationship with a...

Can someone please have a look at my table structure and tell me if I'm on the right track. I have 4 tables. Each table has a relationship (one to many) to the next, cascading downwards if you like. Part Section Sub Section Sub Sub Section I think I've got FK right. I.E Section has...

you're a champion. many thanks. I'll have a study. You OK if I ask further questions if needed?? Best Regards, alastair.

And yes A Code (don't like that word - but i've used it for the DB) or module may have quite a number of procedures that need to be broken down into more than one training session. Some of our refrigeration parts we make have three or four separate phases, each with procedural steps. 1)...

Hi Yes. Generally a training session would be to cover a Code (say) Galv01 for instance. Each step would be covered in that session (each procedure). However, in saying that, competence may not be reached from that training session and the training may be repeated until supervisor is happy...