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 Chriss Miller 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: lmcc007
  • Content: Threads
  • Order by date
  1. lmcc007

    Sort key not sorting

    When I try to sort the CompanyName field, it does nothing. All the other fields will sort like it suppose to. Also, CompanyName field is a subform on the main form. Any suggestions on how to get this to work? Below is my table structure: tblCompanies CompanyID dbLong PrimaryKey...
  2. lmcc007

    Bookmark issue

    When I am on the first record on the list and I open the form to delete that record, when closing the form I get Error Number: 3159--not a valid bookmark. Below is the code I am using: Dim bkMark As String If CurrentProject.AllForms("frmViewEventHistoryList").IsLoaded Then bkMark =...
  3. lmcc007

    Combo box question

    Is there a way to choose a number but display the text? That is, we have over a thousand records to enter; therefore, it would be easier for them to choose 1, 2, 3, 4 and so on instead of having to type the first few letters from a list, hit the down arrow and choose the correct one. The lookup...
  4. lmcc007

    Error 3075

    When the below code runs and there is no data, I get Error #3075 -- Syntax error (missing operator) in query expression '[CompanyID] = And [ActivityID] = 1'. Public Function JobTotal(ByVal strActivity As Integer) As Integer JobTotal = DCount("[ActivityID]", "Event", "[CompanyID]= " &...
  5. lmcc007

    Table Design re one-to-one relationships

    I am having trouble with this db because I want to throw everything into one table because of the one-to-one relationship with Event table. I’ve been taught that every subject should have its own table. The purpose of this db is to keep track of all the media, applications, release forms, and...
  6. lmcc007

    Date Dilemna

    Some of the dates are incomplete—such as, 12/2010 or just 1999; therefore, I had to change from using a Date/Time datatype to using three separate number fields—that is, Month, Day, Year. The problem is they want the fields to default to the current date, but still be able to change the date...
  7. lmcc007

    Memo field -- Error 3188, using Access 2007

    Error 3188: I have an EventNote table with three fields: 1) EventNoteID - AutoNumber 2) EventID - Number 3) EventNoteData – Memo The EventDetail form has a button to click to add notes, which will open to EventNoteData field. I found out if you are adding data over 2K it will not save or let...
  8. lmcc007

    Requery applying a filter

    Everytime the below code runs, it filters the first record (1 of 1). I removed all filters from the form and so on. When I close form 2, I want form 1 to show the changes, and I want to return the record I was on. Private Sub Form_Unload(Cancel As Integer) On Error GoTo ErrorHandler...
  9. lmcc007

    Using VBA color

    I have a button called cmdImage. Caption = "Attachment" and ForeColor = TextDark. I want it to display "No Attachment" in red when empty, and "Attachment" in Text Dark when it's not. That way, I will not have to click on the button to see if there are any attachments. I created the following...
  10. lmcc007

    Memo data type field

    Is there any problem using the Memo field in your databases? It was suggested from another site to store a memo field in a separate table (one-to-one relationship) to keep corruption from happening so much. I have searched the web and found no complaints about the using the Memo field...
  11. lmcc007

    Error: Control can’t be edited; it’s bound to the expression...

    I am doing a two-form approach for my search form. The form I am having trouble with is: frmFindACompany. frmFindACompany have 10 unbound text boxes, which I am using as labels because of the On Got Focus event. There are 10 unbound text boxes that I am using to enter the data to find...
  12. lmcc007

    Checking for Null & Select Case issues

    I have a form called fSearchforCompany with two unbound fields. After selecting a field from lstQuickSearch (list box) and tabbing to txtSearchBox to enter data, the correct form should open with the text from txtSearchBox entered into the designated field. But, first the code should check for...
  13. lmcc007

    IIf function

    In my tblAddresses table I have a lookup field called TypeofAddress (Business, Delivery, Home, Mailing…) I am trying to tell it to display only one type out of the bunch: TypeofAddress 1. If TypeofAddress is not equaled to 1 then display TypeofAddress 2 and so on. I created a query using...
  14. lmcc007

    Continuous Form

    I have a imgPencil on a continuous form. OnCurrentEvent is set to: If Me.txtActivityType = 22 Then Me.imgPencil.Visible = True Else Me.imgPencil.Visible = False End If The above code works fine on a Single Form. Is there a way to get it to work on a...
  15. lmcc007

    Duplicates phone numbers and extensions

    I have one table called tblCompany, which has four fields for telephone numbers. The fields are: Phone, Phone2, Phone3, and Fax. And, four more fields, which are: Ext (for extension), Ext2, Ext3, FaxExt. I want the code to check for duplicates when entering or revising telephone numbers. I...
  16. lmcc007

    Null value in field

    I have code to check for duplicate company names and it works. But there are times when I don’t have a company. They do not want me to use the person name as company name and so on. The code recognizes "" (quote quote) as duplicates. Below is how the CompanyName field is defined in my table...
  17. lmcc007

    Set Focus for nested tabbing from subform to subform

    When I TAB from the txtPhoneExt control of the subform (s_frmPhoneNumbers), I want the next subform (Child22) control to become the active control. And If I keep tabbing I want Child23, Child24, and then go to another subform s_Addresses. I am doing this so I will not have to hit Control Tab...
  18. lmcc007

    Normalization--design setup re repeated data

    I am creating a database from my Excel spreadsheet. I have an issue with normalization. I have two separate tables—tblCompanies and tblCompanyNames. tblCompanies gives other data about the company—such as, size, industry, press awards, and so on. tblCompanyNames only list the company names...
  19. lmcc007

    Contact Mgmt db design question

    What is the best or appropriate way of creating my contact mgmt database regarding phone numbers? Every example and template I look at all have separate fields for Business, Busines Fax, Mobile Phone, Home Phone... I'm trying it with a table (PhoneType and PhoneNumber) and only enter the...
  20. lmcc007

    Multi-field index

    I have a tblPhoneNumber table with five fields: PhoneNumID PhoneTypeID PhoneNumber PhoneExt CompanyID I created two indexes using the Indexes button on the Show/Hide ribbon. PhoneTypeIndex includes: PhoneTypeID and CompanyID. Which works--I can not create the same phone type for a...

Part and Inventory Search

Back
Top