Search results

Hi, I've developed a MS Access application (UI) having linked tables from SQL Server. The application would be used by multiple users (about 8 users) for record creation, deletion and update through forms (TextBox and ComboBox controls). I was able to achieve/complete the development until...

Hi, I have a master table which has 2 columns i.e. Codata and Keyword, below: CoData -------------------------------------------- KeyWord BBNRM PRE UNIVERSITY COLLEGE FOR WOMEN ------------ UNIVERSITY NOVOFLEX MARKETING PRIVATE LIMITED ------------ MARKETING RAY LOGISTICS SERVICES PRIVATE...

Hi All, My team uses the attached macro enabled file to identify the geocodes for the address appended into the tool and the tool does a perfect work. But now the requirement is in addition to the geocodes the team also needs the location address of the identified geocodes. Need your advise...

Hi All, I have a .mdb file which has about 20 tables in which I need to rename the latest created table. Now to identify the latest created table I am using the below query: SELECT a.Name, a.ID, a.DateCreate FROM MSysObjects AS a INNER JOIN (SELECT Max( DateCreate) as Latest FROM MSysObjects...

Hi Guys, Need your help in cross tab the below table: Note: I would be doing in MS SQL Environment. ID Tel1 Tel2 123 1111 3333 456 2222 4444 into Id Tel_ID TelNo 123 Tel1 1111 123 Tel2 3333 456 Tel1 2222 456 Tel2 4444 Thanks guys for...

Hi Guys, I need some of your valuable advice for the below pointers: 1) Would it be a good idea, if I use buttons as indicators. 2) If yes, would it be possible to have two colors i.e. red and green. Condition: If the access file has a table named “Working” then the button color should be in...

Hi Guys, Need help in writing a SQL query in Ms Access with respect to ranked comments: Ranked Comments: Comments Rank FullName_Tel_Dup 1 FirstName_LastName_Tel_Dup 2 FullName_Fax_Dup 3 FirstName_LastName_Fax_Dup 4 Source Table...

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

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

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

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

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

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

Hello, It would be great if anyone can help me for the below mentioned requirement. I have a table which has around 25 columns having unic headings (tble name - Worked_File). All I need to do is populate only the headings of all the coulumns through a button click to a list box. Thank you...

Hello, Well I want to create a access file which would happen to be one of the database for my organization. My question is which way would be the best way to share the access file among multiple users. I tried doing split database but unfortunately i figured out, that same record is...

Hi, Requesting help for the below mentioned: Can we update the user name/computer name into an exisiting access table for the top 10 records via SQL query. If yes, then please help me in building the query else requesting to provide suggestion for further alternatives to update. Table...

Hello, I have a form dirrectly linked to a table. The table has a particular column which has only unique Ids (Lets say the column name as "ABC"), to be shared and processed by multiple users later on at the same time. All I want to do is execute a autofilter vba code on column "ABC" so...