Search results

  1. R

    Sorting and formatting a report based off of values and user input?

    Change your tables a little as follows. An employee can work in many departments bur they can only be assigned to 1 time to any department. I assume the competency is about an employee and not a department. Dale
  2. R

    Help on how to concatenate row values using a query

    [cust no] & [Inv no] & [T No] & [Date] & [amount] Note: Remove ALL spaces from your field names. Make Date a date type IF it is a date. Dale
  3. R

    Primary key problem

    I am not sure you need a junction table here. Your relationship should be 1 to many. Animals =Many, species = 1 Animals are part of species, correct 1 Species has many animals. Dale
  4. R

    FYI, New 2013 Access Runtime

    MS has released 2013 runtime. http://www.microsoft.com/en-us/download/details.aspx?id=39358 Dale
  5. R

    Checking for duplicate records

    greenshootProgrammer and RuralGuy, If I may impose here. I do believe that the table ID is text if I remember correctly. Dale
  6. R

    Checking for duplicate records

    ruralguy, I think this post may be related the OP question/problem. http://www.access-programmers.co.uk/forums/showthread.php?t=249438 Dale
  7. R

    Tables and Relations... some advice please

    Khalakmu, Attached is my view of how the tables should be related. The tables themselves looked pretty good. Dale
  8. R

    Have problem with autofill part of form

    Sounds like your Table relationships may not be correct. Please post a readable picture of your relationships. Dale
  9. R

    Table Build Dates

    From what I am reading Access does not store the date the data was changed or added to a table. Access does store the date a record was changed. That appears to be stored with each record and is not a table property. The last update for the table is for the date the structure of the table was...
  10. R

    VBA Function Creation

    For simplicity I would leave the as 2 different functions. Dale
  11. R

    Moving from one record to the next

    Rick, My I ask why you are using a recordset to do this? This should be straight forward with a form if you table structure is correct. Some good reading. http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html and Dale
  12. R

    Field Header in Query based on Other Field Data

    You are doing fine. Been there, Had this done to me more than once. Keep us posted. Dale
  13. R

    Adding a TON of text to a report

    Rick, The dlookup() goes in an Unbound text box. Dale
  14. R

    Form with fixed fields

    I downloaded your database. In the single form you have there "Outcomes For Learners", you want the combo box "Providers" to remain the same after selection until changed by the user. Correct. Dale
  15. R

    Need help creating reports

    Can you strip out the personal stuff and post your data base? If you can just remove the names and addresses. Dale
  16. R

    Link to Table

    Sounds like you table structure is not correct yet. Take a look at the following. http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html Also post your table structure for us. Dale
  17. R

    Dynamically Sort Report That Already Has Group By (XP/Access 2003)

    Just a guess. Look up Report.Section Property. Dale
  18. R

    delete the .00 trailing zeros in price

    Set the Decimal Places to 0. Dale
  19. R

    Field Header in Query based on Other Field Data

    When I see a post with this wording I start to wonder if the tables are correct (normalized). Can you post a picture of your table structure? Dale
  20. R

    Need a "linebreak" in ColumnHistory

    The text box has to be large enough to hold the text AND the NewLine. Correct, vbNewLine and vb CRLF are the same as far as I know. Dale
Back
Top Bottom