Search results

  1. L

    automatic ID generation

    you are going to have to be a little more specific
  2. L

    Viewing a subform on the same screen as a form

    place the subform as a subform in the bottom half of the screen then? /locomotion
  3. L

    Text formatting

    I am not talking about a short message I am talking about a comments field which is a memo, which then represents data in a report So I need to be able to format a couple of words or short sentences within the comments field where it would be better to emphisize. Basically I want to make a...
  4. L

    Need help to create table programmatically

    Use a relationship on a 1 to 1 basis To do this go to tools > relationships select the fields you want to be the same and join them up in form C using a 1 to 1 relationship rather than a 1 to many Hope this helps also if field 3 on table C is the same as field 2 on table B I would suggest...
  5. L

    Text formatting

    Hi there again, My question involves text formatting, memo fields and reports is there some way to format the text in a memo field so that it comes up in italics or a different colour when it prints on the reports? Say I wanted to say Your Bill is due NOW! Now to make it stand out I might...
  6. L

    Combo direct from table

    I want to create a combo box that links direct to a table, rather than going through a query. Then when you select the record from the list it updates a text field to show the memo field of which the selected reccord is related Can any one help I tried using a query to do it, however queries...
  7. L

    Gridlines.

    This might help you a little bit in the form properties you can specify Grid x and y however this will not change the size of the black lines and will only place dots in the grids From what I can see 1 or 10 or higher = the normal grid 2 = 1 dot in the middle 3 = 4 dots in a square 4 = 9...
  8. L

    Can I have help with one question please

    we all knew what you meant I think your way was better though However the first way you suggested sort of did the opposite ;)
  9. L

    Enter text into a memo field using a drop down and button

    sorry let me explain it a bit better What I have is a form with a memo field in it into this memo field I want to add text which is selected from a cbo box which is linked to a table that has the text stored in memo fields However When I use the method you suggest I can only insert 255...
  10. L

    Can I have help with one question please

    well he certainly wouldn't want them to add the date 2 minutes before hand now would he :D
  11. L

    Can I have help with one question please

    yeah I thought that might have been a little bit out of place ;) /locomotion
  12. L

    Can I have help with one question please

    anytime /locomotion
  13. L

    Access is too big! how to reduce size?

    some data validation rules might be a good idea Somethings you might want to try are: Digits in phone numbers (Australia has 10) Postal Codes (Australia has 4) if its values work out how much is the greatest value going to be use data validation rules make sure that all your data is...
  14. L

    Can I have help with one question please

    >=Now() would probably work better This means they can enter todays date or tomorrows date or any date in the future and nothing before hand /locomotion
  15. L

    Access is too big! how to reduce size?

    Use the compact database wizard in the tool menu Also you could try splitting the database and keep the tables in one place and the forms in another Hope this helps /locomotion
  16. L

    .snp (snapshots) emailed with read receipt

    I am using Microsoft Outlook 2003 I have turned on read reciepts in the mail client but it still wont work
  17. L

    Enter text into a memo field using a drop down and button

    The problem with that solution is that I can only use 255 characters.... I am selecting text from a memo field, is it possible to have the primary key as the item to select and then it refers to and inserts the text in the memo field as a whole?
  18. L

    Access to Outlook Calendar for Alert or Alarm Message Reminders

    If you use microsoft exchange server you should be able to add the appropriate appointment into the other persons calendar
  19. L

    Read Receipts using sendto method

    This is a problem I have In our existing database we have a report that gets sent out to several different people using the .snp (snapshot) format via email However when we right click and send to mail receipient using snapshot format it does not automatically send a read receipt. So I know...
  20. L

    Enter text into a memo field using a drop down and button

    What I am having the problem with is the command & vbCrLf & could you explain what it represents
Top Bottom