Search results

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")) &...

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 ...

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...

banana no need to test it , it wont work :)

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...

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...

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"...

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.

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.

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...

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

hmm a genius ha

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...

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...

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...

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...

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...

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...

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

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...