Search results

The CR will actually stop working way before the 2gb mark, probably closer to 1.85 it will choke. As for 4100 tables, likely a lot of temporary or analytical tables that need to be removed. In the Manufacturing ERP that I developed, which was highly normalized, had just shy of 100 tables. It...

Sounds to me like there are memory leaks. Recordsets not be properly closed. Also, forms and reports open in the background, especially that are not filtered record sets, will unnecessarily use precious resources. Forms and reports need be closed when not in use.

Work with the Print Event and Format Event for the section

It sounds to me like you have AllowNewRecords set to false. If you have DataEntry set to True, it will not show records. Also, while I hate tab controls, preferring navigation controls, If I have a filtering mechanism on a subform, it needs to located in the header or footer section. Try...

I take the elementary approach. I import a PDF using the Import Wizard Software by Beside Software. It can be integrated into VBA and ran silently. Each Row of Text on the PDF is stored as a Record. Data is rendered to the Screen in a Rich Text TextBox. The Search Routine will search to get...

Hi, hope this helps… There is really no built in way to do this. I learned this lesson a long time ago. Now in every application that I build a implement a routing handler for all open message whether it is a table, a query, a form, a report, etc. I have a table called object usage log every...

Personally, I hate specs. They are not reliable. I usually link to the Source from a query rather than as a linked Table. I will call that a base query. I will then create a second query to do all the data cleansing and go from there.

I would use a Boolean variable to skip but stay inside the loop and what I do inside the loop, or use Exit For to escape the Loop. I would use GoTo's or GoSub ... Return if I need to handle many sub routines inside the same sub procedure or function. If those sub routines can be used elsewhere...

Please remember to mark this post as solved so we will stop commenting on it.

Hi, Hope this helps.... In VBA, this sample sets the Column named "ID" in Table named "Table4" to begin at 10, with increments of 10. The first argument is where it begins, the second argument is the increment. CurrentDb.Execute "ALTER TABLE [Table4] ALTER COLUMN [ID] COUNTER(10,10)" In this...

Sorry for the delay in my response... The ERP started out with an Access BE (Back-end) Database. We had an FE (Front-end) User Interface that was distributed to each User's Computer. The FE was linked to the Access BE that was located on a dedicated computer. PS. I never used Mapped Drives in...

No Worries, I had just commented yesterday. Here is my test script [...], give a whirl and let us know if you discovered the table issues. Sub DAO_Test_Links() On Error GoTo Err_Handler Dim db As DAO.Database Dim tdf As DAO.TableDef Dim rs As DAO.Recordset Dim strTDF As String Dim strSQL...

Hi, A lot of times this error is generated by broken links to external sources. If the source table has been renamed, moved, or deleted, this particular error will occur. I have a toolbox of code I have written over the many years that helps me analyze the integrity of an access application...

Sorry sir. Got twisted on who was replying.

Here I used the Northwind Sample Database as an example. I created a Query named "qryOrders_for_Report_Sample" with the following SELECT Statement. I added one Expression Column for Total Price. SELECT Orders.[Order ID] , Orders.[Order Date] , [Order Details].[Product ID] , [Order...

I think you are confused. Just use either the Group Header or Group Footer to SUM() or COUNT(). For example, the Control Source to a text box in either section expressed as =Sum([QuantityField]). However, I do not see that you are summing or counting anything in the original post...

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