Search results

I believe the code needs to be on the Onopen event of your AddItems form.

Take a look at this code RuralGuy helped me on a while back... Does what you want I think..... http://www.access-programmers.co.uk/forums/showthread.php?t=96783

Just have two things to add... You might consider writing it as a function. Then call it from your Before update. This way you could use it on multiple forms if needed. I have also found it is much easier to alter this standard code just a bit to make more sense to your users.... When they see...

Your actually just opening a linked form......... Dim stDocName As String Dim stLinkCriteria As String stDocName = "Add Items" stLinkCriteria = "[SupplierID]=" & Me![SupplierID] DoCmd.OpenForm stDocName, acAddForm, , stLinkCriteria Try something like that....... should work.

I'm rather curious about the first part of your statement.... "I have a database and have to create forms for data entry. However, I have been informed that having the controls bound to the fields in the tables is out of the question." How is your information being saved into a table if not...

Are you sure you put a "label" on the switchboard and not a textbox??

Might also be a difference in UK and US....But ask 10 lawyers and you'll get 10 different opinions.... I would interpret "terms and conditions" something agreed upon in a purchase.. therefor dealing with a contract... You buy this or use this then you agree to these terms..... a...

I agree with the guys here... Also had years of copyright experience with music. The date of copyright is the date of creation. I would always fill out the paperwork even thou I was told that there is a valid copyright on a work from the date of publishing...Better to have the paper backup.... I...

I just had a post with similar problems with subforms... Take a look at this DB and see if it might help you with your problem.

Looks like I might not have a choice! :) Don't want an app that works on some machines and not others... Thanks for the help.

OK Mr B.... That one "kind of works" here..... After I add a new image all the records show the same image... needs a refresh someplace I guess..... But again... ALOT of code for a very small order....... The code for the original was very small..... I liked that. After looking at my machine...

Just checked my 07.....same error... cursor is not in field until you click the mouse once... anyplace... :confused:

That is strange..... I was just looking what is on mine...actually I'll need to check 2, it acts up on my Computer at work also..... Both are using 2003, I also have 2007 on this one... Looking at the other part...... .Net Framework 3.5 SP1 and .Net Framework 2.0 Service Pack 2, and .Net...

Seems like ALOT of code for something that should be easy to fix!!! I'm going to keep searching.... maybe I can locate something.

It's a textbox... and it is enabled...

Anyone have any ideas on this????

Well Wazz.... Still not working in mine.... It puts the "dash" in..... but I did that just to see if the textbox would take input... but you still have to click anyplace on the form before the cursor appears in the Image description box.....And THAT is what I am trying to make happen.

OK, after searching for hours and trying everything I can find I think I'll post this...... Can't remember who posted this originally... But I only added a couple of things.... All I am trying to do is get the cursor into the "Image Description" field after adding a new record..............

Doesn't work there either..... From my searching it looks as if it would be some "Syscmd" code...... Just can't seem to find anything that works.....puts the focus back on Access.........:confused:

I think I know now the problem, but not how to fix it...... When the focus is taken from the Access form to the dialog box, it never returns to the form..... therefor it won't set focus to my field. Being that the dialog box is not an Access dialog box, how do I set the focus back to Access and...