Search results

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

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

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

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

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

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

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

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

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

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

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.

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.

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

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

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

Hi I have created a website that includes an Access database providing a directory of manufacturers and suppliers to complement a magazine version. The requirement now is to distribute the catalog on CD as well and the challenge is how to supply a query function? I created a cd version of...

Larry, I actually put both the BE and the FE on the website as the database is used in the website for queries. As to whether one could use the link table manager to link a local pc FE to the website BE I do not know. If this were possible it would help me no end with another situation...

FYI I have tested using a split Access database on a FrontPage website and it works - all I needed to do was run the Access Link Table tool.

Hi, The situation is that we have a split DB on a LAN using Windows Server. The BE is on the server and the FE are distributed to each user PC on the LAN. (For historical reasons there are differing versions of Access at each user which was the primary motivation to split the DB) We also have...

Hi, How can I ensure that line spacing on an Access Report is replicated when it is exported as an RTF file to WORD? It seems to shrink in WORD resulting in a large whitespace at the bottom of the page...... Regards Tony Randell