Search results

Yes Replace .AllForms with .AllReports

Public Sub ListAllForms() Dim oForms As AccessObject With Application.CurrentProject For Each oForms In .AllForms Debug.Print oForms.Name Next End With End Sub

The latest version of Access Runtime is available if you don't have it with your current Office license. I think it can be installed with older click-to-run versions of Office. I don't know if there is a modern non click-to-run version of runtime. Have you tested you application on runtime? It...

Then you have a much bigger problem the a button being enabled when it should be disabled. You have no data integrity!

How is that possible? Do the users have direct access to the tables?

If the button is in the sub-form, you need to add the sub-form to the reference. Me.SubFormControlName.Form.cmdNewContact.Enabled = False

if customer is NOT selected then the ID will be NULL. Add NZ to the if. If NZ(Me.cboCustomerStatusID, 0) = 1 Then 'Normal Status

I don't know about anyone else but 90 controls on a single form would i.m.o. be pain full to work with. My worst form has maybe 40 including columns for a sub form; most of the other controls are for lookup.

If you think about it, Access is more likely to be IO bound then CPU. Once the BE is shared on a server, data transfers on you network will be the bottle neck. Our current servers have mirrored solid-state drives hosing the BE on an all Cat6 network.

Are you sure the last record is not triggering an error? If you don't have error trapping on this function, add it and try again.

I was lucky to work with a shop full of very good sheet metal fabicators.

I spent some time tooling a Trumpf 2d CNC punch using Tecsoft ProCAD. Planning moves, tool loading, tool type made huge differences. For example cutting a 20 x 30 rectangle hole with a choice between nibbling with 1/2 inch round punch and 1" inch long parting tool. The easy choice is nibbling...

My previous example was in training. Another one, I was modeling a vertical structural element for a gripper elevator. It was an "C" shaped part with multiple hole patterns that I mirrored across a 45degree plain of a 90 degree bend. It would take 20 to 30 seconds to go between flat and formed...

I don't know what was producing that part. It could have been a punch or laser.

Is the 2gb limit your application's memory limit? Doesn't Access/Windows cache table data in in memory as it's loaded?

Yes, the hole wizard adds the 1st hole that does most of the calculations to place a hole. The pattern tool puts a grid of holes X,Y across the sheet. The pattern tool has an option to exclude some of the holes. This is more efficient because the complex calculations are only done once for the...

About 12 years ago Solidworks. The hole pattern was inserted on a grid of points with some of the holes removed. To fix it the hole pattern was inserted using a pattern with some of the holes removed in the command. So the 1st method created thousands of individual hole objects, the 2nd method...

On a 12 year old HP Z200, i5 3.33GHz, 16GB memory, SSD Drive, ran 2 - 30000 seconds. This was the spec for Solidworks back in 2016 except for the SSD drive.

No SMB if extremely insecure, I don't think you would ever want to expose it to the Internet.

The nice thing about having a running production application warts and all is you have a good staring point for a system requirements document. It also provides the ability to compare functionality with your new application during testing. Even better if you can encode that functionality in unit...