Recent content by kholm

I need to compare two tables. That is not the problem the problem is in Table A only the first 6 letters for the same information is listed. So, Table A has AGGREV, which I need to match with Aggrivated Assult in Table B.

How to use it How do I get the city and state to auto populate based on the zip code?

I use a zip code file that lists the zip code and then in my data entry software fills in the city and state. Is there a way to use this file for an Access form?

Here we have three shifts for which I make a productivity report. By taking the hours put in by the person, we can see how much time they spent doing data entry, or other "work". The problem is with third shift. The hours we get from our time clock are military time, therefor switches to a...

Lets see if this works I am unable to attache the database. It keeps saying it is too large. I have stripped this thing down, compacted it and zipped and it is still too large.

Doesn't work I am unable to attach even a shell version of the database. Is there another way.

I could just scream! Private Sub Form_BeforeInsert(Cancel As Integer) Me.[Fish#] = DMax("[Fish#]", "Fish", "Species = '" & Me.Species & "'") + 1 End Sub This is what I have now, and nothing happens, I could just scream! Kristin

Here it goes I have a form which is based on a table. With in this form is VB code (just trying to explain the best I can). I need to have an autonumber produced for each species, but they must start at 1 for each new species. The form goes like this, Species (which is a drop down choice...

Tried I tried placing the bracets in and still no luck.

Error Code Here is the code where I am experiencing the problem: Private Sub Number_Before Enter Me.Fish# = DMax("Fish#", "Fish", "Species = '" & Me.Species & "'") + 1 Thanks

Can't attache file I have a slimed down version of the database, but it is still to large to attach. Is there a way to get you the database to look at? Thanks Kristin

Still in need You have been very helpful, and I would never ask you to do my work for me, but... I have attached the database so you can see what is going on. Go to the form Fish and look at the number and the code I put in for On Enter. What do you think?

I feel so close I can taste it I know I am close, but when I get to that Fish# field, it opens the debugger and highlights me.fish# (the destinationa field). I don't get any numbers in the field. Thanks

Looked for information I looked for much information regarding DMax and found a lot. It looks like what I need to do is set up a query and in the Field enter, Fish Number: Dmax(Exp, Domain, Criteria) +1. Does this look right and what is Exp, Domain (I figure criteria is the species, but is...

The problem is I have 48 different species of bettas that each need to have their own set of numbers. After a fish is bred, that species will not have 100 offspring that need numbering in that particular species. For one species it should start at 1 and go to, say, 54; another species should...