Search results

The one mistake that I see often when dev's are creating reports, they seem to worry too much about the underlying record source and not enough about the design features of Access Reports. First tip, save the Report SELECT Statement as a Query if you have not already done so. I makes managing...

If you have the Allow Edits set to False, Button Clicks will be ignored on that form. The workaround that I have used is set the RecordsetType to Snapshot. Form.RecordsetType property (Access) | Microsoft Learn

Print Preview is simply that, Print Preview. You can either toggle through the pages, or you can select one of the Zoom options from the Ribbon, but if Report does not have enough data to preview, then you will not see them.

Please take Plog's advice above. First perform the Union in SELECT Statements, then create the Crosstab. Union Queries require that all columns are property ordered and of the same datatype. If the number of columns and types from first crosstab do not the number and type of columns from the...

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...