Search results

Try adding NULL to the SQL when you want Null: strSql = "INSERT INTO tblTransactions" & _ " ([fAccountID]" & _ ", [fNameID]" & _ ", [CkDate]" & _ ", [Num])" & _ " VALUES" & _ " (" & Nz(Me.cboAccount.Value, "NULL") & _ ", " &...

Presumably via normalised tables: Shows -> Seasons -> Episodes

That's why I used the constant (SPACER) to calculate the tab widths without requiring the left/right arrows in the code I used.

PS. Are you using code to hide the ribbon?

Perhaps it didn't manifest under Win XP? I'm using Win 10

Interesting - I wonder what the difference is.

Did you try making the tab control wider?

I'm happy to live with this 😝

RecordSource for continuous form is something like: SELECT s.ShowID, se.SeasonID From Shows s INNER JOIN Seasons se ON s.ShowID = se.ShowFK ORDER BY s.ShowName se.SeasonNumber Then listbox RowSource would be: SELECT ID, [Number], Episode, Title, AirDate FROM episodes...

I see it in A2K7 Code behind form: Option Explicit Option Compare Database Private Sub Form_Load() Call TabsFullWidth End Sub Private Function TabsFullWidth() As Boolean Const SPACER As Long = 50 With Me.TabCtl0 .TabFixedWidth = (.Width - SPACER) \ .Pages.Count End With...

As many as there are seasons in a show. But really only one, since a continuous form just repeats a single row

So you can use the new API from Access. You could also 'mimic' the look of the control in your app by using a listbox for each season in a continuous form

Looks like you missed the point, Pat. I think the OP wants the underline and the ability to use the accelerator key. They just don't want the side effect that the caption then becomes right-aligned.

NOTE: The solution I provided is sub-optimal. Unless it is essential to allow empty string values in fields RTGSUTR1 and RTGSMailToHO1 (very rare) then it would be better to convert all empty strings to NULL and prevent empty values. Then your queries on those fields can use indexes (if they...

BTW, Probably better to use: [Field] IS NOT NULL rather than NOT ([Field] IS NULL) If anything, it's less confusing visually

You can also try: SELECT FarmerT.RegNo, RTGST.RTGSUTR1, RTGST.RTGSMailToHO1 FROM FarmerT INNER JOIN RTGST ON FarmerT.FarmerID = RTGST.FarmerID WHERE Nz(RTGST.RTGSUTR1, '') = '' AND Nz(RTGST.RTGSMailToHO1, '') <> '';

I'd consider the retention of formatting a good thing (though obviously not how it is displayed!) Interesting that the query is truncated in the middle of the ORDER BY clause in your paste into Notepad. That does seem like a bug.

Fancy giving it a go?

Did you try copying the criteria for OrderID and seeing whether it retains indentation/new lines on pasting in a text editor? (Just for fun!)

Still unclear why you would use a nonsense query to demonstrate. That aside, I wonder if you were to have copied the contents of the Update To: field in the query designer and then pasted it, whether it would have maintained the formatting and indentation (ie the line breaks are there, but...