Search results

Hi Nector, Can you give me a good reason why you exported your data to a JSon file, rather than connecting directly to the Table? I think this can be greatly simplified.

Hi, I understand that the OP us creating a JSon File from SQL Server. What I am suggesting is that it is not necessary. Unless I know a good reason why, my suggestion(s) will always be the most appropriate method. This is nothing new to you, but it may be to the OP. Access can link to a Table...

Avoid using DLookups. I am also not sure why you are making this more complicated than it needs to be. You do not need JSON to insert Records into a Cloud MS SQL Server DB. Make sure your DB has a Link to the Table that you are wanting to Insert into, then just use an Action Query that is...

Use the Application.FollowHyperlink method instead.

No worries. I had been reading a lot of the comments. I don't know why I did not see your second comment where you corrected yourself.

Hi, Is your cloud MS Server on Azure or AWS, etc.? Are the DTU's or CORES provisioned? Do you have Auto-tuning turned on? I am on the fence about Auto-tuning. The resource only becomes faster the more it is used. I prefer self-managed indexes. Have you tried to implement the Query as a VIEW on...

Tables Macros cannot call VBA Functions or Procedures.

Thanks! While we had an archaic method for traceability. We at least had a Groups and Class of Items, whether they were purchased, manufactured as a sub-component, or as a finished or final product. If the item was purchased, we did have a cross-reference system for available suppliers. The...

My largest Access Application was an ERP for a Manufacturing and Servicing Business that had 80 Branch Plants that manufactured anything from Household Products to High-end Furniture. It handled A/R, A/P, Bill of Materials, Work Order Production, Sales, Automated Inventory, Monthly, Quarterly...

Hi, To the best of my understanding, MS has NOT added any Dictation ability to Access as it has for Word and Outlook. Has anybody ever implemented a 3rd party Dictation Add-in for MS Access? If so, can you reply with link(s) to source? Much thanks!

On the other hand, it could also mean that data is not properly normalized. This is a bad habit for companies importing flat files, any file for the matter, and not normalizing it, leaving it as it.

I prefer to link to Files with SQL using DAO QueryDefs. Then a second QueyrDef to make table. If the table already exists, then drop the table. Real simple.

I think what you are asking is the opposite of what has been asked for years, to automatically save data, because much data has been lost by not clicking the save button. Access has always provided the "Undo" method for each Control and Form. I recommend making use of those methods.

The problem is with the LOG Function, and specifically the "BASE" of the Function, but not a problem at all. It is just the matter of understanding how the LOG Functions work in the two applications. The default Base for Excel is 10. The default Base for Access is 2.718282, referred to the...

SQL Server does not have an Attachment Column like Access does. What you can do is create a Column that is of the VARBINARY Type, then use the File System Object to "Stream" the File into the Column. It is pretty slick. I recommend having the separate Table with a One-to-One Relationship, not...

Hi Charlie, You want an Parent Report Sub Report arrangement. The Parent Report will have your Titles., placed in the Detail Section Your Sub Report will have the Series. you will add Group to the Report for the Comic Book ID, and set the Header Visible Property to false. Next you will add...

HI, I am a little late to the party as always, however here is a great resource for all your VBA programming needs, While it is a bit dated, it is still very relevant today... Access Cookbook, 2nd Edition by Ken Getz, Paul Litwin, Andy Baron Released March 2004 Publisher(s): O'Reilly Media...

Ah, yes, I assumed left to right, but I now see the value after the slash is the primary, so yes, split would work.

Calculated or computed columns do perform better than Query Expressions. It also saves time sourcing it in other areas, Also, if the DB ever gets migrated to SQL Server, it is the preferred method. Nothing wrong with calculated columns in Access. The Format function will not work in computed...

Assuming you do not have access to the table or query where this values are being sourced from, which is where I would correct the matter if I could. But from a novice perspective, I would Replace the "/" with a "." then use the CSng() to convert it to number then perform the sort on that...