Search results

The data are presented in several ways, the one that presents difficulties is the Continuous Form showing ALL records. That's the form most appropriate to view a summary of the record and decide if you want to add it or delete a selected record from the personal list. I now have it working but...

Yes, that's exactly what I'd like to do but I don't find it that simple to do. I am looking for the exact opposite of the AddNew action used to create the record in junction table. The standard Delete button won't cut it.

I can't delete the entire record. Remember there are multiple users, each of which should be able to individually see all records at all time. The selection option for each individual is just to make finding your particular interest more easy. If someone deletes an entire record it would be...

Thank you for you reply, I've continued down that path. I have created a button with the following code behind it: Private Sub cmdAddToMyList_Click() With CurrentDb.OpenRecordset("tblSelect_MY_options") .AddNew !Loginnaam = Me.Loginnaam !RecordID = Me.txtRecordID...

I have a database which holds records of publications in journals, newspapers or other media. A minority of these publications are of interest to everyone in the company. Most are of interest to smaller audiences, i.e. groups of one or four individuals. I would be surprised if the total number...

it's now almost good Cameron. I get a pop-up box asking me for txtrecordID so I guess it's simply a matter of playing with that a bit in either the VBA or the naming on the form. Unfortunately haven't had time for that today but will trying until it's either working or I give up and come back to...

Thank you Cameron. I indeed have a continuous form and I think I understand what your suggesting. I'll give it a try tomorrow morning when I'm back at the office.

I am really struggling with what I expected would not be very difficult. I just don’t get it and need a bit of help/feedback to get me on the right track. We have stacks and stacks of research papers that need to be organised so that everyone in our team of about 10-12 people can search the...

Thank you Paul, replacing + by & does the job. GREAT

I'm combining 4 fields in a query but am running into trouble when 1 of the fields contains no data, which is sometimes correct. The result is that the field displaying the outcome of the combine query is empty, which is not what i wanted to achieve. Here's how I currently combine 3 fields...

Thanks for your reply Uncle Gizmo I think I'm actually doing what your suggesting, but then again, maybe not quite. I'll try to explain a bit more clearly. You say: OK, I hear you but I don't see how, nor am I convinced that you completely understand what I'm trying to achieve. I don't doubt...

I have 2 tabels, Docs and People Each table has about 15 check boxes to further specify the doc/user. -in tblDocs which groups of users this document is intended for and -in tblPeople which document the user should be trained in and a tickbox if training has been completed. e.g. if tblDocs chkA...

Sorry for my late reply Unclejoe. The modifaction you suggested works like a treat. Thank you so much for your help.

I'd really appreciated if someone could put me on the right track with this one. Thanks

Tried your suggestion but unfortunately doesn't help UncleJoe

Hi all, We have documents on the server that employees frequently need to fill in, such as time sheets, expenses, training records etc. People often have a copy of these docs on their own PCs for their convenience (no more looking for the docs on the server). A problem occurs when docs are...

Hi All, users can opening a file (either .doc, exe or .pdf) with additional data to the record they're looking at by clicking on a icon on a form. The icon has code behind it that opens the document (Application.FollowHyperlink NameDocTo Open). That opens the doc OK, no problem, but what is a...

Finally got it to work! Thanks for sticking with me guys. You probably think I'm a bit thick for not getting this right a bit sooner but I'm not an experienced programmer and am only discovering things as I go along. Thanks again. Walter

The final strApprovedPlan path is: strApprovedPlan = "R:\~Study_Plans\" & Format$(Nz(Environ("username")) & strBackupFileName) strBackupFileName is the name of the Study Plan that was copied correctly to the "review Folder" as specified by strPathToFileName So yes, the final string does...

Yes, I don't get the error on the first line anymore. Don't why I did the first time. I used copy/paste so no spelling errors. ANywhy, glad that part goes. However, ...... The code still doesn't execute. Code hangs on this line: FileCopy strPathtoFileName, strApprovedPlan I've again tried...