Howto change x number of found records from database at the same time 2

[Nikosis]

Hello

Lets say I want to print a list of friends addresses filtered by a city. So out of 100 records I've found "n" records of people living in a given city. It prints out just fine, but after that I have to go and mark checkbox as "printed" for each one of these records manually,
Is there a way to mark them all as "printed" by the time I hit print button.

Thx
Andy

 

[2ffat]

What database are you using? Also, what components are you using?


James P. Cottingham
[sup]I'm number 1,229!
I'm number 1,229![/sup]

 

[Prattaratt]

Since you are filtering records from a Database, I am going to assume you are doing so using SQL queries. You can create an update query to update all the records you have filtered, and run the query immmediately after printing, or even as a part of the printing process. The following SQL code can be used to conduct an update similar to what you want

UPDATE Friends SET Printed = true 
WHERE City IS "SomeCity"

 

[Nikosis]

Yes, I'm using .mdb ADO SQL queries.
I'm gonna try that right now.

Thx
Andy

 

[smays]

Try:

UPDATE Friends SET Printed = true
WHERE City IS 'SomeCity'

(Replace the double quotations " " " with single quotations " ' ")


I was wondering whether the Access SQL engine supports the 'IS' keyword. Obviously the Access SQL engine does indeed support the 'IS' keyword. To determine that, I came across the following website:

http://sqlserver2000.databases.aspfaq.com/what-are-reserved-access-odbc-and-sql-server-keywords.html

Steve.

 

[Nikosis]

So far I can't get it to work, problem is that I search in 3 different fields, so it is difficult to determine what is used as a parameter to search in the database, on top of it, my search button opens up another window with preview and all kinds of format verifications, zooms, etc..., so from there I can actually print the page. I will try again, to make it work, but out of curiosity is there any other way to do it, lets say with record count and from there go from one row to the next one ?

Thx
Andy

 

[2ffat]

Can you show us the SQL statement you use to select/filter on?


James P. Cottingham
[sup]I'm number 1,229!
I'm number 1,229![/sup]

 

[Nikosis]

These are my statements

SELECT * FROM Event WHERE StatusComplete='F' AND LastNameID LIKE :param ORDER BY StartDate ASC
SELECT * FROM Event WHERE StatusComplete='F' AND CityID LIKE :param ORDER BY StartDate ASC
SELECT * FROM Event WHERE StatusComplete='F' AND StateID LIKE :param ORDER BY StartDate ASC

 

[smays]

You show three SQL statements, which puzzles me. Does your program react to the data from each query individually one at a time?


Assuming you need to UPDATE the database *when* StatusComplete='F' AND LastNameID LIKE aram AND CityID LIKE aram AND StateID LIKE aram then the following is basically how your UPDATE query needs to read:

UPDATE Event

SET StatusComplete = 'T'

WHERE StatusComplete='F' AND
LastNameID LIKE :param AND
CityID LIKE :param AND
StateID LIKE :param

By the way, are you *really* wanting to update the database? Or are you wanting to simply update something on the main form? For example, say you have your list of friends in a TCheckListBox and you have a TButton assigned to send to a printer the data associated with each friend one at a time. Perhaps you are wanting checks to appear to the left of each friend's name as the friend's data is printed. Is this what you are wanting to do?

Steve.

 

[Nikosis]

Yes it does.
I'm not looking in 3 diff fields at the same time, it's a radiobutton choice. After I hit print it opens up another window with previews, for the last check, and from that point button "ok" prints the page, and updates database hopefully, but radiobuttons are not there so I can't use "if", how can I determine what sql command was used, in order to update only these fields that are printed out.

 

[Prattaratt]

As long as the form is still open, you can still access the controls on it by way of: Application.Forms("FormName").Controls("ControlName"). If you close it out during opening of the Preview window, then don't until after you have updated the DB. If you are printing from a report or form, you can use the Record Source property to get the the SQL statement if you used a direct query, or the Query Name if you used a Saved query. If you used a saved Query, you then use CurrentDB.QueryDefs("QueryName").SQL to get the SQL statement.