Search results

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

I wanna cry Okay, I took the master/child link off of the CompanyName and used the Client ID only. When I go to add a new Job, the Client ID goes to 0 and does not add anything to the table. The link is still established for the Client ID.

Master Child Yes, I have linked Client ID to Client ID and CompanyName to CompanyName (same in both).

It shows on the form, but not on the table. The main form has an autonumber for Client ID and then there is the Company Name. On the next subform, I would like these two items to auto populate into the form, and they do, but when I go to the table, they are not there? Help.

Thank you Thank you for all the help. It turned out, the form did not like the fact that I had two parent/child relationships.

I have a sub form of a sub form that won't let me add. The Main form links to the subform via a client ID, the subform links to the subsub form via jobid and the subsubform needs to have both the clientid and jobid update as a new job is added. But I can't add anything. My master/child is set...