Search results

Hi Guys, I have been asked to work on a project in which I need to select and import a specific table from a access file located in shared drive to an access file located in my local drive. So far I have always dealt with importing excels files into access and never dealt in importing access...

Hey Pat, I understand your point. I will try to share a sample of my database in some time to explain my requirement. My database is of 1.5mb, let me check if I can upload it. Thanks, Rakesh

Thanks Gina and Ridders for your help .... @ ridders - Just 1 question out of curiosity if I do not give users, write permission to that folder located in shared drive then would my users be able to update or add a new record to database through the FE? Thanks, Rakesh

Hi Guys, I have developed an MS Access database (2016 Version) consisting of tables, sqls, vba and macros for my team. The next challenge is, my team is consisting of about 40 associates and they need to update this database on a daily basis. So far, my thought process is to split the...

Hi Guys, I have a requirement in which I need to carry forward the result value of a previous record to the Actual value of a new record and this process to continue until the result value gets to 0 and all this is happening in an access form. For e.g. RecodStat | Actualval...

Copy Paste .xlsm file by browser option enabled Hi, I have a code (below mentioned) which (in access file) will copy and paste a .xlsm file from one location to another location. All I want is to get a browser option while pasting the .xlsm file. Request to see the below code and help in...

Thanks for your reply. But over here I already have a access database which will open the excel file (excel file is a template file), update, save and will close the excel file. And the same excel file is accessed by multiple users which leads to excel file corruption very often. So I need...

Hi, Have a requirement in which I'm really confused how to proceed. All I need to do is copy an excel file from a location (while coping the file, the location of the source file remains same all the time)and paste that excel file where ever I want (Browser Option) from an Access VBA...

Well ur very correct pat but as u know in corporates we are not the decesion maker in fact we are just decesion followers. Hence, no offence but I myself in a deep situation at present. Therefore really scratching how to get this done. So far I have got this thing manually operation able but...

Hi, Well actually u r right in using of a spread sheet but lately we have got our projects increased from 2 to 39 and its really getting painful in managing all the spreadsheets at one time and then the real.trouble comes.while maintaining the reports. Therefore we decided to get it done in Ms...

Hello, Did Google search for the query but didn't find an accurate solution. Hence, posting in this community. I have a table in MS Access naming "Salutation" and in the table I have 6 columns and each column named as Week No., Carry Forward records, new records, total records, processed...

Hi billmeye, Many thanks for the support... But honestly its really difficult to understand the code which is available in the link you provided. Requesting if you could possibly explain me few things about the code like e.g. which are the table names refered in the code, where this code...

Hello Masters, Requesting to please help me for the below mentioned requirement since I don't have any idea how to proceed further: Well, I have two tables in an access file one table having customer data base along with the customer name and another table only having the customer name. Now...

Hello Evangelina, Well about what software are you refereing to...because i am still struggling to do this :banghead:. Any help from anybody is much appreciated about the below requirement. Thank you, Rakesh

Thanks pwbrown for ur inputs... But actually what i was thinking of is calender control extraction from database.. Thank you

Hello, I am preparing a tool where in the user has to manually input the data on regular basis and the same thing (Table) must get exported to excel on weekly basis for reporting purpose. So far everything looks fine but stuck in exporting the table data to excel by dates or any date...

Hi, I do understand the risk factor for getting the concateneted values updated in the same table but what to do this as per again the requirement. Again, after i get the concateneted values updated i got to run a unique/duplicate as per below: Concatenate value uni/Dup aa...

Hello, Is there any way to concatenate all the items listed in listbox and obtain the value in a purticular row of the same table. note: The listbox items can be varriable. Thank you....

Hi Narang, I tried the code which u have provided for item transfer with in list box and it works fantastic.... But what I was thinking is perhaps i can do a complete movement. For e.g. lets say in listbox1 we have A,B,C,D (items) and after i select A from listbox1 it should get removed...

Many thanks every body for the help.... @ Narang thank you very much for the help it finally got worked.....Ur a life saviour.....:) Just for the knowledge want to ask one more question.... After having a multi select in the 1st listbox, can i move the selected feilds to a different list...