Search results

After reading the original post and some your replies below, here is my 2 cents. Enable Editing on the Form Disable Adding New Records Disable Deleting Records Lock all of the Controls except for the Combo box. You can have additional actions triggered if needed on the Before or After Update...

Hi, What Code do you have that runs when the Popup opens in the Open Event? What about the Current Event? Do you have any Timers running in the Backgound? You can sometimes smooth them out by using the DoCmd.Echo False Command before the Open Statement and DoCmd.Echo True when the code has...

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.