Search results

The best way to avoid duplicate records in a table is to designate some of the fields as keys.

Thanks Pat, I must have clicked that property without knowing it. I have a bad habit of indiscriminately clicking the mouse when I am frustrated when debugging. Mike

Solved!!! Hi, It's amazing how often some of the knotiest problems can be solved very simply. When this happens to you, you feel so stupid; but at least you're glad that you have finally solved the problem. I fixed this by changing the Record Locks property from "All Records" to "Edited...

Thanks Pat. Apparently both sides, Sales and Shipping, can create new files in the server directory. It appears that whichever group gets there first keeps the other one out. The two are just doing two different kinds of actions. The Sales group (5 people) adds records to the sales order...

Thanks Pat. I'll I will compare the paths of the references. Sounds very logical. On the inability to add records to a table. It turns out that if someone has the sales order form open, no one can add anything directly to the table. However, I'm a little perplexed because we can have four...

Hi, We were using Terminal Services on a Windows 2000 Server machine to run an Access-based accounting system which I am customizing on a daily basis. After each change I made, I would compact and repair the MDB and then create an MDE. I would copy the MDE over to the server and there it...

Thanks ghudson, That one works. Funny that I wasn't familiar with the those inside properties. Mike

Hi, Every once in a while, Access refuses to let me change the size of a form. I looked at the form properties and didn't see anything that looks like it will block changes to form sizes. Does anyone know why this happens and what could be done about it? Thanks, Mike

Thanks Pat. I'll check them out.

I did a search within the forum for this but didn't find a posting that dealt with this issue. I have a few back-end databases that, all though the data will be different among them, the structures should be the same. Because I am constantly customizing the program, I occasionally have to...

You can either refresh the parent form or requery the subform.

Hi, I had problems refreshing a subform after updating its underlying table using a popup form. I did a search within this forum and found nothing to shed light on my problem. I was doing already what was recommended, but it wasn't working. So I thought about it a little more and happended...

Hi, When I had a two-tier setup for our Access app, I was able to find out who was still on with the appropriate code. It was quite useful. However, as soon as we changed to running the app through Terminal Services, all the users had the same machine name; so we need another way to do the...

Hi, I would be interested in leads also but would be happy to pay a finders fee if I got the job based on the value received. I believe that there is a way to police the process. If the potential client were logged into a table in addition to the recipient of the lead, a follow-up would be...

"DCount" is a standard Access function. I suggest that you do a search for it in the Access Help facility. It will explain it better than I can.

The function has two parameters: the incremental amount ( 1 for your need ) and the optional initialize parameter. The second parameter should be left blank in the query.

Here is the Access 97 version.

Here the sample DB in Access 2002 format as a zip. I will add an Access 97 version with my next post.

Try a DCount where the field represented by the checkbox = True. If it < 1, alert the user to the requirement.

Hi, I want to thank all of you for your help in this. I used the code provided by spacepro and it works very well. We have an Access based accounting application and it handles any company selected by the user. We wanted to use different color schemes to ensure that the user knows...