Search results

Second time today I've forgotten to mention alternatives. You could also apply a filter which might be easier Take a look at DoCmd.ApplyFilter Method SmallTime

Assuming by split form you mean a main form and a subform - Create a query with all the data that you need on the subform - in the 'department' field of that query, under Criteria, build a reference to the drop down box on the main form (which you would have already created and I assume...

Sorry forgot to mention set the visible property of the combo boxes you want hidden to FALSE you could also use the code below in the OnClick event of a button Me.YourComboBoxName.visible = true One entry for each comboBox that you want to show so it would look something like...

Hi, 50 Combo boxes sound like a daunting task for a user to complete, frightening in fact. are you sure there's no way of cutting this down. If not you could use one of two methods. 1. Hide the combo boxes until thy're needed. On the AfterUpdate event of a combo box use something like...

Well what can I say, seems like you're reading my mind and giving me the very exact advice in the most timely way. I was, as you'd probably guessed struggling with creating the linked tables which I've now completed after reading your guide, extremely helpful. In fact after reading your guide...

Having successfully convert my tables to SQL Server Express I'm in the process of creating links. How grateful I am now for Lightwave's post and HighTechCoach's links re the subject. Haven't quite managed it yet as I'm still trying to digest the DNS-less connection method and how I'm going to...

It’s 3.20am and finally after umpteen installs and uninstalls running every diagnostic tool in my library and uninstalling a host of other things I can’t even remember now, I got down to the culprit. Powershell 2 doesn’t like SSMS or rather SSMA doesnlt like powershell 2. No Powershell 2...

HELP, I've been trying for hours with this but can't get Management tools to install.

Nice write-up. like you I'm working going to try and get it working first and then polish later. But as HiTechCoach suggest I'll be then be going back and remaking from scratch. If I'm going to play with another technology then I really need to be reasonably competent before throwing it at my...

hmm This one of the reasons why I've been so hesitant to play with SQL server, it make feel like fool. There wasn't any mention of anything called SSMS what I downloaded was SQLEXPR32_x86_ENU.exe http://download.microsoft.com/download/5/1/A/51A153F6-6B08-4F94-A7B2-BA1AD482B I'm now...

That went well. Upsizing from 2010 failed at the first hurdle Any ideas?

Sorry my mistake I thought sql server express was an integral part of Visual Studio, my mistake. Anyway, just finished downloading and installing sql server express 2008 r2 and feeling empowered already. Looks like it's going to be a late night form me. I'm eager to see how the tables will...

thanks, I'm just reading up now. I'll be downloading V.S. trial version and then and then see if Access 2010 upsizes for me. Once I have the tables I can start playing around and see what other changes I'll have to make. Actually now that I've got the bit between my teeth I'm quite looking...

Hmmm. I know you're advice is right on the money. I hate it, but it's spot-on. OK, I've just taken a deep breath and held it for a few seconds. I'm going to read-up over the weekend and take-in as much as I can. See how far I get by Monday from a standing start. One issue though I don't gave...

The App I'm redeveloping was my very first attempt at writing a DB, previous to that I hardly even knew how to use a mouse let alone how anything else. A kind workmate once spent about 6 hours showing me what a Db was and the basic principles. Fortunately I managed to commercialise my first...

No files, no attachments, no pictures just text. I know Access has a max size of 2Gig and suspect that it's more like 1.5 gig before things get wobbly. I was in the back of my mind hopping Ms would have increased the max size in 2010, but it seems that's not to be. I'm currently migrating...

Ah I'll have to think of another strategy then as my knowledge of SQL server is zilch, nothing, zero. I wouldn't even know where to begin. On the other hand I do have about a year or so to learn. I just don't fancy or have the time for that matter to learn a new trick, it's taken me the best...

Fantastic Site. It's now in my bookmarks as part of my ref library. I've only just had a cursory look but will be scouring it in details when time permits. I'll be keenly looking at relinking BE through VBA (something I've never managed to do but always wanted to). Currently I have a single...

I noticed that after failing to convert a macro the accdb corrupts. I did notce this until some code some code wouldn't work any more and I creating new macros became impossible. Compact and repair didn't fix the corruption so had to create a fresh database and drag all the objects into it.

I would think twice about an access only career simply because Ms aren't keeping pace with changes. They're obviously having a great deal of trouble making access work on the net as it exists now and unless you think Ms will make the leap with access and develop it to keep pace in line with...