Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cas20002000

    VB Trick

    Shift+Click to close all nested explorer windows on the windows desktop: alt+enter to show the properties of the icon :)
  2. cas20002000

    Save an Edited Record to another Table

    You mentioned Access 2003. Have you tried to use triggers? Carlos
  3. cas20002000

    Corruption in Access 2003

    Only the frontend gets corrupted. I need to start reading about ADP's. Thanks again...
  4. cas20002000

    Corruption in Access 2003

    In the beginning, I moved the tables from Access 97 to SQL server because of the same problem, we were loosing too much data. It was the easy way out. Since I moved the data to SQL server (using Access 97 as the front-end), I got 0.001% data loss. All of this started with just a couple of users...
  5. cas20002000

    sum function in access form

    Sharon, Try the following: =val([Jam])+val([Pepper])+val([Tomato])+val([Cucumber]) This will convert the strings to numbers. hope this helps...
  6. cas20002000

    Corruption in Access 2003

    I'll guess that's what I'm going to have to do.... It's frustrating because It's been working perfectly with Access 97 for the last 6 months (since I moved the tables to SQL Server); now that I'm starting to move the users to 2003, gets corrupted very easily with minimum use. Thanks to all for...
  7. cas20002000

    Corruption in Access 2003

    The corruption is only on Access 2003 frontend. All tables are linked (to SQL server 7). Is this problem related to the conversion from 97 to 2003? Would the database corrupt the same way if I redo all the forms from scratch in 2003? Thanks for your help....
  8. cas20002000

    Corruption in Access 2003

    I just converted an Access 97 db to Access 2003, it has a SQL Server 7 backend. Everything seems to be working fine, except the new version gets corrupted frequently. it always have an avg of 5 users using the database. (max. 10 users) Any ideas of why this is happening? Thanks for your help,
  9. cas20002000

    Database size increasing from query

    Please take a look at this: Microsoft Knowledge Base Article - 165823 ACC: Database Grows Rapidly When You Modify SQL Statements http://support.microsoft.com/default.aspx?scid=kb;en-us;Q165823 Hope this helps, Regards, Carlos.
  10. cas20002000

    Can you put a calculation in a table?

    Try it changing the RecordSource .RecordSource="Select * from ....." Let me know how it works Regards, Carlos.
  11. cas20002000

    Can you put a calculation in a table?

    Do you mean something like this? select * from Table where DateDiff(&quot;yyyy&quot;, BirthDate, Now)+2<= DateDiff(&quot;yyyy&quot;, CmbBirthDate, Now) and DateDiff(&quot;yyyy&quot;, BirthDate, Now)-2 >= DateDiff(&quot;yyyy&quot;, CmbBirthDate, Now)
  12. cas20002000

    Can you put a calculation in a table?

    Maybe something like this can help: select DateDiff(&quot;yyyy&quot;, BirthDate, Now) as Age from Table where DateDiff(&quot;yyyy&quot;, BirthDate, Now)>=1 and DateDiff(&quot;yyyy&quot;, BirthDate, Now)<99 How do you filter the records? Is this for a report? or a form? Regards, Carlos.
  13. cas20002000

    Import data from a .xls file

    Try Microsoft Knowledge Base Article - 115190 http://support.microsoft.com/default.aspx?scid=kb;en-us;115190 Function ImportXL5 () DoCmd.TransferSpreadsheet _ acImport,5,&quot;TestTable&quot;,&quot;C:\T.XLS&quot;,True,&quot;Sheet5!&quot; End Function
  14. cas20002000

    linked combo box is empty

    Try something like this: cboCustomer_Change() me.cbocontacts.RowSource=&quot;SELECT contacts.contactid, contacts.contactname FROM contacts WHERE (((contacts.customerid)=&quot; & forms!tblorders!cbocustomer & &quot;)) ORDER BY contacts.contactname&quot; me.cbocontacts.Requery This should...
  15. cas20002000

    Connecting Two Access Databases

    Have you tried with &quot;Linked&quot; tables??

Part and Inventory Search

Back
Top