Recent content by clickaccess

Thanks Ken Reay, that did it. Click Email Service Free from Banner ads. http://www.SacMail.com

I am attempting to populate the table [numbers] with this output. I keep getting Error 91, "Object variable, or with block variable not set" Unable to figure this out. Pls help Click CODE> Private Sub Command0_Click() Dim ThisDB As DAO.Database Dim v As Integer Dim w As Integer Dim x As...

Fneily, I need it to create a sorted list (CA lottery does not provide a sorted list on their website) and carry a printed version so that I do not play the numbers that have already been picked. Why spend a doller on a number that is already a winner. I under stant that this is random, but...

Hi, I want to sort the past winning number for a local lotto. Sample incoming: F1 F2 F3 F4 F5 31 15 1 2 20 35 39 8 26 19 7 28 27 36 12 25 28 29 9 4 16 4 2 19 35 32 23 39 19 31 26 31 33 12 23 30 9 26 22 21 35 4 13 1 32 Sorted sample: F1 F2 F3 F4 F5 1 2 15 20 31 1 4 13 32 35 2 4 16 19 35 4 9...

Thanks, I suspected the POP-Up, but that was already set to "NO" on the switchboard. So I set the POP-up on the message form to "YES" and that did the trick. Thanks for quick response. Click Email Service Free from Banner ads. http://www.SacMail.com

Hello, I need to have a message form to be on top of the switchboad when the database is oppened. I am able to show both forms, message and switchboad, but the switchboard is on top thus hiding the message form. Quick response would be great. Thanks click Email Service Free from Banner ads...

=IIf(HasData,Count(*),0) works! thank you Click Email Service Free from Banner ads. http://www.SacMail.com

Thanks, I will try this out tomorrow at work. Click Email Service Free from Banner ads. http://www.SacMail.com

Hi, I have a report that through query counts the number of records in a table for display. My problem is that if there are no records I am getting "#error". How can I display a "0", if there are no records? in the text box this i what I have, =[table].[count] Thanks Click Email Service...

Ed, This is awesome, works like a charm. Thanks Click Email Service Free from Banner ads. http://www.SacMail.com

Request an enhansment to the table naming. How do I attach the number of records in the table name? Like in the above example: tblRED_59, where 59 is the number of records in that table. Thanks Click Email Service Free from Banner ads. http://www.SacMail.com

Thanks Ed, It worked beautifully! I had to create 40 such tables manually from excel in Dec. Now with a little refinement this will reduce time and increase accuracy. Thanks a bunch Click Email Service Free from Banner ads. http://www.SacMail.com

Thanks for responding, but, there is no telling if the RED is in the main table, there could be any other color than the one I mention above, further more I have seen as much as 25 different colors in that table. This needs to be automated, and yes, VB is perhaps the best way. Thanks Click...

Hello experts, I need to have tables generated based on the key field in another table. For example the only field in the color table has these values: BLACK, RED, PURPLE, WHITE. The main table has on the average about 50,000 records, and in the color field the above mentioned values...

Thanks, I will study this one and get back to you. It may be a while. Click Email Service Free from Banner ads. http://www.SacMail.com