Search results

If you don’t want AI to physically interact with your local DB file, many of them now have their own built-in Python ODBC driver. Scary!! or Amazing!! At the start, I found it helpful to get AI to write a MOD that documents tbls, fields, and relationships etc to a .txt or .md file. Then...

😄😄😄

Thanks again Colin for the info. I am not losing my marbles then or overdosing on Merlot

Thanks for the heads up Colin. Got my fingers and toes crossed

I went around the houses, used Google Antigravity to make a custom chrome extension to Screenshot webpages, Rectangular select or FullScreen or Full page or Savepage. Also, Python local server listing for the instruction to then store the selected Screenshot as a jpg / Savedpage as an .mhtml...

Ok so it's just not me. Another 1 for the list....

Edge Browser Control and MHTML files I’m testing the Access Edge Browser Control with archived .mhtml (Web Page, Single File) files. The files load via a local path, but the rendering looks incorrect (unformatted / partial content). The same files display correctly when opened directly in...

Hi namliam & MarkK I am now getting an Enter Parameter window for txtBookedDate when it’s a Append query. So Append queries only append from Table/Field to Table/Field. Can’t believe over the years I haven’t had a similar issue, anyway I was originally only using the select query to check all...

Hi MarkK Hmm Ok i will check in the Append SQL in the morning....Any ideas on the CDate part to simply converting the ddmmmyy text value into a dd/mm/yyyy date value?

Hi All, Its been a while I Keep getting an #Error result on the CDate function 1st step works fine txtBookedDate: Trim(Mid([BookingDumpScreen],InStr([BookingDumpScreen],"P.")+4,8)) Answer as expected 07JAN15 2nd step converted the text to date Tried BookedDate: CDate([txtBookedDate])...

IE11 & Access2013(Desktop) Hello....I was wishing to automate a process at my work:- 1. I Highlight a text value on a website then ctrl&c 2. Alt&Tab to Access 3. Press F3 on the keyboard to open a search form 4. Ctrl&V paste the value I presume I will have to make up a toolbar in IE to add...

Anybody :(

Help anybody?

Is it possible to specify a add-in IE toolbar (Lastpass) to load up with a form browser control. I understand its possible to pull through the main cmds GoBack, GoForward, Stop, and Refresh etc but I need the lastpass toolbar to load. Thanks Win7 / Access2000 / IE8

I was trying to use the example Dave gave me with the Then at the end. So a “Then” is used when is a “IF” not a “IIF” ? Also I don’t understand “leading spaces” is that not to do with Trim function I must admit I just can’t get my head round the structure of this. I am officially lost Stewart

Never put together a multiple IIF before. This was fun typing this out on my Mobile !!!. Back in the office on Monday Will this code work ? Thanks Stewart Private Sub Form_Current() IIf (DCount("*", "frm_ClientsMedicalDetails", "[pid]=Forms![frm_clientmasters]![pid]")>0 ) Then stDocName =...

Ok DCount it is then Looked at the Access help pages their was an example “There are more than three entries in the Order Details table for which the OrderID field of the table matches the OrderID field on the Orders form. “ DCount("*", "Order Details", "[OrderID]=Forms![Orders]![OrderID]")>3...

Hi Allan thanks for taking the time to reply Due to screen size restrictions the original frm had a TabCtl & Subforms, But my colleagues just didn’t look through the tabs I thought if i changed the other forms to popups this would force them at lest to look at them and further down the line...

Hello I have small .mdb containing these tables tbl_ClientsMaster (Primary Key) (PID) All linked to above by PID tbl_ClientsMedicalDetails (PMDID) tbl_ClientsExecutiveCards (PECID) tbl_ClientsPreferences (PCPID) The tables all have corresponding forms When the frm_ ClientsMaster loads I...

Bump! Anybody