Search results

  1. M

    SQL INSERT -- asking for parameters when executing?!

    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...
  2. M

    Setting Yes/No value through code.

    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...
  3. M

    Select a Datasheet Row -- Populate a 2nd SubForm based on that row?

    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...
  4. M

    Querying a SubForm with a MANY to MANY relationship with MainForm

    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...
  5. M

    Opening Form2 with Data related to Form1?

    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...
  6. M

    Concatenating Fields defined as qryQueryName.ColumnName?

    Hi I did a search to no avail... I am trying to concatenate Address fields into one text box. The Control Source pull-down menu gives me the Field Names listed as QueryName.ColumnName. I know that if they listed the fields as just ColumnName, you'd simply go: ColumnName & " " &...
  7. M

    Multi-line scrollable text boxes??

    Hi All, I'm a noobie with Access, and on my form which displays Account information, I also want to display the multiple Addresses this account can have. I can't find any type of scrollable text box (something to look like a spreadsheet), and I know it's not a list box I need to use. How do I...
Back
Top Bottom