Search results

As you suggest I changed the field name from DATE to TblDate, did not get any error stating the name being a reserve name, I than moved the data to the new field and deleted the original "Date" field. I ensure that I used the revised statement, did not get an format errors. I ran the query...

Thanks once again for your help I ran the query without any modifications and printed out the results. I then modified it as you suggested and printed the results. The two printouts were identical. but for some reason it still does not separate between the months. I have put the following in...

Thank you for the suggestion I assume that the ReportMonth: Format statement goes in the Criteria line. When I did this I got a error back: "The expression you entered has an invalid . (dot) or ! operator or invalid parentheses" I kept deleting the item that the program highlighted, but it did...

I have a database that keeps track of tasks my staff does through the day, I have a simple query that counts the number of times each task was performed. I have been running the database for a few months now and I would like to modified the query to perform the query by month and not just the...

Bob, sorry about not getting back to you sooner. I really appreciate all the work you have done on my database. It has taken me some time to understand all the things you added and changed. I am not a programmer so your fix for my actor problem was beyond me, but thanks for the fix. It took a...

Thanks again Bob

Sorry about the missing file, I thought I had attached correctly. I have compacted the db as you instructed and have compressed the file using Winzip as you requested. I will once again try to attached the file using the attached icon above the message window I am typing into.

Thanks Bob, I have attatched a .rar file of the db. When I use winzip the file was twice as big as the .rar file. I hope this is still acceptable. I haven't change the database to bring in inline with the info you supplied, so don't be to harsh on me I am new to this. Once again thanks a bunch.

Bob, thanks a lot for the information and the sample database. I now see where you are trying to tell me. The big problem I now have in fixing the database is how to redo the cast names into a table without typing hundreds, if not ,a thousand names. I have collected. over the years, over a...

Thanks for the reply Bob, I do not understand what you mean by normalizing my table. The field (Cast) is just a text field in which I type in the main members of the cast that appear in the movie. I am not sure how I would use another table for the Cast. I have thousands of movies in my...

The SQL for the query looks like this, SELECT [All Movies List].Title, [All Movies List].Year, [All Movies List].[MPAA Rating], [All Movies List].Gender, [All Movies List].Cast, [All Movies List].Plot FROM [All Movies List] WHERE ((([All Movies List].Cast)=[Forms]![Query Form]![txtCast])); The...

I have build a Access 2003 database for my Movie Collection. I have set up an form query to search the database for things like year, MPAA Rating, Gender. I have used the following criteria in the query [Forms]![Query Form]![txtField Name] and it works just fine When I set up the search...

Thanks for the quick reply Bob, if I understand what you sent 1) I set a table for the keys 2) I set up a table for the all the people 3) I set up a table for the key and the person who can draw it. 4) I then set up the last table, which I assume connects it all together. If I have the above...

I wish to set up a DB to control the issuance of keys. I want to set up an input form where when you enter the key number a one field it will populate the Name field with a list of people who are allowed to have that key. The DB will have around 30 keys each one has it's own list of people who...

Once thanks for getting back to me. I think I need to restate my problem. I all ready have the subform which opens up when I needed it, this is done via a command button which I placed on the Main Form. I have linked through the relationships window the tblProblemNo (auto number) to the same...

Thanks John, in your response after your code you mentioned this Replace ConditionToShowSubform = True with an appropriate test. I don't know what you meant by this line. I did as you instructed and placed the code (without any modification) where you said to, but I got an error 438: "Object...

Thanks John, One question, you noted below the code Replace ConditionToShowSubform = True with an appropriate test. Inot sure what you mean, but I did add the scripted,as above with no modification, to my Main form as you suggested but I got an Error 438 Object doesn't support this property...

I have had some experience working with Access 2003, but only with simple standalone databases, which I designed using the Access wizards. I am now working on a database that uses sub forms. My problem is this: I have a main form called frmProblems with a sub form called frmInvolved, which is...