record

I want to create a recordset that contains only a single result from a larger recordset, how can I do this? I have a recursive algorithm that calls itself many times, passing a single record in, and getting a new set of results where one entry will be used in the next step and then passed on...

I have a workbook that looksup values and does reports and has some graphs in it. The graphs used to automatically update when I change the record number of each file. Now it doesn't. It only works if I chnage the record then save the file then re-open it. Help please!! :confused:

The problem I have involves looking for records within 2 tables. Table1, (the source), contains 100 records. Table2, (the sink), contains 1000 records. So to check if each record in Table1 is contained in Table2, looping would involve 100x1000=100,000 times (if I'm not mistaken). If instead I...

hello i like to have help with vba codes : i have a listbox in userform4 i like to add a code to use right click to modify record using userform1 (userfrom1 is used to add new data to list) and to do right click on mouse to delete selected record from list please see file and original post...

I'll use a macro to display several images in a worksheet. Then I'll enter some data in worksheet cells. After that I'll trigger another macro to delete the current images and then trigger the first macro to display a new set of images. All of this works fine. What I'd like to do now is...

i need your help to complete code in excel user form button (save data\new) the user form is to record data in it then when press button (save data\new) the data export to access data base and clear all data in user form to new record how can i to add attached for project thanks

Hi there - I'm kinda new to "Loops." The code snippet below shows that I'm running a loop through column CH and changing the cell color of values in column A based on the results of that loop. The "key" to the loop is the word "ERROR." However, what I NEED to do is to have some flexibility...

Hi all I have a excel database with a capture form (not userform - merely a separate sheet) running Macro to update a different sheet with the information captured in the capture form. Adding it to the last row. Now I need to find a solution to use a similar "capture" form or search form...

Hello All, Is there way to configure MS Access so that the cursor moves to the next record (below) after I enter value (using bar code reader) in a record? We are entering a number of values in a form using bar code reader. After entering every value we have to manually move cursor to the next...

Good Day I have this userform with multiple TextBoxes. TextBox17 has a numeric value in it. When I edit record the rewrite the updated information to theExcel Sheet, I am getting #value ! error on the value column which points to TextBox17. The code for updating record is as follows...

Hi all, I'm trying to record a sumif with 6 different criteria pointing at different workbooks, when I record it, it seems to cut it after a point and replace a bunch of it with a " _ & " As a result, I think I fixed it with this but I still get application or object defined error...

I am trying to figure how to create a csv file with the attributes below for an EFT file. I think using a macro would work. Header Record Field # Data Element Start Length Format Description Pos. 1 Record Type 1 1 X(1) “1” 2 Date 2 8 X(8) System Date; MMDDCCYY 3 Time 10 4 X(4) HHMM 4...

Hi all Can someone help me with the following issue: I have written a successful routine on the userform to find the last entry. I want then to go to the previous record until the user finds the one he/she wants and also be able to return to previous. I have separate buttons for previous and...

I am working on a split form in ms access. I would like my form to not add a record if the Sending_Category = Contractors or Salaries & Benefits, and the Sending_FTE is blank. I have tried this as an on click event for the "Add Record" Macro, and on the form as a before update event. My "add...

How can I record # of times a stock reaches a certain number throughout the day? Currently I only have a function for when it is at that number it returns 1 and if not a 0. i need a running count. Basically I am looking to record the success of a tick fade play. When the $TICK reaches +1000...

Hi, I need to count the amount of times a certain stock reaches a certain price. It is real time data. Also, how can i automatically record this each day? How can I set it to record at only certain times?

HI I want to Import last saved record of particular Name from access database to excel userform. It give me the first record saved for particular name. (FIFO) I want to import using LIFO method/ code please help Regards Manish

Good afternoon all. is there a function in VBA to have a "counter" to record how many times a form gets used?

I have a field that is a Date/Time. It is a required field so I want to put a default in it. I want to add an expression that will give me 90 days from the date the record was entered. I don't think it is =NOW()+90 because I think that includes time. Is it Date()+90?

Hi, I have a file that contains a great number of records as a single, long line of text. The records are delimited by a tilde (~), and the fields within the records are delimited by an asterisk (*). I have second file that is a summary for records in the first file that have some kind of...