Search results

In another thread, I posted a question with some code. A user was kindly able to assist me resolve that particular code, but the code solution I presented is not nearly the ideal solution for me. Yes, it works, but I can’t help but think there is a more appropriate way to achieve the goal. So...

just add this to the end of your file name creation line:& ".pdf" Should result in this:'Build the new file name from form field values. strFilename = DateString & "_" & Me.Employee.Value & "_" & Me.AdminDocDescription.Value & ".pdf" Also note the updated remarked line to more accurately...

NO! Support is not offered to crack passwords.

are the output files always of the same type?

Yes, I know. That was an accidental typo from when I originally created the post here. It (the extra qoute) does NOT exist in the actual code. I only added the "=True" because if I only use this: AccessObj.Application.OpenCurrentDatabase(AccessPath, True)I get the following result:Compile error...

Also, come to think of it, I'm not sure you can even asign data with a date data type to a string type. If it is mandatory to apply some part(s) of the date to the file name, you would probably HAVE to strip parts of the date outDim DateString as string DateString = Year(ProposedDate) & "_" &...

You have to make sure of the actual names of the controls in your form. To be clear, the actual name may not be what the label in the form says.

Me.AdminDocDate.Value A control named "AdminDocDate" with a .value attribute would have to exist on the current form (me.) in order for you to pull the .value from it. In general, just using any full date as part of a file name is probably a bad idea (assuming "AdminDocDate" even exists on the...

what ever you do to construct your file name, needs to be completed before this line:'build the destination strDestination = "C:\Users\swsims\Desktop\E-Pers Test\Admin Docs\" & strFilename

It looks like this code:'parse out the filename from the path strFilename = Right(strSelectedFile, Len(strSelectedFile) - InStrRev(strSelectedFile, "\")) Strips off the actual file name from the right side of the full original path of the Selected file. After: 1. creating the above variables...

Can't you just define some variables and then capture the value from the form? Dim EmployeeV as string Dim DocDescriptionV as string Dim DocDateV as date EmployeeV = me.Employee DocDescriptionV = me.DocDescription DocDateV = me.DocDate I'm probably missing something though...

is that SPAM above this post^? NOt sure about that. PLEASE ALL, I REALLY need some help here! Maybe if I elaborate. I am new to a team responsible to process migration of earlier Office format files to files formatted for Office 2010. There is a third party tool they bought to perform bulk...

not taking ownership of this, so anyone else feel free to hop in, but... What exactly are the runtime errors you're receiving after step one above? Are you sure you're including all the necessary object libraries (for the ActiveX controls) in your ACCDR?

a little confused here. Do you mean you want to house the actual variable (names) in a table, or the values you would want to apply to variables whose names already exist in your code?

Hi All, Hope every one is great! I'm wondering if there is any code a person could use to programatically detect the encoded status of an earlier version of an Access database? I've done some looking and some searching and not successful in finding anything specific. Any suggestions would be...

So, I think I figured out something that seems to work, but I'm not sure if the gurus here would think it "proper". In form 2's OnLoad I do all the calculations and then put a condition tester. If there is any work to do, Form 2's OnLoad ends and Form 2 remains open. If there is no work to do...

Do you happen to have an example of how exactly to cancel the open event?

well, thgat hasn't gotten me anywhere. As I suspected, you can't close a form until it has been opened. The CancelEvent didn't work either. I appreciate your efforts to coach me toward self help, but I'm not figuring this out. A little more specific steerage or a specific function might help...

Hmm, well, I do refer to the docs, but in this case, it honestly did not occur to me to use a subsequent event. I'll try it, but I suipect a simple DoCmd.CloseForm will fail since the form is not yet technically open.

Well, of couse, I did consider that too. However, then I end up with a crap load of variables I have to pass from form 1 to form 2 or run the calculations a second time in form 2. If just seems easier to cancel the form open. I just can't seem to figure out the code to cancel the form 2 open...