Recent content by ray147

  1. R

    HTML Code for Email Body Text

    Hi, I am using an Access form and VBA to send multiple emails at the same time. Everything is working fine. However, now I would like to include some HTML code in the Email body as I would like to put a URL link as part of the text message to the recipient. An idea of the HTML code I'd like...
  2. R

    Issues with List Boxes

    really nobody has any clue how to sort these issues? or is what i'm asking not supported by access? :confused:
  3. R

    Issues with List Boxes

    Hi, I am currently working on a database and have some little issues with list boxes on forms. Some formatting issues which seem simple but can't figure out ... I'm attaching a sample DB with one table and one form having a list box. 3 things which i'd like to have with my list box : 1. is it...
  4. R

    Problems with continuous forms

    Thanks Bob ... I sorted that one out an am attaching a revised DB... i still have issues which i cannot resolve though....i have managed to get over a lot of issues with access and VBA but i just can't really understand how can i control the updating of continuous forms.... as you can see on...
  5. R

    Problems with continuous forms

    OK will try to explain better what i'd like to do... 1. user enters the container number in the text field on main form 2. user chooses the invoice currency from the drop down box on main form 3. user enters the invoice numbers/values relative to that shipment (on the subform) 4. when the...
  6. R

    Problems with continuous forms

    got 18 views to my thread and no one can help?! :confused:
  7. R

    Problems with continuous forms

    I am having problems with Continuous forms....I had already started this in another thread but now i restructured a bit and better to start new... Attached i'm attaching a sample DB with what I have... In Form1, i have a subform subInvoices....in the footer of the continuous form i have a...
  8. R

    Continuous Forms

    Thanks...however still can't figure out something with continuous forms... Let's say I have a table 'tblCharges' having five rows. I want the continuous form to list one field from all the records from 'tblCharges' along with an empty text box for the user to fill in. The user will fill in the...
  9. R

    Continuous Forms

    Am afraid that's not the issue no...thanks anyway.... RuralGuy refer to my previous post..many thanks
  10. R

    Continuous Forms

    Yeah that's right....for each shipment in tblShipments table, there will be six records in tblChargesAmt table. Another option would be to append rows to tblChargesAmt table if values are > 0. Thus, when the user does not enter a figure for 'communication chgs', that entry can be omitted from...
  11. R

    Continuous Forms

    Thanks but not quite what i had in mind...might have not explained myself well...will try again! I have a list of charges in the 'tblCharges' table such as Freight Charges, Documentation, Communication Chgs. I would like to let the user have the option to enter a value for each of these charges...
  12. R

    Continuous Forms

    You're right....i'm attaching again....
  13. R

    Continuous Forms

    Now would like to go a step beyond that.... I'd like to be able to enter a list of import charges that relate to each shipment...the list of charges might change thru time so i'd like to have the list of charges in a table and loaded with each shipment. the user would then enter the amount for...
  14. R

    Continuous Forms

    Great Thanks...Much appreciated :)
  15. R

    Continuous Forms

    thanks ruralGuy! i managed to set that up as u said... (1) created a query to load the invoices having shipment ID equal to the one on the main form (2) attached that query to the continuous form record source one issue left...when appending new records...the Shipment ID is left as...
Top Bottom