Search results

accessApp.UserControl = true Managed to find it.

Funny all the examples looked up online show this as the way to do it. But, as we know its bulls'it. So, what does work? TIA doco

Using Excel 365, Win11 Machine [ Sub OpenReferenceDb(control As IRibbonControl) ' create new access object ' declared in general declarations Set appAccess = New Access.Application ' open the access project Call...

From my perspective the NULL was not expected as the field should not be null. However, its an FCC dataset. They have the sloppiest data of anyone I've seen. A great deal of time is spent cleaning up their messes. Pretty indifferent folks there - so, no surprises here. BTW, there was missing...

Yes, but its 2.38 million rows in a pipe delimited text file - a little busy. I'll check again. Thanks

I am importing a flat file (*txt pipe delimited) into sql server. As you may see for column five (call_sign) nulls are not allowed. Yet I get this error when attempting to insert: Any help would be appreciated. TIA doco

Thanks all! I used a query for the form wizard. Yet, I had to create and recreate the report a couple times before the text actually showed up in the field instead of the id.

Instead of using report wizard?

DLookup() gives a circular reference error

I am using Office 365 on Windows 10 Pro machine. I have two tables referenced having a 1:N relationship. The one side table has several fields that get populated using Lookup Wizard through a dropdown box as does the many side. The problem is one of the fields from the one side table insists on...

Apparently, there is no way to create an add-in database (.mda, .accda) in Access 365?

Thank you for the response. I know how to change for the current database. I want to change the default so I won't have to visit options again for that issue.

Is there a way to change the default for forms from tabbed to overlapping? Tabbed is just stupid... TIA doco

I think you missed the point of the comment. I understand class objects and instancing those objects (at least at a base level). However, in context of my comment, if you reference the original form Forms!f_mainform!f_someformname.Form.Requery You will have an error. If reference is...

It's worthy of note, if you create and embed a subform based on an existing form, the name of that form will not show up in the navigation pane. EG. If you have a form named f_someformname. Then embed a subform control in a form based on that form and name it sf_someformname. sf_someformname...

I still do not know why the acCmdInsertHyperlink command creates a network folder share on my computer and cannot get it to quit. So, the next best thing is a work around: Private Sub cmdInsertLink_Click() Dim fFile As Office.FileDialog Dim vFile As Variant Set fFile =...

Map to a network drive. EG: Z:\\etc, etc,

A simple text box being populated by a command button instancing the DoCmd in the subject line. I have used this extensively over the years and it works fine until now. Private Sub cmdImage_Click() Me.image_path.SetFocus Call InsertPhotoLink End Sub Public Sub InsertPhotoLink()...

Having a similar question. How can one coax the borders of the text boxes to be displayed on the printout? I have set the Gridline Style properties to Solid in place of transparent but still does not show on a print. TIA

As mentioned the text box is in the report footer. I have tested the code in the open, load and activate events. All with the same result.