Search results

Thanks lagbolt. No succes though, unfortunately. I get a syntax error on the suggested line with 'username' highlighted. I've tried the following variations: "R:\~Study_Plans\" & Format$(Nz(Environ("username")) & strApprovedPlan) "R:\~Study_Plans\" & Format$(Nz(Environ("username"))" &...

Could you elaborate a bit please? I don't see where this should go or what the "SomeResult" or the "& SomeFunction(SomeParam) &" could be. My apologies for being so ignorant but I probably need a few more handles before I grab the message.

That's right, the file is called MyUsernameStudyPlan.doc with mysusername being the name of the person logged in to the PC. That part works fine. That file is in a folder 'New_Study_Plans' which itself is in the folder '~Study_Plans' on the R-drive of the server. New study plans get dumped into...

I'm trying to get this to work but no luck so far. This is the code I have: Dim strFileName As String Dim strBackupFileName As String Dim strApprovedPlan As String 'strFileName is Name of the Study Plan Template file , add the .doc extension strFileName = "StudyPlan.doc" strBackupFileName...

Problem is solved! And that could have done much quicker if only I had looked a bit more careful at this reply! The solution was very simple following the suggestion pointed out by Bat17. This is the code that opens the correct file: LWordDoc = strBackupFileName Thanks for helping. I've...

Unfortunately that's doesn't make a difference.

That's what I do now and that gives problems. Too many sloppy users that "Save" and forget to "Save as". The copy routinr works great but then they'll have to browse to the New Study Plan. Not that much trouble but if I can get that automated it'd be better. This is the path that's returned...

Hi all, I'm stuck with some VBA code and am hoping you can give me some suggestions what the problem might be and (more importantly) how to solve it. I have a template file on the server (StudyPlan.doc) that people need to fill in before they can start a new study. There's a button on the...

Thank you Bob! This is exactly what I needed. Great tip.

I have a form with a field ProjectNumber_StudyNumber. This field gets it data from a query in which data are combined from 2 fields: "ProjectNumber" and "StudyNumber". Format of the combined field is 1.10/005, 1.10 os the projectNumber, 005 is the StudyNumber. This all works good but when you...

Thanks Adeptus. You were very close. with Forms!frmEmailMinimal!InventoryID an error message popped up in a messagebox: Cannot find Forms!frmEmailMinimal!InventoryID Replacing the ! with a. (giving Forms.frmEmailMinimal.InventoryID) did the trick! All now works as it should. Thanks for...

Upon closing my frmInventory the amount stock of stock is checked against a minimal stock value. If the stock amount is below a set minimal value a subsequent form is opened telling you that stock is low and an email message is generated to notify a manager. I have a checkbox on that form which...

In my label I had the & somewhere in the middle of the line, not in the middle of a word. I can say in the label what I want to say with "normal" characters so it's not much of issue anymore. I was just unaware of the side effects of using &s in a label. Thanks for your input.

I have a label on a form with text including the word "generated". The funny thing is when I switch from Design View to Form View generated becomes genneerraat :eek: :confused: It's easy enough to use a different word but there's obviously a problem somewhere and I'm worried that Access might...

YES, Wonderful! Thank you for your quick reply.

Hi All, I'd like to see a messagebox when I open a form (based on a query) that contains 0 (zero) records. I have a txtbox on the form that counts the numbers of records so I thought it'd be easiest to use that number and have the following VBA in the "on load" event: Private Sub Form_Load()...

I include a textfield named "setfocus" on forms and set focus to that upon opening forms such as described by you.

Excellent!! Thanks Stopher

Hi All, I'd lile to show/hide selected subforms based on the the text in a txtfield. The text in the selection field (txtSelect) I'd like to use for that may be either one of the following: book-01, book-02, book-03 etc OR, folder-01, folder-02, folder-03 etc OR, record-01, record-02 record-03...

I've followed your example and with data in the tables the queries go. Howver, when I enter new test data using a form it's a dissaster. The tables don't hold the data or I cannot save the data because corresponding data is missing from the other tables. I've set al relations to enforce...