Search results

Here is a use case... When I create a new DB starting from scratch, I usually begin with an Excel Workbook. I have an Excel Workbook Template that I use to construct Database with. Why? Because even though using the built-in Table Designer is easy enough, it is somewhat counterproductive. I...

Good Recommendation. I too have a similar table named [Counter_and_Report_Dates]. It is iterated from Day One and with an additional 20 years of dates. I named the Date column [Report_Date] and is computed from the autonumber ID Column. I then have several other Computed Columns (boolean type)...

First, your Customers, Vendors, Contractors, and Agents should ALL be in the SAME TABLE. You would have an Entity_Type_ID column to represent what type it is. You would have an Entity Types Enums Table to give a Type Name. The ID (Autonumber) CC column in this Table would relate to the...

While there is not a native function, instead of all the looping, you could simply use two of the native date functions, some simple IIF or SELECT CASE statements, to arrive at your answer. The DateDiff will give you the number of days between two dates. The only other issue apart from that is...

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