Search results for query: *

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...

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...

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...

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...

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...

My SQL statement works fine but I want to aviod "Enter Parameter Value" box to pop up for form filed entry. What is wrong with tis statement that It cannot read the form input itself? do not want to do it in VBA. SQL: SELECT ContactGroups.ContactType, ContactGroups.ContactAddress FROM...

Hi, I am trying to have a message pop up on a form if a criteria is met. The the table to lookup criteria is not in the same domain. query explained: <<< IIF (DLOOKUP([form name].field, lookup table, look up field)=Yes),"Must Have State Mandated Application","")>>> here is the query: IIF...

Hi, I need to read the data from access table1= (example: field1=5, field2=9, field3=0) than apply a formula (example: field1-2=X, field2-4=Y, field3-9=Z, get the total sum of each record) and store the results of X,Y,Z, and the sum in table2. There are 4000 records in that db. Don't know a...

I am including a command button instead of the standard nav. buttons but they won't show up in the run mode, but are still there in design mode. I have checked to see if visible is on, it is! any suggestion? Working on a FREE email. Feel free to sign up. http://www.SacMail.com

Hi Gurus, I'm new here so be gentle with me! I am writing a database that will have a Master db and about 50 Slave dbs that will feed to the Master. I have figured out how to append from the slaves to the Master and it basically works. Now, what I need is to do is to make it efficient in...