Macro Help

[Djbell]

Hi

I have a macro that opens up a table, selects the first record then cuts that record and pastes it into another table. What is happening is when the macro finally cuts all records out of the table, it give me an error because it can't cut an empty record, so it quits the database. What I would like to do, is get the macro to check the record in that table to see if there is any information in that record, if there is no info, I want the macro to stop, else I want it to continue with what it is doing until it comes to the empty record then stops.

Hope you can help

Regards

Djbell

 

[mymou]

Hi Djbell

Sounds like you're doing things the hard way.

Why not have two queries - one append query and one delete query - linked to a button to do the same thing?

Stew

 

[Djbell]

I cant, the query also runs a piece of code that creates a specific number of pages in a report based on a given number size, it only works on one record at a time, so its got to be like this.

Regards

Djbell

 

[chrissie1]

i think the function isnull will help

but i think if you learn to use visaul basic code you will see that what you are trying to do can be a lot simpler Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong