Recent content by DBinPhilly

I have a user who more than occasionally gets the following message: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values...

When in doubt, reboot. I'm pretty sure that I've got network connectivity problems and the link to one of my tables timed out during a query that was accessing the table. Somehow it put a permanent lock on the table. The table was on a NAS device which I turned off and rebooted. That did the...

We are having some sort of network problem. A table in its own separate database file is stating that: (paraphrasing) "This file is in use. Close the file and try again." but the file is not in use. There is no locking file open, and furthermore, multiple users have used the file...

but the systems that are failing are wired.

We have wireless capability for users who bring their laptops. The workstations on the LAN are wired. But the WIFI is always available. Have a couple WIFI printers, come to that.

We have a network with about 12 users. We have no server, but are using a NAS as our file source. We have the data in a back end database on the NAS, and each user has a version of the programming on a front end copy on his own workstation. Several of the users are getting the above...

sorry - I remembered something I wanted to do slightly differently. again, look at the VBA code behind the report buttons to see how to execute queries inside of visual basic.

No subforms are necessary in this case. There is one table that is the crux of the program. The other tables are merely used for pull-down fields and are static. It would be easier to have a form for each of the pull-down fields to add additional static data if there is a possibility that...

I looked at your newer version. If you wish to only have total raw numbers, I guess this might kinda work. But if you want totals by job, you will have to set up a different database for every job. If that's what you want, why not continue to do it in Excel? Instead, look at the database I...

When distributing a program using 2010 runtime, I find that the spell check doesn't work. Is there a spell-check .dll or is there anyway I can get a spell checker? I have several memo fields with long report-type data entry which is being keyed by mutants. Spell checking is essential to get...

I've taken your original design and redesigned it in something a little more logical from a database point of view. Check it out and see if it helps you in learning how to set up tables with relationships. Your original table layouts just wouldn't work in the real world.

Is the table a linked table? Is the current link actively working? If the program cannot "see" the linked table the fields will not display in the query wizard.

It works exactly as described. My heartfelt thanks goes out to you.

I've started distributing a package to multiple customers. If they don't have MS Access 2010 I am using Access runtime - something I have never worked with before. One user reports that he cannot cut and paste in runtime. I've tried it myself and he is right. Is this a caste in bronze...

10-15 years ago I integrated an Explorer type form into an Access 95 database. But I copied the code into an Access 2010 database and that program just didn't like it. Anyone have an easy way to search for a file inside Access? I'm trying to link photos to certain documents. I have the...