Search results

Yes, I just saw that and clicked the Thank you... I will definitely take a look! Thanks so much!

DB Guy! You rock! THIS IS PERFECT! Exactly what I want/need and no code necessary to do it! Fantastic! I never would have thought of trying to open the template file from that long location where access places them! So now, I simply create a shortcut to the (.ACCDT) on my tool bar... when I...

Doc_Man: I have been working for the Navy for over 9 years; can't talk about clearance, or where I work within the Navy (not because it's that big a deal, it isn't, but just because it's stuff we're told not to divulge, probably shouldn’t even say Navy, but I think that’s OK). NMCI switched to...

Doc Man... The point is this: Every time I open a new MS Access accdb... I have to open MS Access (which on my Govt computer, takes time) and create the accdb file... then run through these steps: goto File>>Options>>Current database>> change the settings I prefer>>click OK>>click OK again...

Isladogs, I disagree with any assessment that there was ever a shift in requirements. I simply acquiesced to the template option and was trying to be nice about it, given that no one was posting answers to what I was actually looking for, (but I think Pat may have been close). That said, I...

hahaha...Micron, I never wanted a "reminder" to do a manual save. I wanted a way to save the file I created (with all the settings I have to change each time) as another Db file, when I opened it. But yes, creating a template did the trick.. Also, I figured out how to change the default...

DBGuy, I could do that... I wasn't thinking along those lines, so thanks for the suggestion! Meh... I just tried it and in order to create a template I have to post a bogus object in there (i.e. MS Access won't save a file as a template, with only the changed settings there must be an object...

Thanks arnelgp that's closer to what I am looking for. Isladogs (and everyone), I don't really want a "back-up". What I am trying to get around is this: Every time I create a new accdb file (sometimes several times a day), there's a myriad of set-up options I always change, in order to make...

Yes, I'm asking how one would go about making the above happen, pragmatically.

Nope, it's not in a zip file. It's not a split database. It's simply a regular ole MS Access.accdb file, on my hard drive. All I want is code that allows me to save the accdb file that i'm opening. No, this isn't because I might forget to save the file... I want to continually use a copy...

Looking for code that does this: When I open a specific accdb file, I am automatically prompted to save this file as... Basically some autoexec code in the file itself that prompts me to save that file each time it's opened. Thanks so much! Gary

Honestly, The function that Jimk provided looks great. My accdb file (attached above) works really well for me. I simply copy the SQL open the db file... paste the SQL in and hit the button... Access throws the new SQL onto my clipboard and I paste it over the prior code... It's extremely...

Putting all else aside...and what's making this value post double-double-quotes... My main question is: Is there a way to search for a double-quote, within a string variable?

Yes, I have been fiddling around with the code, trying to make it work... so that part is my fault...However and even so... it still adds extra double quotes. ""*000*""

Sorry between 2 and 3 I am simply posting the Variable to txt file: Private Sub btnFullSQL_Click() Dim strDesktop As String strDesktop = Environ("USERPROFILE") & "\Desktop" Open strDesktop & "\SQL_STRING.txt" For Output As #1 'Append As #1 ' Write #1, gstr_WhereSQL...

DB Guy... Here's my code (it's not exactly as simple as I posted prior, as I was just trying to get the point across). It uses a Double-Click event from a List Box to grab the Table and Field for the Where clause... Private Sub lbxBodySQL_DblClick(Cancel As Integer) Dim strCriteriaA As String...

I've attached what I am doing... I already have a where clause started off (see first screenshot) in the Variable "Where [J04A].[ITEMNUM] in the InputBox I post: Like "*000*" then click ok... A message box posts the value of the strSQL and it states that my where clause looks fine (see...

Thank you, I appreciate the suggestion, but I really want to know how to deal with this (above) issue. There's a lot more to what I am doing than just what I have stated. I really don't want to entirely revamp my project, because I can't remove a quote. It seems to be that there should be a...

I have an SQL (string) variable named: strSQL. I am trying to use an inputbox (or even a textbox) to manually alter the SQL code and change the QueryDef. So (let's just say for the "Where Clause") I have something like: strSQL = inputBox("Enter Where Clause") The issue is, the InputBox...

OK I feel really stupid... Now TheDBguy gave me what I needed, but I didn't realize it. I came across a post that uses: DoCmd.RunCommand acCmdImportAttachText Then realized there's a: DoCmd.RunCommand acCmdImportAttachExcel That's all I needed. Sorry to bother everyone! ugh!