Topics Search

Split records

Split records
Views: 8
I have a list of over 20000 records and would like to split them based on different percentages between different users.
Records are organized by SSN and they should be sorted by the last two digits (from 00 to
Sponsored Links:

More topics

 

Copy records from split form's datasheet section to another table

Preview
I have a split form (frmPatient Schedules) that shows me my records in the datasheet view at the bottom section of the form. My records have a field with a checkbox (ckbxHOLD). How can I get the records that don't have their checkbox checked to be copied as new records to a different table (tblHome Visits
 

Split Forms

Preview
I am attempting to design a split form where I would like to filter the split form to show only show those records of a particular member chosen by a combo control on the parent form
 

Split Database Issue

Preview
I have a split database. This has a "multiple items" form (acting as a record search form called frmSearch) where they are able to click on the row and it will open up the detailof the record on a different form (frmLostItemEntry).

Now, this works perfectly from my home computer both before and after the split. Once I split it on my company's network this is what happens:

When you click on the row in frmSearch, the detail from shows up blank for records added after the split. If the record was added BEFORE the split the detail shows up correctly.

Here is the code that is in the OnClick event of the row in frmSearch
 

Split Form Issues

Preview
I'm having problems with my Split Form. I have certain code in the On Current event of my form, and when selecting different records with the record selectors on the bottom of the form, all the code executes perfectly (hiding controls, etc.). However, when I try to select different records with the Split Form datasheet record selectors, the same On Current code doesn't execute. Is there a way to work around this? It seems like the Split Form doesn't adhere to the On Current event.
 

Split Form Issues

Preview
I'm having problems with my Split Form. I have certain code in the On Current event of my form, and when selecting different records with the record selectors on the bottom of the form, the code executes perfectly (hiding controls, etc.).

However, when I try to select different records with the Split Form datasheet record selectors, the same On Current code doesn't execute.Is there a way to work around this? It seems like the Split Form doesn't adhere to the On Current event.
 

Filtering split form records from combo box

Preview
I have a split form with a combobox.
How can I filter the records displayed in a form based on a combo box selection?
Can someone explain how to build this mechanism and write a sample
 

Problem copying table in split database

Preview
This is a split database. My goal is to allow the user to click on a control and delete old data from several tables to prepare the database for the next event.
which is supposed to copy a table (Attendance) to a new one (BackupAttendance) and then delete the records from the original. However, the records in both tables are being deleted and I don't know why.

I know I can simply copy the back end to a backup file and delete the records, but that doesn't automate the process.
 

split form select records based on a criterea

Preview
first post.
I had been using excel to track some basic data on some assets but it has grown to big and I require better query abilities. anyhow I am using access 2007 and my database is like this
table: assets; serial number, model, purpose, etc
some of those such as model and purpose are related to other tables that list models and purposes
I have a form where I have me and a few other people make changes. It basically just limits access to stuff like serial number but.

It is a split form so it shows all records at a time but I want to be able to filter the shown records based on the purpose and/or model I just need help how to get it to show the list of records that meet the critera.
 

Retrieve rows from 11 to 20 ( Selete TOP 10 gives first 10)

Preview
Using 'Select Top 10' gives me first 10 rows of my table. I need to retrieve the next 10 records.
I am writing to an excel spreadsheet where I need to write top 10 rows starting from B2 and next 10 records starting from I2. So how can I split them? Every time I have to split into 10rows each.
 

split records based on the values present in another column

Preview
I am trying to update a table which has a zillion records. the columns in the access are shown in the attached excel file

I want to update the column "Send to" based on the following criterias:
1. same state
2. not processed by any desk
3. all customers from a state should be services by one or two three or all four desks equally

e.g.1
State PA
not processed by any desk,
belong to client 1
split among desk 1,2,3,4 equally

or
e.g. 2
state FL
processed by desk 1,3
belong to client 3
all customer that belong to state FL from client 3, have been processed by desk 1 and 3 should be equally split among desk 2, 3

I have been trying to update it manually but there are around 3000 such record which belong to e.g.1 and e.g 2 and so on that its becoming very difficult to update records manually