Search results

Padding with format and spacing with a fixed width font. Example query SELECT tblGLPost.Account, Right(space(15) & tblGLPost.Debit, 15) As RightJust, Format([tblGLPost].[PostDate], "dd/mm/yyyy") AS TheDate FROM tblGLPost WHERE Format([tblGLPost].[PostDate], "dd/mm/yyyy) < #4...

I use VBScript.RegExp on Access version 2602 to tokenize infix math expressions used by a BOM calculator without issue. According to copilot, the native RegExp only handles case sensitive matches with no execute. Is VBScript.RegEx going away or can I can continue using it for tokenizing...

Unless the NAS is Windows based, the BE will be unstable on a SAMBA emulator. Move it to a Windows Share.

I use a function from ExcelHero.com In your form after copying from whatever. me.YourTextBox = pai1_ClipBoard() '---------------------- ' Replacing API code in modzClipBoard 10-10-22 ' Copy ClipboardText if not empty to clipboard and return vbnullstring ' Return clipboard text if...

It's under review

I posted a sample Database. https://www.access-programmers.co.uk/forums/threads/menu-system.335354/

Attached is a sample database of my Access menu system. The main form is SYS which uses the menu system to show Forms and Reports with the option to change access level and module. Only 3 of the forms on the menu are included Accounts Receivable, Job: Master and Parts: Detail. The beMenu table...

I will workup a sample database with the menu.

The video looks interesting, I would like to have attended but spent 12 hours moving on the 2nd. The discussion would likely be informative. I have implemented similar concepts like my menu system. Each form passes a Combo box or List box control and form ID to a function that fills the record...

I watch the presentation video. Is there a 2nd one for the discussion or just refence the Reddit post?

I use a menu and user group system. All Forms, Reports and Actions as listed in a menu with a PC table linking Reports and Actions available on forms and another linking Forms, Reports and actions available to groups. Users can be members of multiple groups. All forms are opened using FormOpen...

I have added a WEB version of the Purchase Order Receiving task for a phone. This is a specific task replacing the printed receiving report allowing entering the received quantity instead on noting the quantity on the report. 1st is the desktop version. Next is the WEB version on an Android...

Of course if the client insists on duplicating a desktop app on a cell phone, then CANADA BILL JONES' MOTTO comes into play. "It's morally wrong to allow naive end users to keep their money."

If you insist on using recordsets, the following is cleaner and will let the user know when all the records were not updated. A update query will update all the records or none of them. private Sub Form_Load() On Error Goto ErrorHandler Dim I as long ' Only Select the columns you...

Glad you got it working, but you could replace all this with a single statement. CurrentDB.Execute _ "UPDATE qryHealthSafetyMatrixFireSafetyFireWarden " & _ "SET qryHealthSafetyMatrixFireSafetyFireWarden.[dtmFireWardenMarshallRefresherDate] " & _ """= DateAdd(""yyyy""," & 3 & "," &...

Easy to change the years to what you want and do it in one line. CurrentDB.Execute _ "UPDATE qryHealthSafetyMatrixFireSafetyFireWarden " & _ "SET qryHealthSafetyMatrixFireSafetyFireWarden.[RefresherDate] " & _ """= DateAdd(""YYYY""," & NumberOfYears & "," & [me]![txtStartDate] & ");" PS: Your...

Are you tiring to update qryHealthSafetyMatrixFireSafetyFireWarden? In you loop you are updating a form control from data on the form but never check the current record on the form while looping though the recordset.

This is a nice little utility to generate connection strings. Open it and configure your settings. Click OK Edit the file to get the saved string.

I don't think you want to use transactions during user input because you don't want to keep them active longer then the time to do the update. Temp tables may be a solution, another would be 2 forms using code to link them. Two forms because edits on the 1st form are not automatically saved when...

I have been using Copilot for coding support. The latest was a SQL Server query to close stale connections. While it did produce functional T-SQL, I find it to be a sloppy programmer. The query required editing for simple things like defining variables at the top of the code. Does Claude do a...