Search results

Hi, I am trying to attach an xlsx file but the "attach file" button doesn't see any xlsx format files ??!!

Hi arnelgp, now i need a function which will tell if the field in id line 10 is same as id line 9, if same we mark as 1 in not same we mark as 2. In excel the formula would be made very easily - at cell B2 - "=IF(A2=A1,1,2)" Can we make a function in access as above that will tell if id 1...

Hi, now i need a function which will tell if the field in id line 10 is same as id line 9, if same we mark as 1 in not same we mark as 2. In excel the formula would be made very easily - at cell B2 - "=IF(A2=A1,1,2)" Can we make a function in access as above that will tell if id 1 is same as...

Many thanks Arnelgp, i don't know how could i offer you a beer or something.

A: iff(SOMETHING, THIS, SENDKEYS CTR+" ) Hi, could one query field, which is structured as above, work ? My need is to fill all blank cells in a query, then i append all records to a table. In Access we can copy paste the record above with ctrl "

Hi arnelgp unless i haven't understood well your method, the MainF form contains very few basic fields from Tabl1,2,3 in a continues form, one line each. You can view 40 records or more on the screen, by scrolling you can inspect, very fast, 200~500 records a day. The purpose this form is to...

Hi there. I have three tables, Tabl1, Tabl2, Tabl3, relation one to many. One continues form (MainF) that contains the very basic data from Tabl1, Table2. Another three forms that displays detailed info from Tabl1, Tabl2, Tabl3 Tabl1F - Tabl2F -- Table3F We need to, review the summary data...

MS Access data merge to Word Hi everyone. Merging from Access to Word is very handy. Is there any way we could house all 6 steps under one macro or another method? My data is displayed always in the same structure, same field name, my word document template is always the same. I pin fields...

thank you arnelgp, i am trying to perform all this in vba through ms access. Just to give few more info. In one shot, i need to copy paste in the (MS ACCESS) vba editor chinese, and see chinese, not ??? . In more shots I am exporting a report from ACCESS to EXCEL. In access all data pieces...

Hi, indeed, i can also copy paste the Chinese in table or form label without problem, but i can't copy paste in the vba editor .

Hi, many thanks, i don't want/need to bring another language in my keyboard preferences/ I want to copy paste a text from Chinese and appear in VBA as is, now, when i copy paste the chinese fonts turn to ??? This Chinese text will appear in an excel form header

协议号 Rate Item or AF No: Hi everyone In a VBA line, i want to write the following. .Range("A3").Value = "协议号 Rate Item or AF No:" But it turns out like this .Range("A3").Value = "??? Rate Item or AF No:" How can i convince VBA to accept this - > 协议号

The last I would like to freeze panes in line 10. If i try the macro on excel, i get the below. What should i do to transfer this one on the Access VBA code ? Range("A10").Select ActiveWindow.FreezePanes = True

Thank you ore Gasman . ... thats it

The k colon (from k10 to k3000) contains data of three letters (PIR or SHA or RTM or several) and i need to count how may PIR we get , how many non PIR we get. P.s. I am not sure what "variable" means in here

Hi there The code that I have used and works is same as this example, i export to excel with formatting. http://accessjitsu.com/2015/09/13/code-listing-exporting-data-from-access-to-excel-part-5-formulas/ Now, in another similar export with formatting i want to use formulas I have tried to...

Hi I have been using ACCESS in my daily job (shipping-transportation-containerization) for over 15 years. I was performing a lot of tasks with excel, then I moved to access as excel wasn't very helpful for data storing and more complicated "relation-wise" business needs. I have started using...

"relative to us." You mean, "us", the Earth and the minkind ? us= our solar system ? Define the "us". The Universe is expanding relative to stellar observations made by Earth.

Since 1920 or 1930, this is confirmed by telescope data, Edwin Hubble was the astronomer who first proved this. https://en.wikipedia.org/wiki/Edwin_Hubble

Malakes and malakia exist everywhere and stil govern the world I am afraid. For these unknown words, check a Greek English dictionary. In Greek μαλακία μαλάκας , because google translator gives a wrong result. Because the Universe is expanding, not shrinking, we have no idea what was the...