Search results

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

There are a couple of problems with that statement, I will take a non-academic approach. I am sure the decision makers commiserated this notion more than 100 years ago. While electricity did propel the advancement of the automobile industry, I think they already realized that electric motor...

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

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