Search results

Hi all, We just got access to sql server database and I need to know the best way to create tables in it. Is it easy in ms access? we have an older version of access, 2010 I think. I can connect to it and see all the system tables but for the life of me can't figure out how to create tables...

According to the wiki it has roots in German tradition, so maybe just leveraged by Hollywood to make money :)

We saw The Darkest Hour as well - thought is was real good!

Did churchhills sec'ty really get hit by a bus and it changed his opinion?

Thanks - Yes that is what I plan to do. I will tinker with the code - Thanks!

Hi all, Watched a couple episode of the Crown. Just curious how factual it is if anyone happens to have seen it. The 1950's fog episode was pretty dramatic and something that missed our history books, go figure...(or maybe I was asleep again...)

Greetings, Been a while since I've logged in.. Anyway, I have a spreadsheet with many cells that have formulas and part of the formula is the number 1000. This is used as a multiplier in the formula and I need to change all of them to 10,000. I thought I could do this with the replace tool. It...

Thanks Doc - I'll give that a try.

It won't let me even create a blank database now... ugh. I'm stuck. A second dialog pops up saying to quit the ole server. I can't find out how to do that ....

Thanks - I'll give them a try. I am trying to do this on a imac/VMware...

Hi all - long time :) I am trying to open an accdb on a new Win10 install and it says it can't find the system.mdw. I've tried everything I can think of and can't get past this. Anyone have any suggestions?

You may have to test to determine which subform is active before you refer to controls on it.

You can create a linked config type table that would flag which reports are active etc.

. . . Golden :p

Cool thing is now that you have in it in a module you can create a table for configuration data like this and if you need to change the date parameters all you have to do is change the value in the table and not have to poke around in code. You go from a hard coded parameter to a dynamic one...

You should be able to get to this through the TableDefs collection...

Seems a report is a static type thing, why the need to recalc anything?

Can't you use a textbox event trigger? Edit: OnExit trigger?

Tracking the number of users as they log in is one thing, figuring out when they close is another...Seems I read something about concurrent users somewhere...?

You should trap the null values and code around them instead of the error.