Search results

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...

SELECT Table02.Id2Order, Table02.Buyer, Table02.Place, LookUp("[MyTime]","tableTimes","[idTime] = " & [table02].[id02Time]) AS TimeNew, Table02.Quantity FROM tblTimes INNER JOIN Table02 ON tblTimes.IdTimes = Table02.Id02Time; I hope it is OK. I've made translation from...

No. Trying to "connect" two tables in query. As I said, with [IDTime] = Integer type it works great. (I've done it just as check experiment) With [IDTime] = Double type (which is "must be") I get ERROR in every record

Hello. I have 2 tables. One is [tblTimes] with two fields, first field is [IdTime], wich is actually a numeric value of, for example, 6/24 = 0,25. --> field size = Double. The second field is text and the value is 06:00. First part of table: IdTime MyTime 0,00000 00:00 0,01042 00:15 0,02083...

Yes, as newer the things are, less convinient they are (they don't bring enough money thru publicity) Nevertheless, As my crosstab query changes with everyday or with evry order I have problem with "dinamically design" of my form. What I mean with that: Names of controls are changed every...

Hi my SAVIOR At first glace it seems that it Works. At least at the level of "data distribution" to records and fields. Now I have to create I form and see if it Works as I wished. Will send results as soon as I try Thanks again