Recent content by trandel

  1. T

    Relationships lost and record deleted

    Ok -I will try out importing to a new db for the BE - but wont it simply copy the 'problem' whatever it is? I will try and get rid of memo fields - I used them way back when I didnt realise they were a problem!! Conversion to text might be interesting............ I think relationships have to...
  2. T

    Relationships lost and record deleted

    I have a peculiar problem. The sequence of events is: 1. The user reports that on clearing (deleting) data in a memo field within a table an error (sometimes) occurs which results in all fields for that record containing the word #deleted. The table can no longer be opened for update via a...
  3. T

    DLookup in a query expression

    Hi Dennisk Just realised just how right you are! I was looking for complex solutions to simple problems. Thanks and Regards Tony Randell
  4. T

    Dlookup in calculated control

    Hi Dennisk Took me some time to see it but you are absolutely right - link the table and use the normal criteria to select the correct entry. I was looking for a complex solution to a simple problem as usual. Thanks Tony Randell
  5. T

    DLookup in a query expression

    Hi, I have a DLookup expression that is working in a Control on a form : =DLookUp("[Class] ","Class","([Forms]![Orders_Crosstab]![Indcat] = [Clind]) AND ([Forms]![Orders_Crosstab]![2005] Between [From] AND [To])") I simplified it for test purposes as an expression in a query: Expr1...
  6. T

    Design option

    Hi, I have an existing desktop Access database for a Membership system which is working fine (+- 1000 members). We have an existing website that is also working fine and developed using Frontpage 2003 - due for conversion to Expression Web. Challenge: We want to offer a facility for members...
  7. T

    Dlookup in calculated control

    I cant link the tables. The Dlookup is to find the appropriate class for the crosstab calculated total of Sales per client. There are 4 classes which refer to different levels of total sales value depending on Indcat. e.g Class A = between 100000 and 550000 for Indcat 1 but is between 15000 and...
  8. T

    Dlookup in calculated control

    Hi, I am trying to create a calculated field in a query which uses another value in the query to lookup a table. I get an error running the query : "Microsoft Access can't find the name 'Indcat' you entered in the expression." The expression I am using is as follows: Expr1...
  9. T

    Access quitting unexpectedly

    Solved! I have upgraded to Office 2003 and all the problems have gone away!! Office 2000 must have been corrupted in some way ........... Now I can get on with the project. Thanks again for all your suggestions
  10. T

    Access quitting unexpectedly

    I have done: Checked all the References - all justified Decompiled Compact and Repair Recompiled Worked for a short time ( with me hooting with glee) and then failed again - Access just quits! It must be something I have done during this update. I have thought of another way to process my...
  11. T

    Access quitting unexpectedly

    Every MS product is up to date but I have checked Office Update this am to make sure - and all is OK. I am frustrated as this is an update to an existing application which is working just fine. I must have done something during the updating to 'break' it.
  12. T

    Access quitting unexpectedly

    I am still developing so dont really need to split for one user - me. But I did anyway and it still gives the same problem.
  13. T

    Access quitting unexpectedly

    At this stage it is a complete db but it will eventually run on a network as a fe/be
  14. T

    Access quitting unexpectedly

    Hi Am using Access 2000 and Windows XP SP2 I am experiencing a problem with Access simply quitting without any error message or any other indication. It is intermittent and occurs at random points in the application usually when opening a form or navigating between records within a form. I...
  15. T

    Synchronising a LAN BE with a website DB

    Sorry - I did NOT manage to split an access database website after all. It only worked on my testing IIS PC because the links were on my hard disk. When I actually published to the web Access Link Magaer could not join the FE and BE
Back
Top Bottom