Records are organized by SSN and they should be sorted by the last two digits (from 00 to
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
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
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.
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.
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.
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.
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
not processed by any desk,
belong to client 1
split among desk 1,2,3,4 equally
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
I have this same routine working for 3 other database systems and I’ve never had any issues with the data. With my new system I have specific records that I need to keep in the Exceptions table but when I run a query to keep specific items within the exceptions table it will only keep the first item and nothing else, like in this example when I run the query it will only keep the records "Proprietor" and delete everything else.