Search results

  1. nIGHTmAYOR

    Group Date

    heh i just revised the code and saw there was no real need for Month([my_date])>=1 so you can strike it out.. Interval : IIF(Month([my_date])<=6;(((Year([my_date])-2007)*2)+1) & IIF((((Year([my_date])-2007)*2)+1)=1;"st";IIF((((Year([my_date])-2007)*2)+1)=3;"rd";"th")) &...
  2. nIGHTmAYOR

    Group Date

    your question belongs to queries section yet'll help for this one time hopeing you will diffrentiate later. 1st rename [Date] field to a name that is not reserved ex [my_date] 2ns you need to group on two fields (Month - Year) so here goes the interval expression : Interval ...
  3. nIGHTmAYOR

    Access VBA Duplex Printing

    i read you but i'm not pleased . your problem is 100% lack of report designing concepts. 1st you can easily make report display multiple invoices via grouping: (View >> Sorting and Grouping >> choosing field expression to group on [your_invoice_id_field_here] >> enabling headers and footers...
  4. nIGHTmAYOR

    A trick for setting a primary key on a linked sql server view in microsoft access

    banana no need to test it , it wont work :)
  5. nIGHTmAYOR

    LInking to User-Level security db

    you need to set both dbs to use the same system database .(check out Tools >> Security >> Work Group Administrator) if by any chance it turns out both were secured not just the one you are trying to link to , you have to asign ownership (Tools >> Security >> User and Group Permissions)of objects...
  6. nIGHTmAYOR

    Help!!

    deary you've gone so far by improvising why stop now ? so you triggered the print dialogue via sendkeys you picked default printer (probably print to pdf) via send keys a dialogue pops up waiting for your file name and then you ask how you provide one ? yes thats right sendkeys heck you can even...
  7. nIGHTmAYOR

    Opening hyperlink from Access Report in specific frame

    open your exported report in a txt editor such as notepad , search for the link you'll probably find a syntax as such : <a href="http://www.myleaguepage.com">http://www.myleaguepage.com</a> just edit it to look like the following : <a target="framenamehere"...
  8. nIGHTmAYOR

    Application crashes

    if you already have tried compact/repaire and creating new db >> importing all your objects to it and the problem persisted , post the code it might be your real problem.
  9. nIGHTmAYOR

    exporting objects from form

    there is a macro for which called OutputTo check it out , as for sql if your needs are to create it dynamicaly then make your where condition use a dynamic parameter.
  10. nIGHTmAYOR

    Vector to BMP/JPEG conversion

    of what you post all you need is a picture batch convertor supporting command line switches, check out a list at http://www.klitetools.com/index.php?action=news&catid=65 some of which r freeware even , now you can use Cmdlg object to acquire vector file path and use it with appropriate switch...
  11. nIGHTmAYOR

    Newbie - help with syntax (comma) error

    oh use Date: Format([BALLOT_RECEIVE_DATE];"mm/dd/yyyy")
  12. nIGHTmAYOR

    hmm a genius ha

    hmm a genius ha
  13. nIGHTmAYOR

    Data Variables and Form Entry

    What i get of this hazy discription is that you are trying to create a data entry module that copies data from somewhere (another application maybe) to a form in your ms access application via a third party application and wondering if you can lose the third party application and just use access...
  14. nIGHTmAYOR

    change record values after checkbox "YES"

    here is a hint , you reach a control inside a subform by typeing its path , ex : Forms![yourmainformname]![yoursubformname]![yourcontrolname].value 'VBA Version Or Me.yourmainformname.yoursubformname.yourcontrolname.value 'VB Version now assigning values you acquire from these control...
  15. nIGHTmAYOR

    Application.Version in Access 2007 run time

    you can always test how your db will react under runtime environment by useing command line switch "/runtime" as in: "c:\program files\microsoft office\office12\msaccess.exe" /runtime "c:\My Folder\My Database.accdb" yet remember , one fatal effect of runtime environment is that runtime errors...
  16. nIGHTmAYOR

    Funny Listbox side effect when updating Form.RecordSource

    Odd , i had that once in office 2007 beta but not in final release , back then i solved that by relying on Form Filter property not Record Source then issued a Requery command on done. I'd suggest you download latest service packs but if i know ms access correctly then this wouldnt solve...
  17. nIGHTmAYOR

    Use VBA To Automatically Insert Fields

    tranchemontaigne i understand him fully , yet he has a vision and he wants to achieve HIS vision through someone :) whilest i have another vision for him (including creating a virtual dates table using sql then using a join from that table to his) which is less reliant on vba yet more practical...
  18. nIGHTmAYOR

    A trick for setting a primary key on a linked sql server view in microsoft access

    CurrentDb.Execute "CREATE INDEX PrimaryKeyIdx ON TableName (YourPKField) WITH PRIMARY" Thanks LPurvis for cutting the chase , you see the above methode occured to me whilest under pressure (Most my techniques are :) ) and was found pretty effective and no it's not affected by nothing but...
  19. nIGHTmAYOR

    A trick for setting a primary key on a linked sql server view in microsoft access

    this trick also applies for setting a bogus primary key for sql server tables other than the one defined.
  20. nIGHTmAYOR

    Send Invoice to Customer in Outlook using VBA

    custom create a report (copy the existing one you are working on) where its source sql statment looks up current client (Mr Bloggs) sale/invoice "key" off your opened form and then use this report as a source of your email code. further to this if your form was named "sales_form" then we are...
Back
Top Bottom