Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. T

    Distributing an Access Application on CD

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

    Synchronising a LAN BE with a website DB

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

    Line spacing - changes when exporting to Word

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

    Shrink Horizontal Whitespace AND Format Individual Controls

    Hi, I know how to shrink whitespace between horizontal controls by using a single control and code BUT I need to apply different colours to each component control. An example of what I am trying to achieve is showing the areas a company is represented in and using the correct colour for that...
  10. T

    Saving multiple listbox selections

    Hi, I have a simple order entry system working with a subform containing combo box where a client selects various products from a table. These are recorded in separate table which allows for subsequent updating of the orders placed. Now I want to refine this so that the user may make multiple...
  11. T

    SQL Sub Query

    Hi, Help - I do not know SQL! I have a problem that I think will be solved with a SQL sub query but have no idea how to go about creating one! The table is for a publishing application that I have created in Access. The requirement is to establish the no of pages per copy given the...
Back
Top Bottom