Recent content by nelson

  1. N

    Please help my job depends on this

    hmmm didn't you do any Access programming when you are @ Univ ? ....hehehe goodluck on looking for a job !!! :)
  2. N

    SQL UNION Query resultsets copied to a table using VB

    i spent 4+ days thinking about it, user dont have to open the file, they simply open the Word/Outlook, and start doing mail merge using the Excel file located in their MyDocuments...which I think way better because their requirements changes all the time. :) hehehehehe I got plenty of stuff to...
  3. N

    hiding access window and opening Report preview

    yay !!! no more access window!!! muahahaha using Snapshot viewer now!!! *yay* !!! thanks heaps:D :D :D :D :D :D !!! :)
  4. N

    hiding access window and opening Report preview

    yay ! thanks !!! this is very helpful !! will study the code and implement this to my project ! :) :D :D :D :D :D :D
  5. N

    SQL UNION Query resultsets copied to a table using VB

    i fixed the issue, I just bloody convert it to Excel and ask the user to open that excel file in the My Documents so they can do their Mail Merge... :) That way it's convenient...
  6. N

    SQL UNION Query resultsets copied to a table using VB

    :eek: :eek: :eek: anyone here know how to do this? I tried OpenRecordSet("SQL UNION") but I get an error saying OpenRecordset is not for UNION :( is there a work around for this using VB ? Thanks in advanced. :)
  7. N

    hiding access window and opening Report preview

    i got the SNAPSHOT viewer...but I have no xp on using Snapshot viewer... :) this will really make things looks really nice...when a normal user logs in it hides all the Access Window...but when an admin logs in..everything is there...
  8. N

    hiding access window and opening Report preview

    can u show me an example in VB code ? thanks... :)
  9. N

    copy query to another query on the fly

    it works if it has no UNION, anyone here know how to execute a Select query with UNION ? thanks in advanced.
  10. N

    copy query to another query on the fly

    dont worry..I fixed this issue... :) , recycled code from this forum !! *yay* !!! problem solved !!! :) Dim strIn As String Dim strOut As String Dim strName As String Dim strQuery As String strQuery = "qryMyQuery" strName = "tblMyTable" strIn = CurrentDb.QueryDefs(strQuery).SQL strOut =...
  11. N

    copy query to another query on the fly

    ok here's the tricky part.....tried to do open recordset with no success...it doesn't like SQL with "UNION" in it...will try MAKE TABLE QUERY...and see what happens...
  12. N

    copy query to another query on the fly

    I have a hybrid code below (got it from someone else here...) doing UNION...now the results are placed in QryGroupsCommitteeMultiSelect, now I want to put a "Save Query" button so a user can place it in a temporary Query so he/she can use it for Mail Merging, is this possible? what I'm...
  13. N

    Access with Word Formatting

    I have an email form, but at the moment it only do simple text , anybody here developed a similar form where you can change the font style/size/colors and then send it (with an option text/HTML) ...Anyone have any idea how to do this? thanks in advance. Regards, nels
  14. N

    hiding access window and opening Report preview

    DoCmd.OpenReport "Labels-Bishops", acPreview, , , acDialog , it's ok...done it... hehehe :)
  15. N

    hiding access window and opening Report preview

    ok, I've done it but how to I make the preview for the report to be on top ? Any idea ? Thanks in advance. :)
See more
Top Bottom