Search results

  1. A

    Look Up value in a query

    Can you use the DLookup function to look up a value in a query w/o putting in a criteria? Or is there another funtion that i should use. Have a report that needs a value from a query but it not the record source of the report.,
  2. A

    Msg box when form returns no records

    Paul I was able to get the code to work! I had to make one small change and it seems to work fine, thanks so much for your help. I just changed the . for ! and it worked :) If Forms![Second form name].RecordCount = 0 Then
  3. A

    Msg box when form returns no records

    Yes but i will have to do it tomorrow, please check back then, i appreicate your time thanks
  4. A

    Msg box when form returns no records

    I am sorry i did try the syntax you mentioned, i just typed it wrong in the reply, still getting the same message.
  5. A

    Msg box when form returns no records

    Private Sub Command10_Click() On Error GoTo Err_Command10_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Second form name" stLinkCriteria = "[Person_ID]=" & Me![Person_ID] DoCmd.OpenForm stDocName, , , stLinkCriteria If Forms.[Second form name].RecordCount = 0 Then...
  6. A

    Msg box when form returns no records

    I tried the brackets around the form name and got this error message "Object doesn't surrport this property or method"
  7. A

    Msg box when form returns no records

    Is this the correct way to referr to the other form? If Forms.Second Form Name.Recordset.RecordCount = 0 Then
  8. A

    Msg box when form returns no records

    I have a form with a command button that when clicked on opens a second form. I need a message box to come up when the second form returns no records. I need the code to be on the command button Here is what i have that does not work Private Sub Command10_Click() On Error GoTo...
  9. A

    Open form only if a query returns a value

    Thanks so much John Big Booty, that worked perfect!!!!
  10. A

    Open form only if a query returns a value

    Hello, I am trying to do the same thing but this is not working for me, what am i missing?
  11. A

    Hide control on open

    OK it was a typo, sorry. Thanks so much for all your help, the form works great now. I use the form in two different instances and wanted to hide a few controls in one but not the other so now it works on both! I usually write this in code but for reason i wont go into i needed to put it in an...
  12. A

    Hide control on open

    Did that but it is still visible on open, don't i need to say something to make it not visible? tried [forms]![FormName]![ControlOrLabelName].Visible=False but that didn't work.
  13. A

    Hide control on open

    I have a macro that opens a form but i would also what the macro to hide a control on the form when opened, i think this is possible but i can't remember how to set the value of a control to not visible using a macro.
  14. A

    Update query question

    Right now i am entering the data into the Personnel Actions and Action Details but then would like to build an Update query to the employee table for just those fields that change. Over time the Action Details table will have a history of changes and the Employee table will only have one record...
  15. A

    Update query question

    Maybe I am not making myself clear. Did you look at my attached file? Here is my table structure, as far as I know it is normalized. I want to track employee personnel actions and keep the current information in the employee table. No repeated data here, that is why the Action details table only...
  16. A

    Update query question

    I can’t figure out a way to make an update query to do the following: I have 3 tables, Employee, Personnel Actions and Action Details; I have a form to enter the Personnel Action for an employee but need an update query after the data is entered into the Action Details table to update just the...
  17. A

    Store a history of data

    what would be the best way to keep personnel data and its history? I have an employee table with salary, postion, location etc. and would like to keep a history of changes overtime. So i know i need another table that tracks the fields that change and the date of change. I would like to...
  18. A

    Update query

    Is it possible to create an update query that will only update fields if there is data in it? For example i have a temp table with several fields, i want to build one query that would look at a row in the temp table and update those that have data in them to another table. Right now my update...
  19. A

    Append query

    yes the table is selectable when performing a select query but not in an append query. I finally created a "make table" query and then was able to see that table when creating an append query, very strange! It was just a simple 3 field access table and no it was not linked
  20. A

    Append query

    Why would an existing table in my database not be seen in the list of tables to be appended when creating an append query? I am trying to move some data from one table to another by using an append query but it will not let me select the table to be appended from the list of existing tables! It...
Back
Top Bottom