Search results

Hi Everyone, Just stuck in the middle of my project. What I'm trying to do here is, update my access table ("Table1") from excel sheet ("Myexcel.xls"). Excel file contains all the information however access table is not updated except "RefNo" field. Condition what I coded here is when once...

Hello experts, Just returned to my favorite forum after a long gap to get help from you all. Actually, I have a access database with table name: UserDetails. Its having three column: From Subject Received Status James Lewis Binder Task...

Hi, I have a table called "Data" with following fields: 1) CompDate 2) LOB 3) Task 4) User Need a query or VBA to bring random records with certain % (ie. 20% or 30%) of each User withTask wise For example: User "Abhinav Verma" has done in total 17 "Binders". Need to show only 30% of...

Hello Experts, Thanks to all who helped me out in past. I would say this is the best place to get your answers :) Need your help again .... I have a database where there is a table in which there are some set of data. Now I want a query (LastestInception) to display only the lastest...

Hello Experts, I am facing some problem while adding records into two tables from single form. I have used adodb.recordset to do so. However its work fine when its come to adding into single tables (example table: "Data1"). Table1: "Data1" contain following fields: > Task > User > Address >...

Hi All, I have an form with textbox (Text146) which is use for Hyperlink. I need to click command button to find the file and link it. However its showing full path into the textbox (Text146) which I don't want user to know the path. I would like to show only "Snapshot" word into the...

Hello, I have a form where there is three fields: 1) Combo376 (Combo box) = Value list "US" or "WW" 2) Text358 (Text box) = User need to enter number of locations (any numeric value) 3) Text378 = this field show the TAT calculation and this value comes from following formula: Me.Text378...

Hi, I have a very simple problem which I'm unable to figure it out in VBA. I know it would be easier for you all. Well I have a form where there are numbers of fields. Now what my senior want it that whenever form load any field which having data (value) in it, disabled it to stop editing...

Hello, I have a form where there is a button which export my query "qryReportsBureauT" to excel asking user to save the excel file first than it will open automatically. My problem is that the export data in excel file doesn't look like in good format. What I want that the format should be...

Dear MVP's & Experts, Recently I am trying to build a search function on a form where there is a subform which is relate to query. Through few Combo box selection, I need to search item into subform which has been placed on main form. Also there is a Reset button which will reset the search...

Hi All, I have just checked out following link where there is a sample .mdb file which track idle time and logout user from the database after a certain time. Could anyone help me out to view the codes and modules in sample file attached (HRForm.zip) in below link as I am unable to view...

Hi All, I have a database (sample attached) with three forms: 1) Startup (Flash screen type, will close in 5 secs) 2) MainMenu2 (will be open after flash screen close) 3) MainMenu1 Want help in opening these forms (MainMenu2 or MainMenu1) after Startup form close only when some criteria...

Dear All, I am developing an access based report, but I am stuck with some issue. a) In my query “qryreportsTA” I want to have a month column as per received date. Its easy to do in excel (sample sheet attached) however not able to do in query. b) I am not able to create a report in...

Hi All, I have a access database which mainly deal in searching items from a table through form. I have a search field on a form which search the record through query however there is another search field (marked in Yellow colored) doesn't search the required item from the list search through...