Search results

Hi to ALL. I'm "building" a form with 3 combo boxes: First is ValueList RowSourceType, RowSource = "Tables";"Queries";Forms" Depending on decision from first cbo I get the names of all tables Except left(name,4) = "MSys", all queries and all forms Depending on decision of second cbo I get names...

Didn't work. Anyway, I've found solution which is HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Settings Thanks a lot for your time. So Thread is solved:D

You're right. But I'm affraid importef files (tables) will not bbe affected by this settings and will remain "MS default". At least this is happening now when importing stuff. Regarding VBA. I have seen on web something regarding tabledef, addpropery fontname, addproperty fontsize,... but I was...

For me now is 10 pm. I'll try your suggestion tomorrow. What about changing properties via VBA?? Can it be of any use? Although I don't know how to do it.

Hello guys. I'll ask for help on one metter which I know I maybe shouldn't ask for it. The case is that I'd like to work COMPLETE ACCESS in fontNAME "CONSOLAS" and fontSIZE 10 - so that default font would be Consolas 10. As far as I know it is not so easy to setup different fonts than...

Yes. A,ready done what you suggested. It is not ideal, but I get what I want. Will mark thread as SOLVED

I've found out solution, which I don't like much but I think it will work In main form (which will be Single & Unbound Form) I can do "all" I want. At the end of row I'll put command button Like "insert new record". This record will be than "transported" via VBA to subform, which's recordsource...

Hello to All. I've made ACCESS CONTINUOUS form like the one in attachment (which is actually Excel shape) Main wish is to have VALUES in controls Range_m;Area_m2; Volume_m3; and their VISIBILITY depending on Measure unit value ("m", "m2", "m3") On AfterUpdate event of MeasureUnit I've made...

At the end of this thread I wrote the solution of my problem if you are interested. Seems easy enough. Thanks for your help too Regards

No, I have only followed your instructions - opened form in design view - Customised theme - saved "myTheme" (here where the problem was, could't find out where "myTheme" was autosaved ---> i had some maps hidden in my Explorer) NEXT File --> Options --> Client settings --> Default Theme...

i STRUGGLED SOME TIME TO FIND WHERE "MYTHEME" IS SAVED. At the end I succed and now it Works. Without your help I'd be looking for the solution another 10 years. THANKS THANKS thread solved Regards

Yes, worked BUT ONLY FOR FONTS IN QUERY DESIGN. Output of this query is still Calibri, as new table is, as all objects in design new form are. I'm looking for some kind of "OVERALL" setting of default font, lets say, for Access

Maybe funny question, maybe already answered: I'm tired of constantly changing fonts in every new table, every new query, every new control in form, … I can't find nothing similar as settings in excell or Word. In Options I've found allowed changes (size, weight, italic …) I'm not looking for...

I found this "case" on YouTube tutorial. I know "it doesn't have any "real life" sense" but question as such was very "intrigated" for me --> Dlookuop two tables, ---> Double as ID So, question very "real life" case, tables --> I'd never do it that way Anyway, thank you for your help

OMG. Where have we came with my "simple" question. This also is a way to see how extensive knowledge is needed to work with VBA. Regarding everything I've decided to make things simpler. Dividing "time" 12,25 with 24 will ROUNDED on 5 decimal places and I'll get 0,51042 Next I'll multiple the...

Hi. Have you tried to replace tblTimes with tblDecimalTimes? Did it work? I still get error.

thanks in advance. It is not urgent. Take your time.

Re: DlookUp on two tables using Double As ID Hi. Sorry not answering you immediately but it was 23:00 hours at me and I went to sleep. 1. Yes, typing mistake while "Translating" 2. Nubers produced by dividing with 24 are already ROUNDED Other. This is only "study" case. I'm following...

To The_Doc_Man, to TheDBguy: SQL query suggested by theDBguy worked perfectly (THANKS), and I could call the Thread SOLVED. BUT I'D STILL LIKE TO FIND ANSWER REGARDING NON WHOLE NUMBER AS PRIMARY KEY ID FIELD AND DLOOKUP FUNCTION :confused:

Hi. Sorry not answering you immediately but it was 23:00 hours at me and I went to sleep. 1. Yes, typing mistake while "Translating" 2. Nubers produced by dividing with 24 are already ROUNDED Other. This is only "study" case. I'm following tutorials of Mr. Steve Bishop on YouTube (Chanel All...