bullfrog83
Last Activity: Jul 21 '11, 03:24 PM
Joined: Apr 20 '10
Location: Harrisburg, PA USA
-
I understand that. I'm not talking about whether addresses should be in the same table as people or organizations. Addresses are going to be in a separate table because a person and an organization can have more than one address. My question is because people and organizations both have addresses, should I have two address tables - one for people (PersonAddress) and one for organizations (OrgAddress) - or just one Address table that has a PersonId... -
bullfrog83 started a topic What is the best practice for databases containing People and Organizations?in SQL ServerWhat is the best practice for databases containing People and Organizations?
I'm creating a database that will contain person records and organization records. So, I have a Person and Organization tables with a PersonId and OrganizationId pk's respectively. Both people and organizations share common attributes like address, phone numbers, etc. My question is for these attributes should I have separate tables like PersonAddress and OrgAddress or have one address table but with two fk columns: PersonId and OrganizationId where,... -
How to Hide Database Read-Only Database Message
I'm creating a database in which more than one user can be logged in at a time. However, I've found that if more than one user logs in they get a message bar that states: "Read-Only This database has been opened as read-only. You can only change data in linked tables. To make design changes, save a copy of the database." And there's a "Save As..." button to the right. Is there a way I can hide this? -
How to Use a Global Variable in a Report's Format Header Event
I have a form that contains parameters for a report. After the user clicks Preview I have code that set's the Where clause for the report's record source. Once the report opens I close the parameter form. However, the user enters values on the parameter form that I want to display on the report (StartDate and EndDate, specifically). But because I close the parameter form (otherwise it'd be in the way of the report) I lose those values and they don't... -
Can You Allow A SELECT-Only Query?
I would like to give my users the ability to create queries. Therefore, is there a way I can on the click of a button open a query design window that only allows them to create SELECT-only queries? Because I obviously do not want them being able to create UPDATE, DELETE or APPEND queries, even though they likely wouldn't know how to anyway. Thanks! -
Me neither but I appreciate the assistance! When I append that line of code I get the error "The object invoked has disconnected from its client".
I also figured out how to close the merge template so my above code is revised as thus:
Code:objWord.Visible = True objWord.Documents(2).Close wdDoNotSaveChanges objDoc.ActiveWindow.WindowState = wdWindowStateMaximizeLeave a comment:
-
SetFocus does not appear to be an attribute of either objWord or objDoc.Leave a comment:
-
How to Correct Issues Opening a Merged Word Document in VBA?
I'm opening a merged word document from Access using VBA and I'm having two problems. When the user clicks the Merge Template button code executes that sets a query for the data merging and at the end of the code I call a UDF that opens the merged document. This is the code in the UDF:
...Code:Public Sub procOpenMergedDoc(strFilePath As String) On Error GoTo ErrorHandler Dim strDbFilePath As String -
Yeah, but that doesn't work. I get errors.Leave a comment:
-
How to Use the In Operator in Query?
I have a query in which I parameterized a column (CodeCommitteeI d). Because more than one committee can be selected I'm using the In operator. So, in the criteria line of the CodeCommitteeId column I have the following:
However, when I run the query if I enter 1,2 as the parameter value, I get no results. But if I enter only one number I get results....Code:In ([Forms]![f_ParamCommittees]![txtCommitteeList])
-
Yes, I used my own control name (e.g. Forms!f_Familie s.cboChurch.Set Focus). I've attached my db. Again, the code is triggered on the OnClick event of the Sign In command button on my f_Login form. To test the code, use these credentials on the login form:
username = michele
password = shelly
She is the only user set up.
Thanks!...Leave a comment:
-
That doesn't work. The reason I want so many forms open is because I have my forms open as tabbed documents with the documents tab displayed so when the user logs in, he can easily tab between the four main forms now open. I could open my f_Families form last (and I thought of that) but I want the tabs to be in a specific order. Is there another way to get at what I want?Leave a comment:
-
How to SetFocus on an Opened Form?
I have a login form. If a user enters the correct username and password I want to open certain forms and close the login form (among other things) when the Sign In button is clicked. I have this code in the cmdSignIn_Click () event:
...Code:DoCmd.OpenForm "f_Families" DoCmd.OpenForm "f_GiftProcessing" DoCmd.OpenForm "f_Reports" DoCmd.OpenForm "f_SysMaintenance" DoCmd.Close
-
How to Increment Default Value for Each New Record
I have a form with two textboxes: txtSortOrder and txtCourse. I want the txtSortOrder's default value to increment by 10 for each new record (this is to save data entry time). So, if I type in 10 for the first record, the default value for the second record is 20 and so on. Right now I have this code on the form's AfterUpdate event:
...Code:If Not IsNull(Me.txtSortOrder) Then Me.txtSortOrder.DefaultValue = Me.txtSortOrder.DefaultValue -
No problem! Keep in mind that this code works if your xml file is named customUI.xml. If it's named something else then you'll have to replace the "customUI" in the code with whatever you've named your file. I only have one ribbon in my db so customUI was good enough for me.Leave a comment:
-
I found a way to load the ribbon from an xml file which I prefer. I call this function in my autoexec macro:
...Code:Public Function LoadRibbonsADP() On Error GoTo Error_Handler Dim strXMLPath As String Dim strXMLData As String 'get the path to the ribbon and make sure it exists strXMLPath = CurrentProject.Path & "\customUI.xml" Debug.AssertLeave a comment:
-
How to Open a Form via Access Ribbon Tab
I'm creating my own ribbon for my Access db using xml (I am a novice at this, however.). Is there a way to have a form open when a user clicks on a ribbon tab? I know you can open a form by using a button control which I've already done. There doesn't appear to be a way to do this on the tab element but perhaps there's a way around this, like clicking on the tab causes a (hidden) button to be pressed that triggers a form to be open? Basically, I'm... -
AutoExec Not Loading Ribbon
I have the following code in my AutoExec:
...Code:Dim strRibbonName As String, strXML As String strRibbonName = "customUI" strXML = "<customUI xmlns=""http://schemas.microsoft.com/office/2006/01/customui"">" _ & "<ribbon startFromScratch=""true"" /></customUI>" Application.LoadCustomUI -
If that's true, then I wish I knew what the problem is! If I set it to Modal only then I'm alright. But if I set the PopUp property = True then I have the problem. There's another post (albeit old) on bytes where someone else encountered the same problem and had to create a delete button next to each record to solve it. I think that's superfluous. The thread is titled "Delete record on popup-subform impossible?"Leave a comment:
-
How to Hide Ribbon in ADP
I'm trying to hide the ribbon in an Access Data Project. I have a sql table called USysRibbon with the fields RibbonName and RibbonXML.
This is the function that loads the ribbon:
...Code:Function LoadRibbonsADP() On Error GoTo Error_Handler Dim rs As ADODB.Recordset Dim i As Integer 'open the table containing ribbons. Set rs = New ADODB.Recordset
No activity results to display
Leave a comment: