Search results

I have a simple form with 3 fields. I am having a problem as the form will not run the AfterUpdate event code triggered in the last field "Date_entered" I suspect the code of the first field "Material_ID" triggered by BeforeUpdate may be prematurely exiting the form??? I can continue entering...

Yes, good to know thank you. Something strange is happening. Hopefully you can explain: When I insert a break point and step through the Undo event procedure, it all works fine without error; However, when I remove the break point and run real-time, I get a run-time error '3059'. "...

It is an Expression in the watch list....Sorry should have been more clear. Need to see it because I'm debugging.

All of the above is correct I did declare a variable as public in the global declarations section public QTY_Requested as integer. Wow, worked it out myself....Should have known. It all works but the only problem now is I can't see the value of the public variable in the watch box. The...

Thank you this works. I appreciate it. I hate to ask this but its been a while since I have programmed. I feel this is going to get complicated.... but I really hope not. Please allow me to explain: The form has 4 fields, in which of course the user can cancel at anytime. The first field...

Hello, my form is opened in "add" mode using a switchboard. The first field of the form calls a VB Sub which makes some necessary changes (based on user responses) in some foreign tables. If the user "escapes" while entering data in the 2nd or 3rd fields, of course after the VB module has...

[Solved] Relationship error 3368 ? Thank all of you for your help!

Thanks, It worked. Needed to remove deleted columns from the Row Source. :)

Now That I have removed the duplicate field names in the Materials Table, all kinds of strange things are happening??? Messages about entering parameter values? Materials_ID (FK) does not not show all of the fields anymore.? Thought I new enough to ask a few questions and get through this...

Pat, You must mean because I have both "Manufacture" and "Manufacture_ID" in the Materials table. I know ! and I am a little nervous because I am not sure how to take the next step.....because I do not have a complete understanding Must I now populate the "Manufacture_ID" FK column then delete...

Yes, Thank you. I posted a question about testing for Nulls on Queries Forum. Not good to test for Null's alone. PBaldy gave me a link to his Website and problem solved just as you have also explained. The test was replaced by the following statement and all works. If...

Thank you pbaldy, You have helped me a lot. My event procedure is afterUpdate and I am having a problem cancelling. I think I'll switch, Will that make any difference with the problem I am having with the IfisNull test failing?

I probably wouldn't ask this question if I didn't have a problem. I am testing text fields that are blank (I think are blank). The watch window shows the variable returned as "" However the IFisNull fails? At first this was all working and the test passed with "" returned. What has happened...

Jdraw or anyone, In correcting the DB relationships, I have jacked up the VB module. I have checked and checked the rowsource pointers, gone over all fields to be sure they have the correct variable type.......I cannot solve. I have attached the DB (names removed to protect the innocent)...

Yes, much better. The major benefit now is I can control the fields that are displayed via the column widths control. Nice! Only problem now is I don't know how to control the actual width of each column from being truncated.

Jdraw Thank you. Based on my posts you may not think I read it but I did. and you are correct, understanding was a issue. I do now understand and have corrected the DB table relationships. Please open and tell me if it is correct now?

I agree and I am currently removing all lookup lists and replacing with tables and relationships. A question about your post and please keep in mind, I don't have enough knowledge presently to explain this completely accurate but will do my best : Am I wrong ? You can not relate two...

Thank you, I solved the problem but I had to do it using the look-up & relationship option on the field pull down window when creating. I could not do it by dragging the PK over to the table as I have done in the past? Anyhow, I agree I simply been a little afraid to break all...

[Solved] Relationship error 3368 ? [Solved] I have done this many times and do not understand why I am getting this error "3368" From Access 2007. I am trying to relate the PK of a new single text field table named "manufacture" to an existing table of materials. Table materials does have...

Thank you, Pat and Doc this helped a lot and is the answer I need.