Check InOut Equipment - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Check InOut Equipment

James Hopkins

3 years ago

Hey, I have a "Equipment Usage Form" where I can Check-Out Equipment. I was wonder if there's an way that you could select to assign the Equipment to: "Employee or Crew" and then save the Data in a Table.

	Alex Hedley @Reply 3 years ago
Manage Rental Inventory

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago

	Richard Rost @Reply 3 years ago
If you're just inserting one record, you don't need a SELECT statement inside your INSERT. Just insert the values themselves. Access Developer 2

	Alex Hedley @Reply 3 years ago
Example `"INSERT INTO Employees " _ & "(FirstName,LastName, Title) VALUES " _ & "('Harry', 'Washington', 'Trainee');"`

	James Hopkins OP @Reply 3 years ago
If I have an "Employee Combo Box" and a "Crew Combo Box" to select which one to Assign Equipment. What is the best way to get this done?

	James Hopkins OP @Reply 3 years ago

Kevin Robertson @Reply

3 years ago

This line is missing info:
If EmployeeID = 0 Or CrewID = 0

Check to see which Combo Box has a selected item to determine which value to use.

If IsNull(ListEmployee) Then

   S = INSERT INTO statement for Crew - set EmployeeID to 0

Else

   S = INSERT INTO statement for Employee - set CrewID to 0

End If

In the After Update event of each Combo Box I would set the other Combo Box to Null so only one can have a value.

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago

	Richard Rost @Reply 3 years ago
Msgbox S. James you need some basic SQL lessons. Access SQL Seminars

	James Hopkins OP @Reply 3 years ago
Thanks, will do..

	James Hopkins OP @Reply 3 years ago
Thank You Guys for your help. I see what I did wrong. Thanks Again!!!

	James Hopkins OP @Reply 3 years ago
Hey Guys, sorry keep asking. I got the Data Values from the "Check-Out Equipment Form" to insert into the "Equipment Usage Table" but I keep see two entry inserted into the table.

	James Hopkins OP @Reply 3 years ago

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View