Search Result

Hi,

I have a form A that contains a subform B listing the names of potentially multiple people all associated with the 1 record displayed on form A. That part works just fine.

Now, I want to be able to create ONE line (NOT just a subreport listing all the names from the subform) in my associated report that basically loops through all the records, pulls out all the names associated with that one record, and lists...

Hi, im doing a CD library database and i have two tables, "CD" and "CD Copies" linked by "Catalogue ID No" field. Bellow is a picture of what i mean (click the link below it if it doesnt work!):


https://picasaweb.google.com/1167658...75094040621826

I would like to return the number of "CD Coppies" a selected "CD" has,...

Okay, simply put I need to write a query that will return x number of groups of y number of groups that each hold z number of records.

Example:
There are four teams (x)
with 15 team members per team (varying on the day) (y)
and we need to pull 350 records per team member (z).

Each team member needs to have a distinct set of 350 records from the database.

Help? Please?

...

I use this code to append one record at a time to a new record in a table and it works 100%. Instead of this, I would like to append all the records currently captured and filtered using the Racename field (as it is happening now), but using a button when i exit the Racesetupf form. In other words, append these records as a batch and not as single records. How do i change this code to accomplish it?

...

I'm looking for a simple Query to replace the values of all items in a column of a table with another value.

1. We have an MS Access database with this name: "MyDatabase.MDB ".
2. Our mentioned database has many tables. But, let's choose "tblDemo" here.
3. Our selected table (tblDemo) has many columns. But, let's choose "colName" here.

Now, I would like to change the value of...

Hi all,

I'm having difficulty catching error 8511, which states:
"Records that Microsoft Office Access was unable to paste have been inserted into a new table called 'Paste Errors' In the Database window, open the new table to see the unpasted records. After you fix the problems that resulted in the paste errors, copy and paste the records from the new table."

What generally happens is people copy data...

I need to keep copies of deleted records.

Say there is a contact/record the end user no longer needs from our Contact database. He wants a button to delete the record. Our compliance officer wants us to keep a copy of that deleted record in another table.

What's the best method to do this? I would like a method going on behind the scenes of one button the end user clicks to delete the record.

Thank...

Happy Monday,

I have a table (Master) and two queries. The first query (qry A) takes data entered into a form and converts that data into various symbols. The second query (qry B) is an append query and takes qry A and appends the data to the table (Master).

When I open up the Master table there is one row that shows the data entered and another row with the same data entered plus the symbols it created. It makes two...

Hello all,

Sorry if this question appears a lot, I've looked all over the internet and can't find a single solution that works.

I would like to add an "All" option to a list box (and a combo box, but I'm assuming the coding is similar enough for me to modify, if needed) that when selected and a query is run based off the selection it returns records that match all of the options in said list. The code I have...

Dear all,

At the moment i am creating an hour registration. Lets say i have a form <hour> and in the form i have two fields:
1. <name>
2. <date>.

How can i create a vb code that if i enter a name and a certain date, that if the date and name match a previous record it will go back to that record? In this way users can change/edit there previous entries.

Hope someone can...

I have a table called Customers, This table has CustomerName, Order, and Order Date:

Customer1 Order A 1/1/2006
Order B 1/6/2006
Order C 1/1/2009

Customer2 Order A 1/1/2007
Order B 1/1/2010
Order C 1/6/2010

We are not interested in records that their Order...