Search results

Hi all, I've got some code to update Excel page headers in my Workbook_BeforePrint method: Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim ws As Worksheet Set ws = Worksheets("Sheet1") ws.PageSetup.LeftHeader = ws.Range("A1").Value End Sub Public Sub PrintSheet()...

It would be nice if they would put some work into the SQL editor. It's madness!! :-)

Is there any way in Access 2007 and up to stop the auto formatting of queries? For example: line 1 line 2 line 3 becomes: line1, (line2, (((line3)))) It seems to be fine as long as you avoid the design interface but sometimes there's no escaping.

Or not... I was a bit too optimistic it seems.

Seems like using stored queries iso select statements for my main form is doing the trick.

In a split database consider the following scenario. I have a main form which is essentially a list of employees. Editing an employee takes place in a pop up dialog. When I close the dialog I'd like to update the data in my main form. I'm doing this by means of an event: Dialog.OnUnload will...

Hi, I'm creating a right click menu that appears when the user clicks on an 'action' button. The button is part of a continuous form and allows the user to perform some actions for each record: edit, delete, etc. I'm trying to figure out if I can bind the OnAction property of the menu buttons...

The issue seems to be that my form is a popup form...

I'm trying to display a custom ribbon when a form is open using the Ribbon Name property of the form. The ribbon is saved in the 'USysRibbons' table. I have verified that the Ribbon XML is correct. In fact here it is: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">...

After a bit of testing it seems that referential integrity has nothing to do with required fields. You can set up referential integrity and still have the foreign key field set as optional. Unless anyone has any further comments to make about this I think I'm ok on this one.

In table design you will find this option in the field properties. You can set it to yes/no. Other properties include length, allow empty string, etc...

Quick question: is there any use to setting a foreign key as required when the relationship already enforces referential integrity? Or could this have strange side effects?

Please ignore... I missed the documenter function under database tools...

Hi, I'm looking for a tool that allows me to get a printable overview of the Access tables in my current DB. Of each table (fe. Employees) I'd like to see the field names (fe. FirstName) and their most important properties (fe. Text(50) NOT NULL). Is there anything available that allows me to...

Sweet, it works now. Thank you so much, this will save me a lot of trouble in the future.

That's just a typo. It should be: Private Sub btnNew_Click() Set pChild = New Form_frmTrialNew pChild.Visible = True End Sub The reason why I'm creating an instance is because I might want to have multiple instances of a form open at one time.

In what way? We're essentially doing the same no?

You have a textbox and a checkbox. When the checkbox value is true you want to write a hyperlink in the textbox and that should be saved to the table? Is that correct?

Well it doesn't seem to work for forms. All events in my custom classes work just fine. But when I try to capture an event from a child form it doesn't seem to trigger. Private WithEvents pChild As Form Private Sub btnNew_Click() Set child = New Form_frmTrialNew child.Visible = True...

Your sql statement would look like this: SELECT tblEntitlements.EntitlementsID, tblEntitlements.[EntitlementName] FROM tblEntitlements WHERE Not EXISTS SELECT tblSystemEntitlements.EntitlementsID FROM tblSystemEntitlements WHERE tblSystemEntitlements.EntitlementID =...