Search results

@The_Doc_Man, CheekyBuddha and Gasman: OK, i finally got to taking a look at the ".Form." confusion i had, and man, do i feel stupid. Thank you very much to directing me to have a look at what the construct was. When i clicked on the container border or the actual form corner, plain as day was...

Uhg. Thank you, once again, "Doc", cheekybuddah, and Yes SIr Glasman! I am starting to get a feel for the model you are describing (i model things in my head to try to understand structure, order and how to manipulate, but i could do so a lot better when i was younger). I am going to read...

Thank you, i apologize for my lack of clarity! I try both ways when i run into any error, omitting .Form. and putting it in. I am absolutely clueless as to when it is proper to use it other than if either including it or omitting it solves a problem. I know that is pretty lame, but i am not sure...

And now i am honored to be able to thank everyone! Properly placing the portion (too many words starting with a "p") of Form.Recordset.RecordCount in the Load event of the Parent form returns a viable value (with modification, actually for two subforms present) that gave me a working solution!!!

Well, i have put the initial verbiage into an image so we can see if that helps: Edit: I had to delete the link you had in your post that was copied over to my response... No, that didn't. I will try deleting part of that which you wrote... Private Sub AmountCharged_Exit(Cancel As Integer)...

So .Form. only comes after a control? As i honestly have no clue, i've just been sticking it in here and there and alternating whether or not i include it by if the compiler or runtime complain!

I turned on my house front monitoring cameras to watch for moving person. Takes up a screen though, but at least i still have another...

Well Hi there The_Doc_Man! Do you do this 24/7??? Parent: frmOrderCreate Child: frmOrderAddEquip Control (textbox that relies upon a record): GrossEquipmentCost other control in child form being used to test: EquipmentRowCount That last one should be renamed EquipmentRecordCount (It's only since...

Many thanks! I have to break away for a while - moving company about to be here to give an estimate (here is some hate speech: I HATE the process of moving), but very much looking forward to working with the info you folks have graciously provided!

OK! So how do i test for that? I was trying to overcome this possibility by including a textbox that would display the record count, but i find that not only if there are no records it, or at least my implementation of it, also is blank and generates the same error. As the Control Sourse for...

Many thanks! Unfortunately btdt. Also throws the "no data" error!

This is correct in that at this point there is no data in the subform, only labels and the like, but how do i test if there is no data? Since other methods throw errors i would expect that IsError would result in True, but it comes back False. I might be implementing wrong as i predominantly...

CECo is declared as Long Yes, we have a parent-child relationship. The parent is frmOrderCreate. The child is frmOrderAddEquip. GrossEquipmentCost is a field in a continuous form that is showing as a record with empty fields because it is the first record to be input for the account. I also...

I have the following assignment in VBA though the Assignment itself probably doesn't matter (GECo is a declared variable. Trying to assign it the value in the textbox GrossEquipmentCost when that value exists) : GECo = Forms!frmOrderCreate!frmOrderAddEquip.Form.GrossEquipmentCost The issue is...

@Gasman - we're mixing messages here! The "it'll take a little time" one was my letting the guy know I was going to reconstruct the full statement (which actually took very little tone and I achieved it first try due to all the practice I had over the day!), and my discovery of the final error...

Ummmmmmmmmmmmmmmmmm, hello everybody, and so much thank you; i can not thank all of you enough for coming to my aid. In my last test putting TIMESTAMP in brackets, i saw where i screwed up the line of SQL elsewhere. Although i still have to recreate the entire line, the test segment finally has...

@ plog: I suspect progress. We've gone from a generic syntax error to @ theDBguy: You are welcome to take full control, but i must warn you i am very hack in what i have been doing. The project is close to final testing, the actual full SQL got blown away about ten minutes ago when Access...

Almost anything i write is being kicked back as resembling SPAM too much!

I tested it using VarType() It comes back as a 7... I tried to provide the MS table to evidence a 7 is a date, but this system is suggesting my post was too spam like...(???)

Perhaps (Well, certainly) not, but when i run CurrentDb.Execute "INSERT INTO tblAddress (IDCustomer) VALUES(" & IDCustomer & ");" that does what it is supposed to do without error! And yes, i know that one does say "CurrentDb.Execute, but i did switch back and verified with DoCmd.RunSQL (I...