Search results

Pretty much any cloud-based DB can be used with a web app. Power Apps I think can also connect with most databases, but some require a premium connector.

Remove the single quotes around the UserID and Contact ID , they are numbers not text.

You no longer need a BE Access database. You moved the tables to another database engine. Your tables are now stored in SQL/MySQL . This is now your backend.

That's interesting, in both cases these were legacy databases that were converted to SQL backends some time ago and as a result, using the Version 11 Driver. We use version 17 across the board in any more recent developments, and to be honest, almost 100% of the time use an integer Identity PK...

As per this thread here https://answers.microsoft.com/en-us/msoffice/forum/all/ms-access-displays-deleted-in-every-field-for/593e5f12-3cbd-414e-841c-9df612504d3c?page=3 Originally about Oracle, we have now seen this in two Azure BE client databases in the last 2 days, making me think another...

An Azure / SQL / MySQL cloud-based back end will work fine, but you need to design your front end to not drag every record over the WAN. Use Pass-Through Queries, Views or Stored procedures to do the heavy lifting. Open forms without any records or only a single record, then use controls to...

HI @MK1999 This is an old one and I can't actually remember the fix, but from reading my reply I would say Yes delete the form controls and put them back again in the order you want.

Do you need new Dilithium Crystals?

If you move it to another monitor and drop it near the top it does maximise?

@Cherylodge Do you realise this is a 9-month-old thread, and that the solution you posted was suggested at the beginning of the posts? :unsure:

The first twelve characters of a field will be returned using (in a query) MyFirst12Chars: Left([YourVeryLongFieldNameWithSpaces],12) So use that as the comparison and grouping field.

@Kavithathanikanti - You do realise this is a 17 year old thread?

If you use the following, generally speaking, the output is a lot better quality DoCmd.OutputTo acReport, sRepName, acFormatPDF, sFullPath, , , , acExportQualityPrint

Just to expand, Azure is a cloud-based managed service provided by Microsoft, I'm not aware of any method of connecting to it "directly" without WAN access.

Could it be that Well_ID is a Number? Not a text field?

I use this routine to resue a pass-through to Azure Public Sub sSendToPT_Generic(strQuery As String, bRetRecs As Boolean) Dim db As DAO.Database Dim qDef As QueryDef Set db = CurrentDb() Set qDef = db.QueryDefs("qPT_Generic") qDef.Connect =...

Pass through from Excel: https://answers.microsoft.com/en-us/msoffice/forum/all/send-query-as-pass-through-to-odbc-source-via/304f93ee-12e7-4e0c-839f-af8e87cba4e8 But I thought there was a better way to handle XML data in Access but am struggling to find what I am looking for?

Correct It's effectively simply stored in memory, then deleted once the procedure is run.

The best way is to use a parameterised query. This https://www.access-programmers.co.uk/forums/threads/too-few-parameteres-expected-6.281472/#post-1453812 post demonstrates a simple way to set it up

@templeowls I also provided an answer in the crossposted thread, yet you haven't acknowledged that or @bastanu contributions here? Both of the answers provided gave you what you needed.