Recent content by bastanu

  1. bastanu

    need help to add user access level

    Many ways to do that, here is a link to my sample: http://forestbyte.com/ms-access-utilities/fba-custom-access-levels/ Cheers,
  2. bastanu

    Error when calling a URL

    Keep us posted please!
  3. bastanu

    Solved PNG Logo in Generated PDF not Printing Clear

    How does it look if you use Docmd.OutputTo to create a PDF file from the report? Cheers,
  4. bastanu

    Solved Report won't Print Multiple Pictures.

    Google is your friend...
  5. bastanu

    Solved CanShrink in reports detail.

    Something like this should work (Dcount on that query would tell you if there are records returned or not): IIF(dCount("*","QSalesQuotationItemAcc","OrderID = " & OrderID) =0,>0,< DMin("POSITION","QSalesQuotationItemAcc","OrderID = " &OrderID)) Cheers,
  6. bastanu

    Solved CanShrink in reports detail.

    Not sure what do you mean by that, what should happen if there is no OrderID? Can you show a sample? Cheers,
  7. bastanu

    Error when calling a URL

    When I try this modified version it opens this thread, can you try it? Dim strURL As String 'strURL = "http://admin:jTZ27imOh2@192.168.90.24/command.htm?number=12345678&outgoing_uri=URI" strURL = "https://www.access-programmers.co.uk/forums/threads/error-when-calling-a-url.323255/#post-1827172"...
  8. bastanu

    Error when calling a URL

    You might also try this: Dim strURL As String strURL = "http://admin:jTZ27imOh2@192.168.90.24/command.htm?number=12345678&outgoing_uri=URI" CreateObject("Shell.Application").Open CVar(strURL)
  9. bastanu

    Error when calling a URL

    What error do you get?
  10. bastanu

    Error when calling a URL

    Have you tried it without the brackets? Application.FollowHyperlink "http://admin:jTZ27imOh2@192.168.90.24/command.htm?number=99358535&outgoing_uri=URI" No need for the other two arguments as the first is empty and the second (NewWindow) already defaults to False. Cheers,
  11. bastanu

    MailMerge: Display Email before Send (wdSendToEmail)

    I'm afraid it cannot be done in your current context, the built in Word mail-merge emailing doesn't have a Display. Your options are to automate Outlook programmatically and get the move through the Word mail-merge records and get the content to be used as the Outlook message BodyHTML or maybe...
  12. bastanu

    Query based report showing wrong column/field...

    Oh, I see, thanks for the clarification, what I meant was going to the lookup tab and selecting a combo or list box then setting the multi-value to Yes.
  13. bastanu

    Query based report showing wrong column/field...

    Yes, in the Lookup tab of the field in table design, isn't that called the lookup "wizard"?
  14. bastanu

    Solved CanShrink in reports detail.

    Create a totals query (qryLast_AC) where you Group by Left([Part_No]),2) ="AC" and get Last_AC:Max([Position]) then in the report 3 record source you filter the Position field to be greater then Last_AC: >dlookup("Last_AC","qryLast_AC") Cheers,
  15. bastanu

    Query based report showing wrong column/field...

    @Pat Hartman - I know that Pat, that's why I said it is a type of lookup because you can't set up a multi-value field without the Lookup wizard. The problem for the OP was showing the concatenated text values instead of the concatenated bound IDs; if you just eliminate the lookup as proposed...
Top Bottom