Search results

  1. sanmisds

    Removing Security

    Hello, I have inherited a database that comes with a 'security.mdw' file. In the past I had joined to this workgroup and hence be able to open the database. Now, I need to send this database to a user who does not have MS Access installed but he needs to migrate this db into sql server. How can...
  2. sanmisds

    Question Sort by ID

    Thank you. I will. I appreciate it very much.
  3. sanmisds

    Question Sort by ID

    Thank you very much. It worked. My code is as you suggested: Private Sub Form_Open(Cancel As Integer) Me.OrderBy = "[ID]" Me.OrderByOn = True End Sub Now I learned something very important. Again, tarcona for walking me along. Appreciate it the most!! Have a great day!! ps. I may have few...
  4. sanmisds

    Question Sort by ID

    I apologize. I am not that familiar with it. So, do I put this code along with the SQL statements I have? Or, how about I add this code? sorry for being so ignorant.
  5. sanmisds

    Question Sort by ID

    The form is populated based on a query. Query is below: SELECT Issues.ID, Issues.Title, [Contacts_Assigned to].[First Name] & " " & [Contacts_Assigned To].[Last Name] AS [Assigned To Name], [Contacts_Opened By].[First Name] & " " & [Contacts_Opened By].[Last Name] AS [Opened By Name]...
  6. sanmisds

    Question Sort by ID

    I have an 'Issues' form. And, I have noticed that issues list are displayed by 'Issue Owners' sort order. I would want it to display by 'Issue ID'. What do I need to do here? I appreciate your help on this and thanks in advance!!
  7. sanmisds

    Append Query to update existing Data

    I am using Access 2003. Thank you.
  8. sanmisds

    Append Query to update existing Data

    Hello Friends, I was having some weird issue of importing data (1591 Rows X 16 Columns) in existing table in MS Access from MS Excel. I made sure my Column headers as well as data types matched from excel to access but some how it did not work. Somewhere in this forum I read where it was...
  9. sanmisds

    Form Controls does not work

    This is the first time I smiled today. At leats I had a chance to see something I would have never imagined to see before. This solved the issue I was having...at least I think so. Thank you very much. I am sure I will have few more questions regarding this until this is done. I apologize for my...
  10. sanmisds

    Form Controls does not work

    Fields and checkboxes does not work Thanks for reading my request. Attached is the sample DB and I have also wrote down the issues in the form. Please contact me if you have any questions. Thanks again.
  11. sanmisds

    Form Controls does not work

    Any one please help. I've been waiting and waiting. Thanks and I appreciate you trying to help.
  12. sanmisds

    Conditional Format Based on Previous and Current Record

    I did. I soon realized that I posted my question in existing thread. Please see below: http://www.access-programmers.co.uk/forums/showthread.php?t=148123 Thanks in advance for your help. This may be is very simple for you but this is holding me up for a while now. Thanks.
  13. sanmisds

    Form Controls does not work

    I am modifying one of the MS Template to fit for my need. I have added few more controls and labels and added those new controls in the related Tables as well. When I go to 'View' mode, I can see my selections but I can not select them. Also, for some other controls, I get '#Name?' inside those...
  14. sanmisds

    Conditional Format Based on Previous and Current Record

    Form Control does not return values I am modifying one of the MS Template to fit for my need. I have added few more controls and labels and added those new controls in the related Tables as well. When I go to 'View' mode, I can see my selections but I can not select them. Also, for some other...
  15. sanmisds

    First timer

    Ahh.....well, I may have a question regarding timer in future. Thanks!!
  16. sanmisds

    First timer

    Hello Administrator, contributors, experts and friends! I am excited to join this blog for the very first time. I am new to MS Access but learning every day and doing very well. I am in process of buiding an Issues list and because of that you will see lot of me with tons of questions. First...
Top Bottom