I got my insert into working perfectly so i'm just going to stay with the unbound form. Next time, if there is a next time, I will definitely do a bound form.
I have done a search and my cascading combo's are working fine in my unbound form which is what I'm planning on using. I am working on making the Insert Into command work
I am trying to figure out Insert Into in my form when the submit button is pressed. I have an unbound form and I can't find a way to make a bound form work. I spent minimal time creating a bound form to the table I want to send information to but I could not get the cascading combo method...
Well I'm having trouble with the code, not to surprised. If I can use this as a bound form I'm not sure how. First I have a project number pulled from a query in a combo, then I have a cascading combo to pull out the project team which ever project is selected. They select their name from a...
This is what I typed up Code:
INSERT INTO WorkDone (ProjectNum, DrawingNumber, Revision, Name, DateofWork,_
HoursWorked, Task, WorkDescription) select ProjectNumTxt,_
DwgNum, RevNum, NameTxt, Date,_
HrsWorkedtxt, TaskTxt, WorkDoneTxt
I do know how to work with forms and tables. This is the last step of the project, I just needed a little help in the right direction to get this information put into the table and clear the form. I already made the unbound form and it works perfectly except for my submit button haha. Any...
I have a form that has users name, project number, date, task, drawing number, revision number, hours works, and work done. I was trying to figure out a way to put these fields in my table called work done when the submit button is clicked. Also, after it puts this information into the table I...
How can I create the code for a simple drop down list. This is exactly what I'm looking for but have no idea where to start with it. Any point in the right direction would be greatly appreciated.
I was assigned a project to track who did what to certain drawings. I initially did it in excel because it was a small project and I knew that excel could do it. Now that it worked well I was assigned to expand and create it in Access so we can track work done to drawings from more than one...