Search results for query: *

Thanks for the help PHV. Fixing the testing of Rs.EOF cleaned up my problems greatly. I now have everything running smoothly. Thanks again.

Thanks PHV! That was the issue. However, I'm not out of the woods yet. Now I'm receiving Error 3021 No current record. Any ideas?

I have a module that I use for running a report and changed the WHERE clause in the SQL in the module and I'm now getting a 3061 Too Few Parameters error. I'm sure I'm just referencing incorrectly in my WHERE clause. I have posted below the code for the module. Sorry if it's a little lenghty...

I ended up getting this code to run correctly so I should be good to go now. Thanks for the postings.

I did some surfing and found this thread on the site. It sounds like it may be what I'm looking for except it doesn't run correctly for me. I'm running into the same problem that Sera was having of it asking for like a criteria value upon running the report. I thought maybe someone else would...

rssql, Thanks for your continuing help. You are definitely on the right track now. The only thing is that I need this to be dynamic as it will be unknown how many entries there will be depending on how many drivers there are on a certain night. The end result needs to look like: Hobby Stocks...

Thanks for the reply. I understand all of that but what I want to know is can I have new records inserted on the same line and then word wrap at the end of the page instead of starting a new row for each record? Thanks.

I was wondering if there is any way to format a report to look more like a text document than columns? Here's what I'm talking about. I'm doing a racing database and I need the following fields on the report: Class_ID, Heat, Rank, Car_Number, Driver_Name, Address. I have a Rank table that...

Thanks a lot AceMan. That did the trick.

Is there any way that I can set the default value of a text box on a form to be what its record number is for that specific form? Basically I want the default value to be the number that shows on the bottom of the form in the navigation section. Thanks for the help.

I am creating a database that should be fairly simple. The database is for a local racetrack and I'm stuck on how to enter in race results. I have four tables: Driver, Rank, Home, Class. The form to enter in the results contains a main form with a subform. On the main form there are two combo...