Search results

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

When I wrote the code it comes up with a Compile Error saying Expected: end of statement with my table name highlighted.

Thank you I appreciate your help. I will try it.

Would I use the insert into command?

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...

Okay thank you!

I want it to bring up the selection of project number and then the next one to bring up the given drawing numbers for that selected project number.

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...