Search results

What can I say, that's the most comprehensive help I've ever received I would have been overjoyed with just half of what you done. Thank You SmallTime

That's really great, exactly what I was looking for Sorry for the misunderstanding. I was hoping to do this on server side but on this occasion I think I'll take the performance hit and do it in access. I like your MaxProfile & MinProfile functions, very cleverly crafted indeed. A truly well...

Sorry I thought I'd attached the file but realised that RTF docs can't be uploaded. Here they are in TXT format (headings will be out of alignment)

Not quite there. I've attached a couple of files to show the results of the original data (978 Rows) and the queried data (137 Rows) and All tt fields showing as 1. I think I'll do the filtering in the front end (Access) as I'm much more comfortable with that. Thanks for your time and care...

If the changes your making are to the buttons only, not removing any referenced fields on the form, then copying the old code wont cause corruption problems. Check your references to make sure nothings missing (VBA window - Tools - References) Try and match as close as you can to your old...

Hold on all the results in tt are coming out as 0! I removed all reference's to Profile5 as there isn't a profile5. The query runs OK but the result column in tt are all 0's which I now see are being taken from those profiles that are empty (defaulting to 0). Hmmm. How could I exclude 0's?

Fantastic. I'd never have managed that by myself. I've been trying all sorts of things for hours without luck. Thank you SmallTime

Wonder if someone would be kind enough to help me out here. How can I amend the following so to only select the profile with the lowest value, if a value exists? Select ProfileID, Name, Profile1, Profile2, Profile3, Profile4 from TblSample - Profiles are an integer between 1 - 9 -...

Your going to need a couple of tools for this 1. Microsoft SQL Server Migration Assistant 2008 for Access 2. A version of SQL server, There is a free version call SQL Server Express. 3. An sql server management tool, SQL server management Studio is a good option. Then you'l have to link the...

Your going to need a couple of tools for this 1. Microsoft SQL Server Migration Assistant 2008 for Access 2. A version of SQL server, There is a free version called SQL Server Express. 3. An sql server management tool, SQL server management Studio is a good option. Then you'll have to link the...

Not 100% sure this applies to you, but SQL server based forms can't be used as linked subforms, You have to manage related records in code. On the other hand why are you placing the forms onto a navigation form, why not just open the required from with a button. Something like DoCmd.openform...

I'm using procedures that are written and stored within SQL Server and then executed from within a PTQ to update records. The downside is that oftentimes I'm having to construct the PTQ statements in VBA on the fly. not always the easiest of tasks. SmallTime

Thanks for this. I was struggling a little before I realised, or discovered, that I should set record returns to 'No' before it would work. All is well now after some time fumbling around. Thanks for the reply though. SmallTime

Hi I have forms, queries and temp tables that are based on pass through queries or access native queries based on PT's. I'm also updating records on sql server using Sproc's, so far everything's working fine without the need for linked tables. Which is making me wonder why I should have them...

Methinks my brains turned to mush :-)

I've noticed this too when changing over from A2K to 2010. Forms blink to the point of distraction. I've also noticed that there's less 'blinking' depending on the amount of free resources on the computer. The problem's still there when I shut other programmes down but to a far lesser degree...

Hi, I'm drawing data for a report from SQL-Server via a pass-through query. The date fields are showing as yyyy/mm/dd whereas I need them to be displayed as dd/mm/yyyy. If using an ordinary select query know I could use something like; =Format([datefield],"dd/mm/yyyy"). However, there's no...

Just in case anyone interested. I created a tmptable from the pt query (saves having to drag all records down from a linked table) and used that for the record source then passed params to a SPROC. It does the trick but what a palava. Hope the next version of Access does a better job of...

Thanks, I'll keep an eye on the site and wait until Ms. announce a proper fix, sp for sp1. Oh well. Regards SmallTime

I suppose I'll just have to suck'n'see, I suppose if they get stuck with over 20 users scenario they could share the users on the other server (they have 2 in the farm) Thanks for the effort SmallTime Being a bit naughty here; Any idea when the SP1 issue might be resolved and where will it be...