Search:

Type: Posts; User: gheyman; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Access: Close a Form that is not the Active form

    Can you close one form from another? I know you can close the form you're on by using DoCmd.Close , "". How do I close another form. I need to make sure its not open when I run code.

    Thanks
  2. Replies
    5
    Views
    88

    Re: Access: If Statement to Run Macro

    Thank You!

    Is there a way to set the Frame value to 1 other than using the default value?
  3. Replies
    5
    Views
    88

    If Statement to Run Macro

    Kind of an If statement.

    I have an If statement that depending on the results will run one or another Macro. But I get a Debug error when I try to run it. The fist is the If statement that...
  4. Replies
    2
    Views
    120

    Using Toggle/Option Buttons

    I put two option buttons on a form and I am trying to figure out how to use them. Where is the Value stored when one of the Options are selected? I want to use these buttons in an If statement.
    ...
  5. Replies
    2
    Views
    109

    Re: Access: Change Query Sql with VBA

    When the code is too long it can be wrapped with " & _
    Each line has to end with " & _
    qdf.SQL = "SELECT tbl_NIS_TSL.ID_NISTSL, tbl_NIS_TSL.VendorName, tbl_NIS_TSL.VendorID, tbl_NIS_TSL.CityName,...
  6. Replies
    2
    Views
    109

    Change Query Sql with VBA

    This is all new to me. I am reading posts and trying to piece together how you change the Sql code of a query using VBA. Here is what I did - but it does not work. In my code the Line that starts...
  7. Re: Access: A Query that only shows the lastest/Last record for each vendor

    Thank you!
  8. Re: Access: A Query that only shows the lastest/Last record for each vendor

    Thanks, Joe

    Wht if I wanted to group by two fields VendorName and CommType? Is it possible to group by more than one?

    And can you add Criteria?

    WHERE (((tbl_NIS_TSL.VendorName) Like...
  9. A Query that only shows the lastest/Last record for each vendor

    If I had a table with vendor history of each purchase they made (the table has the same customer listed numerous times under VendorName). The table has a "CreatedDate" field that puts the date the...
  10. Replies
    2
    Views
    174

    Advice on best method

    I have a table with about 10 fields. What I am trying to do is keep track of data changes; What changed and when they change.

    I am thinking that when the user wants to change data that they...
  11. Re: Select data (Row) in one table and have it load/add to abother table

    THANK YOU!!
    Form.Requery worked.
  12. Replies
    2
    Views
    171

    Re: Access: Adding Username to Append Query

    Thanks
  13. Replies
    2
    Views
    171

    Adding Username to Append Query

    Is it possible to add the User Name to each record that's being added to a table? I am using an Append Query to add the new record(s). I thought I could create a field in my query to do that, by...
  14. Replies
    3
    Views
    345

    Re: Access Split form Refresh Problem

    Tried both, neither worded


    Private Sub Command29_Click()
    On Error GoTo Command29_Click_Err

    DoCmd.SetWarnings False

    If IsNull(ComboVendorASL) Then
    DoCmd.GoToRecord , "", acNewRec
  15. Replies
    3
    Views
    345

    Split form Refresh Problem

    I have a split form based on Table. The below code runs an append query that updates the aforementioned table. My problem is that after the append query is run, the Split form does not refresh to...
  16. Re: Select data (Row) in one table and have it load/add to abother table

    Private Sub Command29_Click()
    On Error GoTo Command29_Click_Err

    DoCmd.SetWarnings False

    If IsNull(ComboVendorASL) Then
    Else
    DoCmd.OpenQuery "qry_vluVendor_MakeTable", acViewNormal,...
  17. Re: Select data (Row) in one table and have it load/add to abother table

    Here is where I am currently heading;

    I put a Combo box on my form. It is tied to the ODBC Table. I created an append query where I am using that Combo as a Criteria in the query. So the...
  18. Select data (Row) in one table and have it load/add to abother table

    I have data in an ODBC table. What I need to do is when someone selects a record in that table, have it automatically load data from that record to another table.

    Not sure where to even start or...
  19. Replies
    1
    Views
    221

    Re: Access: Query criterea based on Form Value

    After closing and saving the database - this now works. Thanks
  20. Replies
    1
    Views
    221

    Query criteria based on Form Value

    I have a query that I want to have a dynamic criteria based on what someone selects in a Combo Box on a form (the Combo is in the Header Section)

    Like [Forms]![frm_Add_Supplier]![ComboVendorASL]
    ...
  21. Replies
    2
    Views
    254

    Re: Access: Add AutoNumber firld to a Table using VBA

    FOUND THE ANSWER: CurrentDb.Execute "ALTER TABLE tbl_vluVendor_MakeTable ADD COLUMN ColumnName COUNTER"

    Thanks
  22. Replies
    2
    Views
    254

    Add AutoNumber firld to a Table using VBA

    I a MakeTable Query. I want to add an AutoNumber field to that table after the query is run. Is there a way to do that using VBA?
    tbl_vluVendor_MakeTable

    FOUND THE ANSWER: CurrentDb.Execute...
  23. Replies
    1
    Views
    297

    Combo Box with only unique values

    I have a combo box on a form. It is based off a query

    SELECT [qry_vluVendorAddress].[VendorName], [qry_vluVendorAddress].[VendorID], [qry_vluVendorAddress].[CityName],...
  24. Thread: Access

    by gheyman
    Replies
    1
    Views
    355

    Access

    Can you use VBA to Filter a filed in a Query

    I have a Query (qry_OnTimeDelivery_MetricData)

    I want to Filter Field: "MONTH0_Active" to the value "1"

    I want to do this from a form using a...
  25. Replies
    1
    Views
    517

    IIF statement with an AND and an OR

    Is this correct?
    MONTH1_PDL: IIf(((DateDiff("m",[PDIR Due Date],Now()))>1) And ((DateDiff("m",[PDIR Completed],Now()))=<1) Or ([PDIR Completed] Is Null),1,0)


    I need the first condition met and...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4