Recent content by tlove161

I have been using this database without problems for over two years. Now when I open the database I get a series of errors (item not found in this collection) and (not a valid password). There is no password associated with the database and I have not changed anything within the database. I...

PHV- Thanks, it works now! What does the "As D" at the end of the expression mean? Troy

I am trying to get a distinct count of LAW_NM from the LAW_AG table. I keep getting a syntax error. Here is the SQL for the count. Where do I add the DISTINCT keyword to get a unique count of LAW_NM? SELECT Count(LAW_AG.LAW_NM) AS CountOfLAW_NM FROM [ALL] INNER JOIN LAW_AG ON [ALL].EVENT_ID...

pampers- I moved "Me![Code].Value = Me![Text27].Value" to the BeforeUpdate event of the form and it still does not work. The error statement states "There is an invalid use of the (.)dot or ! operator or invalid parentheses." I am now really confused. Troy

Roy-Vidar I moved "Me.Code = Me.Text27" into the AfterUpdate event of the form and I am still getting the same error. "The value you entered isn't valid for this field." Any other suggestions? Thanks.

ProgramError- Unfortunately your suggestion did not work. I did not get any errors, but the code from "Tex27" was not assigned to the "Code" field of the underlying table linked to the subform. Any other suggestions? Thank you. Troy

I have a main form named "fromRovingPatrol_01" and a subform on that form named "fsubArrests". There is a textbox on the subform named "Text27" which contains a dlookup function to get a code number. I need to assign the value of "Text27" to the "Code" textbox on the same subform. I need this...

I have a form with a field to collect times. I want to be able to enter the time as "2130" for example and have a colon added when the record is stored in the underlying table such as "21:30". I have had no success in accomplishing this. Any guidance is appreciated. Thanks. Troy

How can I assign a variable to the active record in a table with the double click event of a command button? I am somewhat knowledgeable of vba. I did a search but found nothing. Thanks.

Leslie- Thank you for the help. Your suggestion worked. I am still new to queries and sql. This site is great for learning. Thanks.

Hello- I am trying to find the average of the groups in a query. This is the expression and it does not work: TEST: Sum(([OpDurMin])/Count([ID])) It tells me something about an aggregate function. How can I do this in one query? Thanks.

Thanks to both of you. An update query did it.

I received a table with some nulls in many fields. I need to change all the nulls in the table to zero. Is there a way to accomplish this with a query? I tried to use the find and replace, but it will not search for nulls. Thanks.

Bob Thank you. The sub form now does what I need.

I have a table that is the "one" side of the relationship. This table has a primary key (autonumber). I have a second table "many side" which is linked to the "one side" by the primary key. I have created a form for the "one" table, but how do I enter records into the "many" table via the...