Search results for query: *

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

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

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

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...

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

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...

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....

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,

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.

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

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)

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.

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

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...

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