Search results

Hi, in Access, we may have a text field like this Tare Weight 2100.000KG , and by using the Val function, we can make it like this Tare: Val([Tare Weight]) = 2100 Is there something similar and simple in excel? To have a cell "10 t" and in function =sum, ignore text and use only digits ?

Hi, just Plaka (without La) we Greeks don't have La or Los as Spaniards do.

This experience is from last years without pandemic. Itineraries to/from Greece on standard or charter flights, is easy, cheap and good frequency. Venues in Greece nearby int' airports, too many. Prices, hmmm, I say Greece because I am Greek, maybe it is easier and cheaper in another country...

I mean that, we can either click, or double click. Is there any way we click, keep mouse clicked for an amount of time, say 3 seconds, and if continues clicked 3 seconds the code starts ? I this property: Auto Repeat = Yes. similar ? My purpose, i have a code that i click (or double click)...

Just to give few more info about my purpose in here. I am a casual access user. I know very few about vba, I don’t know how to make one code from scratch. With your assistance (*) and by browsing youtube, I have reached a good level of productivity in my business. I have created very...

Hi, when user assigns a code to a command button, he has a large amount of options such as on click on double click on got focus on lost focus etc. Could we make an option that the command is fired when we click and keep pressing it for more than 3 seconds ?

Hi What will be the impact if we go VBA , tab TOOLS, option References and we click ALL available references ?

Hi, I create a query which convert to SQL view, then paste on VBA page. Now i add the below on SQL and problem is solved. "ORDER BY PartNo "

I have tried once to convert to ACCDE but i got other kind of issues. I don't know how easy is to return to accdb anyway.

Yes, sure, yet, there are moment with huge amount of stress that lead to mistakes such as this one.

Hi , suppose we need a second excelsheet on the same work book (another affiliate report) I understand that after the "end with" at the bottom, i should start a new "With xlsheet .... End with" and update the lines in between. However not sure what should i type after the green remark

Hi there Is there any way we could “lock” and protect the form layout? during copy paste, or other browsing on the form, filters etc, I have accidentaly deleted or moved controls to another location. Okay, data is there but I have to repair form. Sometimes i open the usual form and I find out...

Hi, i use a code as per first post in this thread, a code i found last year and i adjust it. No, the data is not sorted us per query sort order. I don't know what is access doing. If i start entering records, (say 10 records from id 50 to id 60) then stop, close form and continue after some...

Hi Majp Just to give some more info, i download tables from our business system, then i process and automate several tasks in my daily activities at the office. I need to use this in a query field so the above function, is way to advance for a casual user as I am. I made the below and works...

Hi, apologies for my bad English and as a casual access user, i am not using terminology very precisely. When i say "reports", i don't mean the access reports. General, business reports which i send in excel. Before, i was creating each report from scratch. Now i use access queries and export...

Hi, yes i did, however, the "text" that holds the date is 211130 , yymmdd, by using CDate(Format([TextField], "00-00-00")) , i cannot convince the system which two digits relate to yy. I don't want to change my whole system settings as this might affect other sections, anyway, by using the...

Hi, self life of this code is just 79 (or 78) more years, then disaster .

Hi, just to be on the safe side, i used string functions and tailored date in the desired format. Thanks anyway for your input.

https://www.access-programmers.co.uk/forums/threads/exporting-data-from-access-to-excel-in-format.309007/ Hi The above thread, in which i mastered the way of exporting formatted excel from access, has help a lot, i complete fast complicated reports. Now i have a new report that i made last week...

Hi, i have a text field consisted of 6 digits as this format 210922 , the first two digits is the year, the next two the month and the last two the date. I want to convert it to date value, is there any way to converted as 22/09/2021 ? I could use string functions but, is there is any faster...