Search results

Ok, what about InitialFileName, how should i set it correctly to have *accdb?

Why? When you saving some file e.g. from ms office filter is on you mean wskazMiejsce.InitialFileName = "*.accdb"? - doesn't work. I still see another files

have a function that shows me the saving path choosen by user The problem is I can't set filter to *accdb. If I work with msoFileDialogFilePicker then .filter property works. What should I do to set filter *accdb in msoFileDialogSaveAs? Function Plik(TytulOkna As String, TytulPrzycisku As...

I can't because I need opportunity to choose information from ms excel (range) and then paste these information to specific tables in ms access. Please see my sample

I'm using dao.recordset (know sql) to work with my internal data, because in the past someone in this forum show me how to work with sample. So now I need to import from xls some date to my database in Ms Access. But Ado.recordset is unknown for me (I was traying to understand it:/). So I made...

Re: Error Message "Reserved Error ( -1104); there are no message fot this error." what is the number? Every time I open more than 8 then is a problem. But I can open in every pc 8 forms linked to the same database and everything will be ok. So I think it's not about total amount, but amount for...

Re: Error Message "Reserved Error ( -1104); there are no message fot this error." The same error is on few different PCs

Error Message "Reserved Error ( -1104); there are no message fot this error." I get this error when I will open 8-10 forms. -compiled my code -used compact and rapair database button still the same error. only when I will open more than 8-10 form. in every event:/ Maybe it's because, when I...

Almost:)! Result is exactly what I expect BUT I need to use it in sql query:/

Format what I need is e.g. SELECT Format(Now(),"h") & "h and " & Format(Now(),"n") & "min" AS Wyr1; it's just example Part of my code SELECT datediff('h', tblProcesyZleceniaSzczegoly.datarozpoczecia, now()) as czas from tblProcesyZleceniaSzczegoly where identyfikator =1;

Thanks Markk for your insight. The problem is, that I should get from my query 'n' but limit should be 60. Yes I tried to combinated h and n. if you have less than 60minutes difference, then it's ok, but when we have e.g. 70min? then results should be 1h and 10min not 0:70min

I try to use datediff function with format() to count difference between now() and starting time my activity -tblProcesyZleceniaSzczegoly.datarozpoczecia I want to use format 00h and 00min e.g. now - 19:06 starting activity time 20:00 result shoudl be 00h and 54min but when I try to use...

Thanks for your help. Now it works:) :)

still can't write this string properly:/. Guys any ideas?

doesn't work. Could you show me, how all link should looks like?

still I do not know how my link should look like:/

Could you show me this on my strsql link? Then i will know...

without # still have a syntax error

I have problem to implement "short date" in format to sqlstring (syntax) what's wrong with my sqlstring? Ms Access shows me that is something wrong with "short date" part strsqLy = "select datarozpoczecia, datazakonczenia from " & _ "tblPRocesyZleceniaSzczegoly inner join...

thank you for your insight Format(nz([kolejnosc], 9999), "0000") solved my problem.