Search results

I'm using the following to set the font name for split form my datasheets: Public Function DataSheetProperties(frm As Form) On Error GoTo DataSheetProperties_Error: frm.DatasheetFontName = "Calibri" frm.DatasheetFontHeight = 11 frm.DatasheetFontWeight = 400 On Error GoTo 0...

Ah, I see. It's working out fine.

I haven't found one, yet. I'm not looking for a date picker. Just a Month view calendar to reference on my main form.

I changed it and saved it 10 times. Actually it only reverted to the other font when I selected 'Calibri' 12 point. When I choose any other font size it's fine. Anyway, I imported the database into a new one and the problem seems to have cleared up.

Every time I change 2 combo boxes FontName to 'Calibri' in design view, it changes it back to 'Franklin Gothic Book.' This isn't occurring on any other form. Any ideas??? James

Hi. I'm trying to find a calendar I can place on my form for viewing only. With the ability to move between months. I found one some time ago but have lost the link. James

I've been looking into Delete query. But can't seem to get it to work. Dim strCurRec As String strCurRec = "DELETE FROM tblReminders WHERE Me!ReminderID" When I click the delete button nothing happens. I never understood the syntax for this stuff.

Thanks for refreshing my memory on error handling. Works fine. James

When clicking no on the delete record dialog I get that RunCommand has been canceled. Public Function GlobalDelete() DoCmd.RunCommand acCmdDeleteRecord End Function How do I eliminate this??? James

Thanks much for the information. James

Some, I've seen are pretty expensive. Well, let me ask one more question. I'm using Access 2010. Would it be worth my while to upgrade to Access 2016? Is there any indication when the next version of Access is coming out?

Ok. So, if I wanted to switch to MySQL, will I find all the tools I need in order to create forms, reports...?

I've been using Access for a very long time. But, now, when I read about database management I am a bit confused now. Maybe things are different now then they were before. Just looking for the basics. First, (I'm using MySql as an excample) MySql isn't a Datrabae Management System, right?? It's...

Just an addition. I took out the line setting the QuickStyle. Lo and behold one form's buttons retained the QuckeStyle. I had to go in and change bunch of stuff to get the buttons back to normal. Not really surprised.

Yes, Use Theme is set to yes on all buttons. Things like this are keeping from upgrading to 2016. I just won't use the QuickStyle.

I've heard of that also, where themes aren't applied to existing forms. But, why is the theme being applied to some but not all?? One would think no form's buttons would apply the theme. If I copy and paste a button from a form where the cmd is using the tbeme, the button uses the theme. these...

Public Function BtnProperties(frm As Form) For Each ctl In frm.Controls If ctl.ControlType = acCommandButton Then ctl.QuickStyle = 37 End If I'm calling tis code in the onload of all my forms. Problem is, mnost of the form's comand buttons are honoring the QuickStyle. But, on one...

Now I'm confused. First, lets get this less than greater than symbol right. If I want to check to see if ReminderDate is earlier than today the less than greater than symbol should by pointing to ReminderDate????? ie: ReminderDate <Date() ie: 2<5 or 5>2. No matter which way the symbol is...

THis code: If Me!ReminderDate > Date Then DoCmd.SelectObject acForm, "frmWeekView" MsgBox "Past Due Reminders" End If Works fine on 2 of my other forms, in the On Load, that I base tblReminders on. The difference is the forms it works on are populated with the...

Again, this form DOES NOT display any text fields form the table it is based on.