Search results

Thanks it now works, but on to more DCount stuff Thanks ghudson, i was able to figure it out using your help and the somewhat helpful help file. the final versions was = Nz(DCount("[PrePControlNumber]", "tblContract", "PrePControlNumber= '" & Me.PrePControlNumber & "'"), 0) Am on to more...

Getting There Thanks a bunch, using DCount instead of DMax gave an error so I have placed the following in its place to work up to my desired result. =DCount("[PreControlNumber]","tblContract") This gives the total number of times the field "PreControlNumber" is found in the table however...

I just can't get a grip on this. Any help is appreciated. All I am trying to do is use DMax to search a table to return the number of times a certain value is stored in a particular field and increment a number in an unbound text field on a form by one if it exists and or just return 1 if it...

From Access Help: The next example from the Shippers table uses the form control ShipperID to provide criteria for the DLookup function. Note that the reference to the control isn't included in the quotation marks that denote the strings. This ensures that each time the DLookup function is...

Thanks, i believe it is in the DLookup function. I will muddle through that.

Any help is appreciated, i'll try to muddle through this as succinctly as i can. Still only on my first pot of coffee. :D using a query to populate the contents of a combo box that references a linked table i am able to obtain all fields within a record from the linked table. contained within...

Sounds like the control mirroring myfield is an unbound text field. A simple solution is to set the command buttons "On Click" event procedure to update the unbound text field with "Now()" then immediately update "myfield" with the contents of the unbound text field. "On Click" event...

Use the "On Close" event of the add new employees form to requery the combo box. So when you close that form it will cause the combo box to requery the query that your combo box is based on. Forms.[Name of your form].[name of your control].Requery This should work.

Thanks Pat, sorry for the delay in responding but am just this morning able to check the forum and reply. I will be chewing on your answer for awhile. :)

Is the Microsoft Access Template Database, "Contact Management" normalized? :confused: What I mean to say by that is that I can enter in the same contact multiple times? :confused: Also, how would this be corrected if it is a normalization error? I have searched the forum, however did...