Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: THWatson
  • Content: Threads
  • Order by date
  1. THWatson

    Command buttons not working

    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...
  2. THWatson

    Writing a value from a form into a subform

    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...
  3. THWatson

    Procedure for Message Box if value entered in text box has not been assigned

    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...
  4. THWatson

    code to update list box with results of text box

    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...
  5. THWatson

    Controls showing #name

    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...
  6. THWatson

    Code behind Command button to delete record

    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...
  7. THWatson

    code to ask if user wishes to print a report

    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...
  8. THWatson

    Keep section header from starting at an inconvenient spot

    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...
  9. THWatson

    Strange appearance of Hyphen character

    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...
  10. THWatson

    Query inserts a character but only in certain instances

    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...
  11. THWatson

    Force new line under certain conditions

    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...
  12. THWatson

    #Name? error

    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...
  13. THWatson

    Attempting to Preview report results in No Data

    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...
  14. THWatson

    SQL leading strange results

    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] & "...
  15. THWatson

    Error 3075 Syntax error (missing operator)

    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...
  16. THWatson

    TransferSpreadsheet error

    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...
  17. THWatson

    Carrying field value from one record to the next

    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...
  18. THWatson

    Convert Percentage into decimal in Microsoft Access query

    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...
  19. THWatson

    Confirm automatic entry or change it

    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...
  20. THWatson

    update one List Box row source from value selected in other list box

    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...

Part and Inventory Search

Back
Top