Recent content by MajP

Do not believe that is a true statement. You cannot set the specialeffect of a button in vba. "Property or method not found". If so, can you provide an example demo?

I think the issue is with "use theme controls". Prior to that you could choose "Special Effect" for a command button of raised, flat, sunken. Although you can do that with most controls still you cannot do that with command buttons that use theme. I might be wrong but that property does not...

after But your options depend on what version you have of access.

Here is a very good explanation of how the OP does away with comboboxes. However, again the question is would anyone prefer this over a combox. Without seeing it in action it sounds as a less favorable UI. So again does the ease in development outweigh the less preferrable UI. However, I can...

Although the concept sounded interesting at first I lost interest pretty quick because lmb sounds like the guy pitching a Time Share presentation that you are forced to sit through to get the free weekend at the resort with the all you can eat and drink buffet option. Lots of platitudes and...

I do not interpret that the same way 1. You have cboCompany with company ID 2. You have cboOpportunity based on qryActivityOpportunity which has a foreign key to the company 3. You pick a company in cboCompany and want a message if no company in cboOpportunity Private Sub...

That sounds like a horrible idea to me, doing the opposite of what you should do. 99% of the time when you see a blank field in access it has a null value in it not an empty string. You have to jump through hoops to force an empty string into a field. So instead of defaulting to the thing that...

@Gasman This is legal getDaysSoFar (strPeriod) But this would give a syntax error getDaysSoFar (strPeriod, AnotherArgument) Although this would be legal getDaysSoFar (strPeriod),(AnotherArgument) The parentheses rules in VBA seem kind of arbitrary. But the reason why yours work (single...

I would definitely look at the Emulated split form vs the real split form. More flexible and less problematic.

I would put my money that is what is going on. The OP forgot to bind the checkboxes, because that is about the only way you can return a null value. An unbound checkbox on a form or report returns null. In a form if you click it will become true, then false. Only if triple state is selected...

This is probably why the suggestion was made to use Dot notation and not Bang (!). With Dot you should get intellisense so when you type Me.l then it will show all the objects starting with "l". Bang does not provide intellisense. In the format event it will run through every record. If you...

also if you do a lot of this I recommend a function like the CSql. Then you code is ... JR_ID, "& Csql (me.TrnDate) & ", " & csql(me.TrnType) &. It will figure out if it is a string or text or numeric...

A couple things to make it easier. 1.Debug dim strSql as string strSql = .... debug.print StrSql look at the debug and ensure it makes sense. 2. When working with string literals in sql use single quotes. Much easier to read and no doubling up ...Where Rank = 'Junior Firefighter' and Status =...

FYI, This sounds like a "split form". A detail section and a continuous section. If so you may like https://www.access-programmers.co.uk/forums/threads/emulating-the-split-form.294421/

I can think of at least three ways 1 recordset.findfirst 2 set the bookmark 3 use docmd.goto record with a bookmark With Forms!frmMain.RecordsetClone .FindFirst "ID = 123" If Not .NoMatch Then Forms!frmMain.Bookmark = .Bookmark End If End With with a docmd ' Go to a...