Search results

It would have to Born Under A Bad Sign. But as a folk guy as well some of Ewan MacColl's lyrics are priceless.

And when he died, all he left us was alone I once loved a maid, a spot welder by trade If it wasn’t for bad luck, I wouldn’t have no luck at all you keep lyin', when you oughta be truthin' Look pretty young but I’m just backdated

Wow. You guys have just described what I'm polishing off right now. tmyers, I have more or less exactly what you want and I’m preparing it for upload here (some days, a week, maybe). However it builds from queries, not tables, so you would build a query for each table and use that instead...

Keep what you have shown in post #8 in the report code module. Or, it may work with Allen Browne's public routine, I don't know for sure. Change your command button code to this: Private Sub cmdOutstanding_Click() On Error GoTo cmdOutstanding_Click_Error DoCmd.OpenReport "rptAllInvoices"...

I'm building a generic query builder where I feed it a base query, and for each query field I populate some combo boxes according to what can be done with the field. So for a numeric type, the combo shows options Equals, Between, Greater than, etc etc. The idea is that for Boolean types...

I've hit a snag whilst following Allen Browne's recommendation to not use Yes/No fields in tables. Instead, he says use Integer data type and Type 106 Check Box. I have a pseudo "boolean" type in a table defined as number, integer and with field type 106. The issue I have is that when I run...

Do you mean you want to change the datasheet column headings? This works for me (A2016) where text2 is a datasheet textbox. No labels on the form just the text boxes. Me.Text2.Properties("DatasheetCaption") = "SomeText"

I don't know if this is a universal fix but try this: For the declaration of the interface function or sub, where it says (eg) Private Declare Function FunctionName () as long or whatever, change it to Private Declare PtrSafe Function FunctionName () as long To code the job properly I think...

Ranman256, I think you've got me on the road to recovery. Actually I was setting stuff in the Modal form, as long as the acDialog form was opened first. So maybe it only had the right 'Modal' priority then. But once it was already open and hidden, re-opening the acDialog form maybe then took...

Here's the issue: A form (#1) opened acDialog, can open another form (#2), Modal Pop-up with WindowMode:=acHidden but not acDialog and then set itself (form #2) Visible = true after stuff is passed in. When form #2 is done it sets itself me.visible=false and form#1 gets the return values. As...

Here's an article about transactions in bound forms: How to use transactions in Microsoft Access VBA - Codekabinett I haven't tried it largely because of the warning against user input within a transaction.

Don't think you've put the code suggested by Shanemac51 in the right place. Post #26, get rid of your new code that starts 'New Sub routine to convert ANSI to character string In the search form properties sheet, select the search field and click the ellipsis (...) On Key Press event. Pick...

This fixed it for me. Perpetual Access 2016. I was on build 14827.20158 but this link reverted to 14701.20206. Lock file no longer remains on closing Access. Link: Lock File Problems with Access 16.0.13801.21086 - Microsoft Community The reply 4th February listing 5 steps to download...

This (the save error, not the class module) might be something that an Access less-than-expert can answer. I too have ancient non-event driven coding experience. You've coded some stuff that is still beyond my skill set but you are experiencing the same relatively simple issues that I did, so...

In my Invoicing application, I set a flag in the main form on the firing of Child Form After Update. Main form then dirties the main record (Me.thDate = Me.thDate). So the main form has no choice but to be saved again. The main form BeforeUpdate tests, and asks the user if they really want to...

This works for me in a datasheet: Public Function cm2twips(cm As Variant) As Integer ' returns the twips for moving and resizing a form from a metric input Const TwipsPerCm = 567 cm2twips = cm * TwipsPerCm End Function Testing: Me.txtDescription.ColumnWidth = cm2twips(6.5)...

I've been using this lookup routine in my application: https://access-programmers.co.uk/forums/showthread.php?t=188663 I've just been having a closer look at MajP FAYT which has some nice additional features. I commented out three lines of code in the class, so that when the user enters a...

The actual button functionality is ok without the caption change, so I may just dump the stuff to recaption it. I cannot figure out how the sub form can respond to one event, but not another. It is clearly 'receptive' to repeated KeyDown events but ignores KeyUp events even though it's clearly...

OK I've been working on it and it's not the Locked status of the field. I just set it explicitly unlocked to check. Same behaviour. 06/07/2021 21:59:10 TabCtlDetail_Change - Screen.ActiveControl.Name = txtPickQty 06/07/2021 21:59:10 TabCtlDetail_Change - Me.ActiveControl.Name = OrderLines...

Well, it's fancy functionality that has turned out to be a lot more complex that I expected. To reduce the number of buttons on my form, two of them are dual-function. A main function, and a related subsidiary function when Control is pressed. The functionality has worked perfectly and...