Search results

  1. A

    Conditional formating

    AnnPhil, If i understand your problem correctly i believe the following may help you. You essentially want a 'label' on a report to be conditionally formatted dependent upon a field being blank (IsNull)? I had a similar requirement and what i have done in order to allow a 'label' on a report...
  2. A

    Print Report from Form based on multiple criteria?

    Gemma, I will have to bow to your greater knowledge of VB and Access on this one. What i can add is that there were comments included with the code i found on this forum which were 'If the record is not blank then it saves it, also when you have just created a new record and try and print it...
  3. A

    Transfer info from List Box to Text Box?

    Gary, Thanks for your reply and attachment, have already managed to achieve what i want to do but i can see where your attachment will prove handy. Regards Alan
  4. A

    Print Report from Form based on multiple criteria?

    What a star Edtab, That works - what a star:) Many Thanks Alan
  5. A

    Maximum length when declaring a variable As String

    Sorted Hi, Sorted this one, would help if i could spell correctly. Must learn to use the spill chocker. Alan
  6. A

    Print Report from Form based on multiple criteria?

    Hi, I have the following code which i found on another thread on this forum (thanks to original author) which is attached to the On Click of a button which prints the report corresponding to the details displayed in the form. Dim strCriterion As String Dim strMsg As String, strTitle As String...
  7. A

    Praise Be

    Hi all, Thought i would put this in the Forms Forum since it has the highest number of views. This is to say thank you to all who contribute to all the forums and to those who take the time to answer / respond to my requests for info. I have learnt more in the short period of time i have been...
  8. A

    Maximum length when declaring a variable As String

    Hi, I have used the following code to create a duplicate record when up-issuing a certificate: Private Sub DuplicateRecord_Click() Dim sReferenceNumber As String Dim sProject As String Dim sItem_Name As String Dim sItem_description As String Dim sPart_Number As String Dim sManufacturer_ID As...
  9. A

    Date Problem

    Bob, Works a treat - many thanks. Regards Alan
  10. A

    Date Problem

    Hi, I have moved this thread from Forms to here since i think it is better suited here. Within my database i have a requirement to produce a number of invoice type reports. However because my Financial Year goes from 1 November to 31 October, so an invoice produced today - 15 November would...
  11. A

    Transfer info from List Box to Text Box?

    Hi, I have recently been given a project at work which i will be starting soon and as a bit of forward palnning (dangerous i know) i am giving some thought as to how i will implement certain elements of it. One such element is the production of a Compliancy Certificate, this will detail the...
  12. A

    Create many reports individually

    Gemma, Thanks for the info. Essentially, my database produces for example, Payment Invoices. Whilst the layout is identical the information contained on them including Customer will be different so, if i wish to email i need to be able to separate out the reports. It maybe that if it proves...
  13. A

    Report Format with Email

    Can't quite see why you would want to convert it to HTML and then PDF it prior to sending?
  14. A

    Popup mode and toolbars

    If you go into the reports properties, you can disable to Close button by setting Close to No (or is it Off - can't remember). The Close button is then greyed out. Regards Alan
  15. A

    Report Format with Email

    You might want to have a look at this http://www.lebans.com/reporttopdf.htm
  16. A

    Create many reports individually

    Hi, I have a database that produces a number of different reports by selection of a 'Create Report A', 'Create Report B' etc buttons on a form. On some occasions selection of one of these buttons may result in a number of different versions of the same report be created. At present when i...
  17. A

    Formatting dependent on days elapsed

    Guys, Thanks for all the replies - much appreciated. Got it working using Conditional Formatting Regards Alan
  18. A

    Formatting dependent on days elapsed

    Keith, Thanks for the swift reply, so are you saying create an expression within the Conditional Formatting 'function'? Will give it a go but any further pointers welcome. Alan
  19. A

    Formatting dependent on days elapsed

    Hi all, i am fairly new to the use of VB so (1) I am not sure if this is possible and (2) i wouldn't know where to start really so any help is greatly appreciated. I guess that in order to achieve whet i eventually want to (assuming it is possible that is) will be based on using some element...
  20. A

    Updating a Combo Box

    Nilly Thanks for your reply but i had cracked it. Busy making a cup of coffee and had a brainwave / flash of inspiration / rush of whatever to brain (still hurting now)! Put Me.Requery in the On Activate Form property. I am failrly new to Access but having seen how simple it was and how long...
Back
Top Bottom