Search results

You say, "...each have multiple skills in fields [ESkill] and [Candidate_Skills] respectively". If your fields have something like 'Engine Repair, Wheel Alignment, Brakes' then you need to normalize your table and data. You should NOT have multiple data in a field. hth, Jack

The form is probably corrupt. You can try importing the form from the previous version and if may work. If not you will need to rebuild the form... Jack

My guess would be something corrupt as your new db is working... Jack

Sorry to take so long to get back to you. Been one of those days... Send the db to jpcowley@aaahawk.com. No guarantee that I will know any more about it than you do, but I will take a look and let you know what I think. Jack

Hmmm. The Attach File and browse thing should do the trick. Is the zip file bigger than 100,000K? If so that may be the problem. Be sure and Compact the db before you zip it up to be sure that it is as small as it can be. Give it one more try and if that doesn't work let me know.... Jack

You are welcome. Glad you have the problem 'sorted'.... Jack

If your Primary key is an autonumber then base the form an a query sorted on the Primary key field. hth, Jack

I am not sure that I can sort out your tables and relationships but I can tell you that you can find a handy and free zip program here. There are a number of free zip programs available but I like this onethe best of those that I have tried. Now you can zip your program and post it! hth, Jack

I think Pat Hartman, in her infinite wisdom, has solved your problem with this answer, "If there are multiple media types associated with each client, you'll need to create a table to store this information. Then use this table as a lookup value in a combo to restrict the media choices in your...

You are right in that it does not make sense to me. Can you give a step by step example of how clients and media are involved during data entry or exactly what it is that you are doing? Jack

1) Use an Append query to append data from one of the tables to the other. 2) This one I am not so sure about as I haven't done any importing from Excel. My idea would be to get the last ID in the table and then after the import use an Update query to update the check box for all records that...

Hmmm. How can a combo box have wrong data? If you are allowing the user to select data from a combo box and they are to select only specific values from that combo box then I would filter the combo box so they cannot make a wrong selection. I guess we are both a bit confused about what the...

If your combo is at the table level then you will see the description and not the PK. Remove the Combo box from the Lookup tab in the table and add your combo box on the form. Now when you look at the table you should see the PK. Be sure the bound column is set correctly as well. I hope I...

Pat to the rescue! Once again I have learned something that I did not know you could do. Thanks Pat! Jack

Use a Totals query and you can filter the records on Order Number or whatever you like. Then you can get a total for the various part numbers that you want. You will probably have to do a bit of fiddling but you will be able to sort it out... hth, Jack

In a word, nope... That, I believe, is up to Windows.... Jack

Happy YN - I always defer to Pat as she has forgotten more than I will ever know about Access. A legend in her own time and deservedly so.... Good luck with your project! Jack

Pat - Boy am I glad to see you! Thank you for jumping in as I did not know what to suggest next and, as always, you got right to the heart of the matter. Thanks! Jack

Hmmmm. If you know how to read an .ini file from Access then I would go with your solution. You could also use a .txt file, but go with what works for you.

Remove all sortiing from the table then create a query based on the table. Sort the query, not the table. hth, Jack