Search:

Type: Posts; User: M.Robb; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    313

    Re: Form Update (Access97)

    It is a combo box. I have a requery set for the After Update Event, but will try this! Thanks Hans.
  2. Replies
    2
    Views
    313

    Form Update (Access97)

    I have a form which is not behaving itself - can anyone help? I have a main Form "FrmMain", with a subform "FrmEpisode". Within "Episode" is a field giving a doctor's name "GPName", which is...
  3. Replies
    1
    Views
    251

    Summing within date parameters (Access 97)

    Hi, haven't a scooby what to do with this one. I have a database which I have recently set up to calculate the package price for a holiday with flights leaving on one date and returning on another,...
  4. Replies
    7
    Views
    353

    Re: database hangs on print (Access 97)

    Hi Pat, thanks - will have a look at doing this and try and post later in the week.

    Regards.
  5. Replies
    7
    Views
    353

    Re: database hangs on print (Access 97)

    Hi Charlotte, no it never completes - as I said, system just hangs (I have left it 15-20 minutes with no change). Control Alt Delete brings up the task manager to escape from a task/hung item, but...
  6. Replies
    7
    Views
    353

    Re: database hangs on print (Access 97)

    Hi Trudy - yes thanks, have tried all that with no change.

    Thanks for idea though.
  7. Replies
    7
    Views
    353

    database hangs on print (Access 97)

    Hi, I have a fairly complex database, which includes 3 reports which are causing problems. If I open the database and print any one of these reports, the first report goes to the printer fine and...
  8. Replies
    3
    Views
    367

    Re: Nulls in Crosstab queries (Access 97)

    Hello Hans, how are you? Thanks for your reply. Had tried NZ in the value column with no success, but have now found another way to get to the data I was wanting. I'm not sure why NZ doesn't seem...
  9. Replies
    3
    Views
    367

    Nulls in Crosstab queries (Access 97)

    I have a crosstab query which has a row header of dates, and column headers of various types of goods, and a value of goods booked out. Some dates don't have goods within a column header booked out,...
  10. Replies
    2
    Views
    325

    Juicing up a crosstab (Access 97)

    Hi, I have a crosstab query which takes information from a table which is updated daily with current booking information against routes and departure dates. This table has dates older than a week...
  11. Replies
    5
    Views
    564

    Re: table relationship ? (Access 2002)

    Hi Scott, yes junction tables would do it, something like tblJunctionGameTeam, with primary keys from the participating tables, e.g. GameId and TeamId.

    Regards.
  12. Replies
    3
    Views
    399

    Re: Help with Iif (Access 97)

    Thanks Hans - have tried this, but unfortunately still returns an empty query with no "0.00" value. Think this may be because of other selection criteria in other fields. Will persevere.
  13. Replies
    3
    Views
    399

    Help with Iif (Access 97)

    Hi, I have a query which says:

    MV: Sum(IIf([AssetCategoryID]=1,[AssetCost],0))

    What I really want to say is if the Asset Category Id is 1, and the Asset Cost is MORE than 0, return the Sum of...
  14. Replies
    4
    Views
    697

    Re: Automate E-Mails (Outlook Express 6)

    Hello Hans - you pop up everywhere! No we have decided not to use the Access SendObject - the user has decided she wants to generate and open each .pdf file before deciding whether or not to send...
  15. Replies
    4
    Views
    697

    Automate E-Mails (Outlook Express 6)

    Hi folks, I'm not used to doing anything with outlook express except sending standard e-mails, but I have created .pdf files from an access application which I need to run and send out to the same...
  16. Re: Exporting images to an rtf file (ACCESS 97)

    Guess it will have to be mailmerge. Thanks as always Hans.
  17. Exporting images to an rtf file (ACCESS 97)

    My user has developed a report which she wishes to transfer to a .rtf format. Within the report are 2 images which she sources from her hard drive. She wishes these to appear on the new .rtf file,...
  18. Replies
    2
    Views
    266

    Re: e-mail (Access 97)

    Hi Hans, thanks for this - I had picked up the FAQ sheet on Automation but there are bits of the code I don't understand yet. Will look up the messages you have pointed out.

    Kind regards.
  19. Replies
    2
    Views
    266

    e-mail (Access 97)

    I have a database which creates reports based on parameters which are changed daily. User now wishes to send these reports by e-mail, and automate, as she has 30 or so to do in a day. Have only...
  20. Replies
    9
    Views
    513

    Re: Form Design (A 97)

    Thanks everyone - I will try out what you suggest, but like Charlotte suggests, as I'm at the design stage I also think it is likely to be something to do with the editor.

    Many thanks!
  21. Replies
    9
    Views
    513

    Re: Form Design (A 97)

    Hmmm.... no nothing so advanced! I know I've sorted this problem before, but cant remember how. Will come back to me in my sleep probably (what a sad gittete)! Thanks anyway Hans <img...
  22. Replies
    9
    Views
    513

    Re: Form Design (A 97)

    The form has several controls which open other forms in pop-up mode. When I use these, the form remains maximized but "slides" down the window and has to be dragged back to the top. Thanks
  23. Replies
    9
    Views
    513

    Form Design (A 97)

    I have a form which is set to Maximize on current, but it moves about the screen in response to other events - what can I do to make sure it stays in the same place all the time??

    Thanks
  24. Re: Open a database from my application (Access 97)

    <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16> I think it may be because I am trying to quit the child application from code within there, whereas I should be trying to...
  25. Open a database from my application (Access 97)

    Hi, still learning VBA.... can anyone help with this? I have a database which gets data from dbs which are FTP'd into a holding area a few times a day. When it is opened, a query runs which pulls...
Results 1 to 25 of 80
Page 1 of 4 1 2 3 4