Search results

Another head-scratcher: another form will not let me add a record in the MySql version, but will in the local table version. The table is based upon a query with a constructed field (s: val(eventday) ) set to ascending. This field does not appear in the form. I guess I am more surprised that...

ODBC driver is 32 bit version, and Access is Office 365. I also have another db that runs with the same on the same computer, and column heading sorts work great (I lifted the previous programming idea from it). Anyway, I haven't thought that anything there might be the cause.

I have tried linking both to the table itself and to a query but the same behavior occurs with either. There is a primary key, and it does appear in the form but is hidden. After reading your reply, I tried deleting it from the form but that makes no difference. FYI, the order of members is...

I have a form based on a table containing organization's member data. In order to allow the user to sort on any column, I add a hidden field for each column, then set an onclick event as follows (using the first name field as an example): Private Sub First_Label_Click() If LabelFirstMarker <>...

Thank you--how do I do it in vba code?

Registry modification isn't a solution for non-computer-literate users in a distant city. Just wishing for a solution that makes deployment more seamless. Is there a safe way to write a script to do this that would work for all users?

I am running 365 on Win10. I have a db that I deploy to users running runtime. If I move to a different location on my own computer, vba won't run unless I set a trusted location for it (which I can do), or I click File and Enable Content (VBA Macros). Is there no way to do this...

Thanks to all of you for your input! Now, how do I get my crosstab reports to work?

MajP, for a cert that will only work on the computer on which it was made, just do a search for selfcert.exe.

isladogs, I understand about Trusted Locations. June7 and others need to click allow in the security warning before going to the reports section--otherwise the vba routines won't run (or put it in one of their trusted locations). MajP, that is interesting--I will do it. I do wish it would...

June7, I downloaded the db and opened it. Nothing runs until I click on File and allow All in the security warning. Which brings up another question: how to "allow all" automatically when the program opens? I get it anytime I move locations. It is complaining about the vba.

click the reports button, then choose some symptoms and some drugs and from and to dates to populate the queries. The drugChoice table gets filled in that way.

Hubby has MS, and several years ago I did a db so he could chronicle symptoms and meds. Then I added a form in which he could select symptoms crosstabbed with when he took what medication as information to take to his doctor. It all worked great. Somewhere along the trip to Office 365, it lost...

Fantastic! Thank you all!

Yes, June7, my cdo routine has the code for attaching a file specified in the calling form. Thank you for clarifying the question about attaching an internal report. Is there a way to, via code, to open the form, save it to the folder containing the access program, then attach it? Just seems...

The recipient list varies depending upon how many members' "send email" boxes are checked (what subset of members are chosen). There are times when too many are in the list. My cdo code sends emails individually, and all begin with "Dear " & firstname. Just wish I could automate attaching one...

Hi, theDBguy--thanks for the response. How can I use that to send to a list of email addresses? That is why I am trying to use cdo code.

I have a working cdo function that allows the user to specify a file at a location on his computer to be attached to the outgoing emails. Now I would like to add code to attach a pdf version of an Access report. I am trying to avoid opening the report, saving it as a pdf to some location and...

I figured out a workaround. In a macro, I was able to set up a "EmailDatabaseObject" and name the report and specify the output format. It worked, putting a proper pdf as the attachment.

I need to send a crosstab report as an email attachment. In an attempt to create a pdf to send, I have tried save, save as, and publish. In all cases, all data disappears except the last line, repeated in each line of the report. How to put this report into a pdf? My only resort was to take a...