Search results

Don't guess Ive ever done that before -

Seems like a union query is what you need - Edit: Beat me to the punch...

Do you need to declare the vars? ??

You're welcome - please let us know how you proceed, I like learning new tricks :)

I think I get the gist of what are trying to do. The problem is you are, in a sense, trying to create dynamic field names which is typically bad juju in database world. You could go to the trouble of writing code to create field name on the fly but then you have to map data values to these...

What are you doing with the data after you get it in the desired format?

Um... I don't recall using sql to manipulate a recordset object. Try plugging the table name in the sql instead of 'rst'. Edit: Or you can use rst.delete to remove the current record after you utilize it...

I like to create the query in the query builder then copy the sql to a text string. Maybe you should try this - ?

If I remember correctly domain functions (Dsum(),Dmax, etc) should only be used when there are not many rows in the dataset. Having said that you may try indexing the lookup fields and see if that speeds things up...

I am trying to get Access up on my iMac and have installed VMware Fusion. I have an OEM Win 7 disk but after having issues the VMware help desk says the OEM disk contains executables (which Fusion does not like) instead of an ISO file(s)? MS help gave me a link to download the ISO file but I am...

Ok - so I was just looking in the wrong place. Thanks -

In the query builder, instead of just selecting the column name do something like MyCalculatedFldName: FldName1 + FldName2 to add two fields, etc...

Not at all, my response to the original user was flippant ... On another note: I was in BestBuy yesterday and did not see MS Access in the Office 365 group. I wonder if they are ending the application - ?

Can you calculate it in the reports query then sort on it?

yeah - sounds like you inherited a monster. Is the re-write slated for MS Access or some other platform?

I am a bit rusty and may have my syntax mixed up... Seems like the best option is to slice out the code to be called from multiple places and put it in a separate module. But it sounds like this has already been attempted...

Maybe on the form 2 open event do something like: application.Forms.Item("Formx").SetFocus

So when referencing a sub form you must reference the subform object that reside on the main form first: forms!myMainformName.mySubFormOjectname!mySubformName etc You may have tried this. My apologies if you have...

Maybe make form 2 modal?

Cool - outside my flippant response a few years back, did you get your question answered in regard to running code from a second form?