Search results

Replace this: Set MyDatabase = CurrentDb On Error Resume Next With MyDatabase .QueryDefs.Delete ("tmpOutQry") Set MyQueryDef = .CreateQueryDef("tmpOutQry", strSQL) .Close End With 'Step 3: Open the query Set MyRecordset = MyQueryDef.OpenRecordset with this On Error goto myErrorTrap Set...

Hi Jacek, AFAIK Access will not reclaim space, so both 1 and 2 are going to cause bloat if you are importing millions of records. 3 is a better option. CJ's suggestion is a good one, which I have used to good effect, and is pretty straightforward and easy to implement. But there is another...

... 30% slimmer to grab 40-ish chunks ... Function goAuntie() Const BigString = "The quick brown fox jumps over the lazy dog. Jumpy zebra vows to quit thinking coldy of sex. Bob, Carol, Ted and Alice race forwards to Jason's pink zombie quins." Dim n As Long, i As Long, arrStrings, strPrune As...

Couldn't resist .... Function goAuntieJack() Const BigString = "The quick brown fox jumps over the lazy dog. Jumpy zebra vows to quit thinking coldy of sex. Bob, Carol, Ted and Alice race forwards to Jason's pink zombie quins." Dim n As Long, arrStrings, Lastn As Long, strPrune As String...

Thanks doc_man, I'll get onto this approach. Your insight greatly appreciated.

Thanks for your answer, but it is the connection to the OData source that is concerning me, not protecting the front end, which, as you've suggested, has some pretty straightforward and well-known 'solutions'. I'm interested in ways to protect the connection to the data, given a cloud OData...

Hi, I have been experimenting with connecting my Access Database to an Odata source. Works a treat. But can it be made secure? And I mean, very secure. Any ideas? Thanks, Jack

Hmm, DBGuy, I think that must be it. I am indeed using a File DSN, and Access does convert that to a DSN-less connection, one of its cool attributes. However, the *old* LTM prompts you to browse for a DSN when you relink (if you select 'Prompt for new location', converts it to a connection...

Hi, I'm just starting to use Access 365 and a newly downloaded SQL Express. The LTM is confusing. My tables are all connected to a Prod server on a different machine, and I'd like to relink them to my test SQL Server. In the old LTM I'd select 'Prompt for new location', and I would browse for...

Thanks. As I continue to work with ever newer versions of Access, I am slowly pulling out my old habitual workarounds that have accumulated since version 1.1 (some of which, as you suggest, may have resulted from misinterpretations anyway) ......

Hi all, There was a time when this query would give an error, because you couldn't use a calculated field in a second calculation in the same query: SELECT Len([EntrantName])*[EntrantID] AS EntrantCode, tblEntrants.EntrantName, IIf([EntrantCode]>50,[EntrantCode],[EntrantName]) AS...

Hi, I'm no expert on this, but I have used Sharepoint instead of a fileshare to store and deploy front ends. It works because of the WebDAV capability of Sharepoint (and Box and other web repositories). You can map to them like any share drive. So your .bat file which does your XCopy - well, not...

So, based on Ranman's reply, you could try, in the OnLoad event: txtMyTextBox.enabled = (nz(Dlookup("userpermissions","tbl_Admin","username = '" & environ("username") & "'"),"") = "ReadWrite") That looks complicated, but it's the same as: dim strPermission as string strPermission =...

Wow! Try this: Dim n As Long, i As Long For n = 1 To 20 If Len(Cells(n, 1)) > 0 Then Debug.Print Cells(n, 1) For i = 2 To 27 If Cells(n, i).MergeArea.Count > 1 Then Debug.Print Cells(n, i) & " for " & Cells(n...

Hi, so sorry I haven't replied - flat out here! I've tried to work out a way to explain the problem. Basically, I'm creating all my reports using a Layout. I'm not explicitly using the Wizard - I just select a query and click Report. That opens the new report in Layout view. When switching to...

Hi, Your replies much appreciated, thanks. JHB, a good idea but it just creates a new layout grid, doesn't extend the existing layout grid to the new section. In fact, it seems that you can't explicitly extend an existing Layout to a new section. However, there seems to be a workaround. If you...

thanks, but not there yet - still can't extend the layout into the ProviderShortName Header section. Agreed that the rest of the formatting is dodgy, but that is more a result of me trying every which way to convince Access that I need the layout over my new section!!

Sorry, that didn't work - try attaching ...

Sure. The orange shows the existing layout. I want to include the new field Provider Short Name into the existing layout in the new section. That is, I want to somehow extend the layout into the new section called ProviderShortName Header. No idea how. Thanks, Jack

Hi, thanks ridders. Nope, what I mean is that the new report creates it's own layout, so that in Design view I can see the Layout grid in the Detail section, and I can drop controls into it. The same Layout extends across the Report Header and Detail footer and Report Footer too. So if I widen a...