Search results

This is definitely the solution I'd recommend -- this took me 5 mins, she works perfectly :D :cool:

FIXED :) You need to put "" around the text field values to act as a regular double quote -- I was thrown for a loop since my serial number is a text field, but this value was all numbers. Well, maybe this will help any other newbies like me ;)

Hi all, I've searched for a solution, and the proposed solution didn't work for me. I am executing an SQL statement to insert values into a History table when deleting a value in a subform. Two of the 5 values are asking me for parameters when the SQL executes and I cant figure out why! The...

Awesome thanks, that worked :D So, now I guess it's as simple as linking the Machine subform to the txtLink field?? I'll give it a shot. edit: This 2nd part worked too -- whoo hoo -- thanks again RuralGuy, you're a life saver! Mike

Still doesn't work for me, I have it laid out as you instructed. I did attach the DB -- the Form is frmAccount, the txtLink is in red and the subform it should reference is right above it called "Customer Addresses". Can you see what the issue is?? Thanks again for any help! Mike

yes, typo -- whoops, they are the same name, just the _Sub part. I'll try the above then let you know how I make out :)

Does it matter if my Source Object and Name have the same name for that subform? the name for both is frmAccountAddresses_Sub. So, the text field on the frmAccount is mapped to frmAccountAddresses_SubObj.Form.AddressID the frmAccount has the 2 subforms on it: frmAccountAddresses_Sub...

I've given this a quick try, but am having difficulty mapping a text field on a form to have a value of the subform on it. I've given this txtLink's Control Source name of: frmAccountAddresses_Sub.Form.AddressID where "frmAccountAddresses_Sub" is the name of the subform where I want to...

Thanks for the tip RuralGuy, but that doesn't work -- Access wont allow me to type that path into the Link Master Fields -- you need to choose from a list only. Both subforms are based on queries, and I tried to put some logic in the WHERE clause of the Machine SubForm like: WHERE...

This has to be a simple solution for you gurus. I need to reset a CheckBox flag on a form after a business rule is carried out. I noticed the check box gives the value -1 for Checked, and 0 for Unchecked. So, when the box is checked, I want to clear it after carrying out a business rule. The...

bump -- anyone have an idea??

Hi, I'm not even sure if this is possible to do (I havn't found anything on the Net yet), but I have a Form displaying Customer information, and the vending machines that customer has. The main form (frmAccount) has 2 SubForms: 1) AddressSubForm (is a Datasheet), listing the many addresses the...

Good point Pat, thanks. I actually realized that yesterday, and am changing my Address to one to many -- its only a rare case that an address will have 2 accounts... I'll check your example too and respond if I have any more Q's. Thanks again, Mike

Hi, I am assuming Access cannot handle Many to Many relationships very well. I have an Account form ("MainForm") with an embedded SubForm that displays only the Account Address with suite number, street number, street name, street type. Account to Address is a Many to Many relationship. My...

This worked for me :) Thanks RV, Scott and others for taking the time to lend a hand to a useless newbie! Mike

I've tried all these solutions with no luck :( I also cant find this OpenForm wizard, when I add anything to the Events it makes me manually type the VB code. I have attached my DB file, if someone had time to take a quick peek -- its a very simple app. The frmAccount has an Update Address...

Form1 stays open, I just dont know the syntax to put the variable name in the WHERE clause of the query, if that is indeed how I'd do it. Form1 is based on a table, and Form2 uses a query, if that changes things. (I'm new to Access and VB, so forgive my ignorance :)

Thanks Scott, But now when I open form2, the form is blank -- i'm assuming the query on form2 cant see the value for =Forms!form1!txtAccountID What is the syntax for me to msgbox the value of "=Forms!form1!txtAccountID " to find out if it is indeed null? I should note that I have the...

Hi, I've searched but cant find the answer, I have an Account form (Form1) and it displays account information along with their many addresses for the account (in a datagrid embedded form). I hit "update or add address" button to launch form2 (Address Form). From this point I want to query...

Great thanks! :D This is my first Access project... normally I do just oracle stuff, but never any forms work :rolleyes: