records

HI guys i have getting a problem about my userform for updating records . i have 16 TEXTBOX in my USERFORM and to get the the data i use search button in my userform. well the problem is when after i search the data and update it when i click the update button the data that i updated was...

My data is as follows...6 columns....Duplicate data in col A and col D....need to be attended to <tbody> AAA xxx yyy USD zzz www AAA USD BBB abc swe INR wed fde AAA CAN CCC CAN AAA INR DDD USD BBB INR EEE ROU BBB SRT BBB SRT CCC CAN CCC MYN CCC MYN...

Hello guys i want to get only 1 record from a duplicated records because i have many duplicated dates i just need the oldest record, the formula im using is computing all the training hours for the whole month. Can someone help me with my formula Thanks!! =SUMPRODUCT((MONTH('ABN...

Hi, My name is Gagan and I am new to this forum. I request your help me in creating a macro which gets triggered once the user completes entering a value(Yes) in column K. Click here Source file. User sheet is the working sheet where the data will be populated. The source file is the mother...

Is there an easy way to delete all the records in a table? I don't want to delete the table, just the records. Thanks

Hello Friends, Need the expert guidance from you. I am new to the VBA world. My problem statement is as follows: Problem Statement: There are 4 sheets in my workbook - Pending Old SP, Pending New SP, Onboarding Dump - Old SP & Onboarding Dump - New SP. Below is the manual process that i am...

Hi all I am fairly experienced with excel and have a moderate degree of visual basic experience, but I am very new to excels query editor. I have a query that contains approximately 36000 records that tracks a work production system. It creates a record every couple of minutes of a production...

I am trying to do a filter where either I select records where field 18 equals the variable Ans and field 22 equals Ans4 OR I want to select records where field 30 equals the text "Other" ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=18, Criteria1:="=" & Ans...

I have the following code as an On Format event for the detail section of a report. If Me.txtReferralReturnedDate = Null Then Me.txtReferralDueDate.Visible = True Else Me.txtReferralDueDate.Visible = False End If The report returns multiple records, making the txtReferralDueDate field...

I have a pivot table which counts the number of records per category. I would like to filter it so it only counts records that are older than 100 days. I added a filter to the pivot table area for the age of the record but to filter I have to check each box for any value over 100 and that is...

Hi everyone - There is only a ExportWithFormatting action in Access and not "without", which limits the amount of records that is truly exported (65,000 records). I have a table and it's 300,000 records that need to be exported to excel using a Macro. Since the action does not exist, I need to...

Hi All I am wanting to seek assistance in with the attached link: https://ibb.co/z5GwQRn In Table 1 I have COL D which has multiple records separated by a comma What I want to achieve is what I have displayed in Table 2 So each of the records in COL D will have there own row but still have...

I would like to combine records into a query. For example, the table would be Jane, Doe, teacher, math Jane, Doe, teacher, English I would like the query to have: Jane, Doe, teacher, math English

I've imported records to a table to take the record count to 90,000. When I open a Form I have which has been used for the previous records (previously 48,500) it is only displaying the previous records and seems to be ignoring the newly added records. I added the records yesterday thinking it...

Hi all, I have an existing database that needs to have a large number of records archived from various tables. In the future they will be archived according to a set of criteria, such as the age of the item and its status. My understanding is that I need to be very careful of respecting...

I'm trying to create a button (on a form) which applies 2 different filters at the same time. 1. Only Show records which have the same 'BO' Number as the current record AND 2. Only Show records where 'Status' is Blank I've tired a few ways but I can't see to get it to work. Does anybody have...

Greetings All... Full disclosure - This was cross-posted on an Access Forum as I was uncertain where to go with this post..Thanks Both code snippets are written in Excel VB Editor and are designed to simply extract data from Access and place it on a specific Excel sheet in a Specific Range...

Hi all, I have a repetitive process that I am trying to automate which consists of the following steps: 1) Take 5 pieces of data from a record on worksheet A with 200 records and input those pieces of data into worksheet B 2) Take Worksheet B and save the tab as a PDF in a new location 3) Name...

I would like to be able to include my income (various sources), deductions, taxable income, federal tax paid, state tax paid, tax percentage, etc for the past 20 years. I have the data from my income tax returns but am not very good at setting up an excel spreadsheet. I don't mind entering it...

Ok, I am trying to figure out a way to move records from one worksheet to another, my biggest problem is: Each row in the source worksheet can have up to 3 records, and those records have identical column header titles. I also only want to pull certain columns over to new worksheet. Here's how...