Search results

This is did it for me.... INSERT INTO CompletedTraining ( ObjectiveID, EmployeeID, PreceptorID, PreceptorDateCompleted ) SELECT Forms!frmCompletedTraining!lstObjective AS objective, Forms!frmCompletedTraining!cmbEmployee AS Emp, Forms!frmCompletedTraining!cmbPreceptor AS Trainer...

yeah....so when I "unbound" the other text box, nothing updated or was added. I'll go back to square "0" and try another method...after all there is more than one way to skin a cat. right? Thanks! Larry

Thanks Bob! but that didn't work either. I tried: f.PreceptorDateCompleted Forms!frmCompletedTraining.PreceptorDateCompleted any other suggestions? I am thinking of just re-writing it using an INSERT INTO query if I can't get this to work. Larry

http://www.access-programmers.co.uk/forums/forumdisplay.php?f=64

I am having a similar problem but only one of my fields isn't updating to the table. It is the date field which an unbound text box. Could you take a look and give me some direction on where to go? The PreceptorDateCompleted is the culprit. I have everything spelled the same as the unbound...

Bob Thanks for the help and understanding my confusion.... :) I found an updated version on here from the creator...and it seems to be working fine. Thank you again!! You are on of the best teachers I've had on MS Access! Larry

So why would it then put a January date in the table and show a January date in the unbound field of the input box? and you're right...I am confused! :)

It is somehow "supposed" to be used in the Function send to inputform...but I don't know what mynum is supposed to be. if you click on a calendar box it pops up with a January date...Where is that date coming from?

Thank you! I think I am on the right track now....I'll let you know when/if I have trouble. Larry :)

Hi all, I am having an issue trying to debug this function. I downloaded a database from Microsoft and I am trying to implement into another database I am creating. This DB works okay but it isn't showing the correct date on the "frmInputBox". There is a varible named "mynum" that is in...

Not to be that guy or anything but could give me an example? should I completely take out the NOT IN() sub-query and do another query? Larry

Hi all, I have a list box based on a query. I want this list box to NOT SHOW items in the list that have been completed for that particular User. I can get the list box to show what I want (sort of) by using the NOT IN () sub query. However I want the list box to show all the records for the...

Try this site. It hasa all the goodies on it. :) http://www.lebans.com/reporttopdf.htm

Then you would need to have like the main form and some sub forms which would be linked to the main form. What fields are you wanting? Could you list your tables and PK? or even better a sample DB?

dbDamo hit right on the head. This forum is great and I know I've learned a ton from here. These guys are always happy to help. I don't think we're giving up on you, just want some you to do some research and education first. LWC

OOOOO....that is a sweet site. consider that one saved for me too! :D Thanks John! LWC

Try something like forms!formname.controlname.setfocus instead of the goto control command.

I believe you would need to create a query with all fields you want in it and use that as your record source.

Is your form based on the query? Go to the properties of the form, check your record source. It should be that query correct? Then on design form you can hit the button that shows you the fields and drag that field over. LWC

Is your form based on the query?