Search results

It apparently bombs with error 7960 (syntax). The distant user hasn't exhibited the ability to send a screen shot. I am currently in the process of uninstalling Office 2003 32-bit from an old laptop and hope to install 64-bit Access so I can see for myself what is going on. I am blown away by...

How and where do I declare variable tdfCurrent as a tableDef object? I believe tdfTableDef is dimmed as Variant before it is referenced in each function. This program runs properly on all 32-bit installations--only the 64-bit installations fail. Also, users without full Access installed are...

I am running Office 365 32-bit Access. My program's BE is ODBC MySql. The FE won't run when deployed to 64-bit installation (error 7960 syntax). I have attached code supplied to me several years ago by arnelgp that allowed the program to run on 64-bit Access 2013. I would appreciate any help or...

Hi, Arnelgp. 2or 3 years ago you supplied me with vba.accdb that included basBrowse and basSelected so that my FE would run on Access 64-bit computers. That user left but now have 2 new users with 64-bit Access installed. Neither can open the FE--getting error#7960. The only code changes...

arnelgp and speakers_86, you have salvaged this program before, and I thank you. Now, the db in question is unchanged other than the authoring version is Access 2016 (Office 365), and, again, it won't even open on 64 bit installations. arnelgp, you gave me vba.accdb and wondering what may have...

Please never mind. I think one of my users decided to change the values. Please don't spend any more time trying to help me until I am sure I need your help! Frustration!!

Problem: Excel file sent to me containing golf indices, which come in with max 1 decimal digit (example 15.2). I import file into Access 365 db as a new table with vba code: Dim vFilePaths As Variant vFilePaths = fGetFile(e_MultiSelect + e_FileMustExist + e_Explorer, , , , , , _...

Is there an easy way to just open a query in Excel -- the user can then forward it on to whomever.

I tried running on my computer as .accdr and it still worked. I redid the db using Access 2010 and the user tried that and it still crashed although it worked for me. Got a little more info from the user -- she cannot send any email out of the db. Where I originally suspected Excel/runtime...

Hi, DBguy--thanks for looking at this. I have no idea about the recent updates on the computers in question--they are at opposite ends of the state. The program uses a shared MySql db. Both have full access to the data and are able to print a report that includes all of the info in question...

This program has been running perfectly for several years with no changes. Suddenly, an embedded macro crashes the program on two computers running the Runtime2013. The same computers were able to generate the Excel file properly last year. The macro: EMailDatabaseObject Object type...

My brain is tired! I'll get back tomorrow. Thanks to you all.

pbaldy, I don't think I can use other credentials. I will give that a try later. I do know it somewhat depends upon the ISP involved. I hit upon this method a few years ago when Bellsouth wouldn't send via an outside email/credentials. I was trying to use the organization's gmail email...

Tried it--only my own email address is in the From: line (without < > data). However, if I reply, the reply to address is the value of sReplytoEmailAddr. I just don't understand why .from = sFromField & " <" & sReplytoEmailAddr & ">" doesn't put the sReplytoEmailAddr between the < and the >...

No--the values are seen. I haven't tried using the sReplytoEmailAddr instead of sFromField--i'll give it a try and be right back. sFromField is set to the name of the person sending the email sReplytoEmailAddr is set to the email address of the sender sEmailAddress is set to the email address...

I edited it and we crossed in the mail. sEmailAddress is the email address of the recipient.

I load cdo email with data: Set .Configuration = objConf .To = sEmailAddress .from = sFromField & " <" & sReplytoEmailAddr & ">" .sender = sReplytoEmailAddr .ReplyTo = sReplytoEmailAddr...

I was particularly interested in how it hides taskbar, nav, etc., and show and hide Access application window. I can imagine lots of things to do with those. Anyway, thank you!

Yes, I am using overlapping windows (OW). No, not 800*600--didn't realize I had to. (Probably a game ender, as I had already finished my design work when I discovered one installation couldn't use as is). Wish the resize could both downsize and upsize. The design form after resizing was...

isladogs, I was excited to find your code. I put ResizeForm Me in the onload event of my opening form, and expected the result to stay basically the same on this computer. I was then going to test by changing the screen resolution and opening the db again. I have attached the result. What am...