Search results for query: *

Using Office 365 I had to change computers. I copied a database (front and back end) to a USB drive, then put it on the new computer. When the database opens it goes to a Switchboard. From there I should be able to navigate to a number of other forms, using command buttons. But none of the...

This is a database that tracks information for members of a Kiwanis Club. On frmMembers, there are five tabs, two of which are "Membership Data" and "Legion of Honour." The Membership Data tab has a number of controls, plus a subform "fsubAwardsGiven." The subform has four controls: Award...

A form, which has a subform, to edit donations from church donors. In a form, the user can enter a number in a text box. If the number is valid, the subform is populated with data. What I want to do is have a procedure so that if the number entered by the user is not valid, a message box comes...

Using Access 2016 Form frmEditNewGivings (for editing donations made by donors, or deleting entry made in error Has subform fsubNewGivings On the Form, there is a List box containing all the Envelope numbers assigned. User can select a number from the List box. This opens the subform to...

Using Access 2016 Church donations database On a form where donations are entered, there are the following controls all in a straight line across. Date Given (date format) txtEnvNbr (everybody has a donation number that corresponds to their donations envelopes) Local (format: $#, ##0.00...

Using Access 2016 Donations part of a church congregation database If the user wants to Delete a donation for a particular donor, the form is opened, the donor selected, and the record desired for deletion selected. The user has two choices: (1) press Delete on the keyboard, or (2) press a...

A Kiwanis Club database... When a database opens, the first form to come up is frmSplash. Behind that form lies the following code: Private Sub Form_Timer() On Error GoTo Form_Timer_Error DoCmd.Hourglass True Me.TimerInterval = Me.TimerInterval - 50 If Me.TimerInterval = 0 Then...

A report that is laid out in 4 columns on an 8 1/2 x 11 page. Sorted Alphabetically. Running vertically and then horizontally. The columns include names, addresses and phone numbers. A section header takes the first letter of the last name. Thus... A Abraham Adams Anderson etc. B Barnes...

Following is code in a form that is used to produce a new record in the event that one person of two in a household dies, or they separate. What the code does is take all of the information regarding name, address etc. and create a new record. Now, say you query the table and, using an IIf...

A Query in a church database has the following column. AddressCheck: IIf(IsNull([AptNbr]),"",[AptNbr] & " - ") & [tblTrinity].[HouseNbr] & " "+[tblTrinity].[Street] & IIf(IsNull([Address2]+[tblTrinity].[Street]),"",Chr(13)+Chr(10)) & [Address2] This should, for example, produce the following...

A report in a church database produces pages of records of parishioners to send to a company that will print a Photo Directory for the church. The company's printing requirements are pretty specific. 8 1/2 x 11 size pages, four columns across the page, vertically then horizontally. Arial Narrow...

A Kiwanis Club database, 2010 format. A form called frmMembers. The SQL behind the form is SELECT tblMembers.MemberID, tblMembers.LastName, tblMembers.FirstName, tblMembers.MiddleName, tblMembers.PreferredName, tblMembers.Partner, tblMembers.DateOfBirth, tblMembers.WeddingAnniversary...

Using Acccess 2010. A church database. I have an unbound form called "frmDateAndSeriesSelector" On it there are 4 unbound text boxes. Two are for entering dates and are named "txtStartDate" and "txtEndDate". The other two are for entering Envelope Numbers, and are named "txtSeriesStart" and...

Using Access 2010 for a church database The following SQL pulls names from tblTrinity SELECT tblTrinity.UniqueID, tblTrinity.LastName, tblTrinity.FirstName, tblTrinity.AptNbr, IIf(IsNull([tblTrinity].[AptNbr]),"",[tblTrinity].[AptNbr] & " - ") & [tblTrinity].[HouseNbr] & "...

The following code is supposed to enable to user to add new items to a combo box. It worked fine in Access 2007, but results in an error in Access 2010. The offer is made to add a new item, but then when you attempt to do so a message comes "Error 3075 (Syntax error (missing operator) in query...

Using Access 2007 I am trying to use a command button on a form to transfer data from a spreadsheet into an Access table. The table has the following relevant fields: RecordID (autoNumber), EnvNbr, Local, M and S, Building, Memorial, Other, Date Given, InMemoryOf, ToFund The Excel 2007 sheet...

Using Access 2007 In an electrician's database, there is frmCustomers. One of the tabs on that form is for Projects: this is where the user enters Materials and Labour for that Project. So there are 2 subforms, fsubMaterials and fsubLabour. I am concerned with fsubMaterials - displayed as a...

Using Access 2007 For whatever reason I am having a brain cramp here. A electrician's database has a Materials Markup that could be anywhere from 0% to 20% (20% is the default but can be changed by the user). In a query I want to convert that percentage to a decimal number. e.g. change 20% to...

Using Access 2007 A database for my son-in-law who is an electrical contractor. On frmCustomers, there is a tab called Projects, which opens fsubProjects upon which Projects for individual customers. On that fsubProjects there is a fsubMaterials, in which are entered the Materials used for a...

Using Access 2007 This should be relatively easy but, for whatever reason, I am having trouble getting things to work properly. On a form there are 2 list boxes. The first list box, called lstYearLastVisit, has the following row source SELECT qryPatients.YearLastVisit FROM qryPatients GROUP...