Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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