Search results

The non-profit I am creating an Access db for just has a router network, windows 7 on all users, with an Ext.HD attached to one PC. The back-end of the db resides on this path - \\Clinician\h\Database\Alano_be.accdb. I do most of my work on the front-end from home. Is there a way for me to...

Thanks! That got it. But, all of the objects did become unrelated. So I opened each one in design view and saved it, and it was related again. Could I have just closed the database and reopened it? Once again thanks

Hi, If I delete the tables the way you're saying, won't all of the associated objects (forms, query's etc) end up down in "Unrelated Objects"? I'll have to reconnect all of them to the new table links. I guess at this point it's collateral damage?

I have created a db for a nonprofit counseling org. I had created the first half, mostly administrative tasks, called Phase1, and put the BE on a network drive and the FE on multiple users. Now in developing the clinical portion, Phase2, I linked to four of the tables in Phase1 BE file. Now I...

I have. Access help produces a long list of the different ways where that error can be produced. Look at the whole thread, I was able to resolve it. Thanks

Thanks for the pointer. I did a save-as to the back-end and then ran Compact & Repair on the back-end first, and then on the front-end. After that I was left with the one corrupted record and could delete it. Thanks for your help!

I am running an Access 2010 db, split and running on a small office network. I just found that one of my tables has this problem if I open it from the front-end. There are 26 records that have #ERROR in each field of the record. There are 155 records w/o any problems. If I open the back-end and...

Thanks, I will try that this afternoon

I have the back-end of an Access 2010 database running on a network drive. The database thinks that there is still someone logged into it. I have made sure that there is no one actually logged into it. In file explorer there is the second file (record-locking) still present and I can't delete...

I am running an Access 2010 db, split and running on a small office network. I just found that one of my tables has this problem if I open it from the front-end. There are 26 records that have #ERROR in each field of the record. There are 155 records w/o any problems. If I open the back-end and...

Thanks Bob I've gotten it working this way; I declared a module level variable called ThisRecord (most of my code so far is at Form level). then in the code that opens the dialog I have, ThisRecord = [fk_ClientID].Value DoCmd.OpenForm "frmContactNote_dialog", acNormal, "", "", acFormAdd...

I am trying to develope a form (called ContactNote), to enter a note into. Basically it is for a note that a Dr/Therapist needs to enter each time they have contact with a patient/client. I want it to be a pop-up that can be accessed from any screen. The ContactNote table has the field...

Thanks for the help. I think the Object Dependencies are just what I needed to clean things up. Thanks again

Hi, This may be a dumb question but... is there anyway to weed out unused forms, query's. I have searched code for references to these items, and finding none I deleted them. Only to find out that I was still referencing that object in an obscure area that I worked on a couple months ago. Is...

Sorry I took so long to reply. Yes I think that was the problem some of the time, it was actually working and I didn't see it without refreshing. Also, creating query's to supply the rowsource helped a lot.

I have been away from this for ten years so I am a newbie. My problem; I have a lookup field on a form, and I need to change the items on the list. I'm trying to change the rowsourcetype & rowsource from code, to equal the value in another field. How do I get the value from another field to be...

I think that the ClientResponse table is a junction table. I had thought about that issue with copying the text of the question into the response table, but I thought about changes being made down the road in the Question table and it changing the existing questions and answer.This is a medical...

Thanks for the help guys. I have already replaced one of the lookup fields with a value list in the form, and problem solved. I can now combine the values in two fields into a field to create a unique ID for each client. As far as copying text; this part of the database collects all of the...

Hi, I have a table with multiple Lookup fields . I am trying the create an append query to copy data from this source table to another table. From the fields that are lookups in the source, I end up with a number in that field in the target table, instead of text (I need text) I've tried making...

Thanks a lot for the answer. Your input helped and so did the videos on normalization that you gave me a link for. I'm sure I'll be here a lot. alan