Search results

Put the finishing touches on a small db and went to put it on one of the user's laptops. Oops! The screen resolution didn't allow all of the buttons, etc. to be seen without using scroll bars. So, I decided to squeeze each screen's controls up and left (on my development computer) so most any...

I don't feel comfortable making changes in another's registry. They will just have to live with the warning! Thank you for the suggestions. I will hang onto the code for a braver day.

I took out some validation code out of the OnExit event of 4 of the fields, and now all is well. I still don't understand why it was complaining, but I am happy. Thank you for looking at it.

Code behind delete button: Private Sub Command99_Click() On Error GoTo Err_Command99_Click RunCommand acCmdDeleteRecord Exit_Command99_Click: Exit Sub Err_Command99_Click: MsgBox err.Description Resume Exit_Command99_Click End Sub Before I did it this way, I had a macro...

Feeling dumb here. My form is based on a mysql table, not a query. It has the usual auto-incremented ID field and a proper timestamp field. Other than that it has 4 varchar(30) fields, one time/date field and 4 int(11) fields. Adding a record is easy. A "Delete Record" button appears on each...

Google "access 2016 - non working vertical scroll bar - Microsoft Community" When I scroll a continuous form or report, the bottom is stationary so you cannot see the last of the report. Also, when I change from a full screen form to design view, the screen shows part of the form in design...

Also, I often go to the desktop when changing up screens because 365 doesn't play nice--I suspect it has to do with the malfunctioning scroll. I do wish MS would get their act together and fix that.

OKay--I should have tried this earlier. It works on desktop running under 365. I wrote the thing on the desktop in the first place, so I didn't suspect 2010 being the culprit. I have to keep 2010 because I have another db that is run under Runtime by a number of people statewide, and I am...

theDBguy, yes, I can send email via Outlook on the desktop.

hmmm... I just loaded the db onto husband's desktop and it all runs. I would be surprised if just running 2010 would make the difference--think I will install 365 Access and see if it runs. I will get back to you.

theDBguy, frest db with sample email routine doesn't work either. I did generate a new, simple report to attach. Also, another button uses another email macro to send a table in xlsx format, and it works on laptop but not on desktop computer. isladogs, the cdo routine in the same db works...

Don't know--I'll get back to you in a minute.

Yes--Outlook, and the laptop has emClient installed.

I have a laptop and a desktop on my home network. Both are Win10 pro. The desktop is running Access 2010 and the laptop runs Office 365. My db runs flawlessly on the laptop but an email routine won't run on the desktop. The macro code: EmailDatabaseObject Object Type: Report Object...

I mainly set it up the way I did to simplify entry and a calendar printout. As to why move the BE to MySql--just because I could! I can use it on my two computers--if I go out of town I still have access to the current data. I also plan to give the db to other officers of the group. This db...

You are correct, of course. However, my needs aren't that complicated. This is just a list of golf events, the longest of which will be 3-day event. This little program is for my own use (and perhaps another next year), and as with every db I write, I learn something. I am in awe of those of...

The reason for having it other than Date/Time is so if an event is a two day event for example, the user can enter 28/29, By sorting on val(EventDay) it will still put it in the proper order. I can't just sort on Event Day because day 2 of the month would end up after day 10.

I figured out a workaround--at the time of entering/changing the EventDay field I load a newly added table field with val(EentDay). After that I can use it in a sort. Thanks to all of you for your help!

I had set that at one time. Perhaps right-clicking and sorting a field turned it on if it were off? Dunno, but glad it is working now. Can you offer any help as to how to sort a form on val(field) and still be able to add records? This shouldn't be so hard!

Just to follow up, the column sorts are now working. I changed nothing--what I did was right-click on a field in the open form and chose sort A-Z. After that, all of my column sorts worked, the form opened in the proper order, etc. I have no idea why doing this fixed all that ailed it! If...