Search results

Yes, when I run the SELECT statement, I receive data for all the fields.

I have a comb box on my form named cmbUserName. I am using the following query to populate the combo box: SELECT [qryByCity].[MyName], [qryByCity].[MyAddress], [qryByCity].[MyCity], [qryByCity].[MyState] FROM qryByCity; **Note qryByCity is a query that is pulling data from a table named...

I finally figured out what I was doing wrong. I was not adding the code to the VB part. Thanks!

I tried adding Me.cbOrder1.Value = Me.cbOrder1.ItemData(0) to the On Load property for the form but I received a message: "EIB system (this is the name of my program) can't find the macro 'Me.' The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note...

This should be easy, but I can't seem to figure out how to do this or find an answer. I have a combo box that I have manually entered data into the Row Source property. I want the first item in this list to be selected whenever the form is loaded. What do I need to add to the Default Value...

THANKS!

I have a query that I can't get to work correctly. I want to pull ALL company names from my tblCompany table. If the Company has a parent company, then I would also like to see the parent company name. The problem is that when I run this query, it displays only companies that have a parent...

Thanks for your help! The IS NULL statement did the trick.

I'm trying to create a query that will kick out any records that have the word Closed in one of my fields. SELECT Company_T.* FROM Company_T WHERE ((([Company_T].[COMPANY_CLIENT_STATUS]) NOT LIKE "*" & "CLOSED" & "*")) ORDER BY [Company_Name]; This query somewhat works. It does not...

Thanks for for your help. I was using NOT EQUAL TO instead of NOT EXISTS in my query.

I'm having problems creating an append query. I have 3 tables: P_Table --> (fields) PNum, Pname, Pcity IP_Table --> (fields) IPNum, IPname, IPCity M_Table --> (fields) MNum, UserName, UserInfo I want to append all the data from IP_Table to P_Table only if the value of IP_Table.IPNum is in...

I've got an imput mask on one of my forms that is having problems. Since the first of 2002, one of my fields will not record the year 2001 correctly. This field on the form (named STDate) has 99/00;;_ for the imput mask. Also, the table that houses this data has an imput maks of 99/00;;_...

I have written the following two queries: SELECT comaster.county, AVG(comaster.hour_rate) as avgrate, COUNT(comaster.co_number) as sumzero WHERE comaster.hour_rate > 0 FROM comaster GROUP BY comaster.county ORDER BY comaster.county SELECT COUNT(comaster.co_number) as sumall FROM comaster...

I tried changing it to single quotes, but it is still behaving the same way as before. Any other suggestions?

I made the changes you suggested and it seemed to help. If I enter a numeric value, the "is there" and "not there" works correctly. If I enter an alphanumeric ContactID that is not in the database, it works correctly, BUT if I enter an alphanumeric ContactID that is in the database, I receive...

I have ContactID set as a string in my table. Whenever I enter an alphanumeric ID, I receive the following message: The expression yu entered as a query parameter produced this error. 'The object doesn't contain the Automation object '123'." Whenever I enter in a numeric ID, I receive this...

I entered the following code for the onclick event for one of my forms. If DLookup("[ContactID]", "Contacts", "[ContactID] = " & [Forms]![frmTransNotesHist].[ContactID]) Then MsgBox "is there" Else MsgBox "not there" End If When the code is executed, I receive the following message: The...

How can I check to see if a value exist in my table with VBA? This is what I would like to be able to do, but I may be way off. IF [Forms]![frmTransfer].[MyValue] NOT IN tblCompany.CompNum THEN ELSE Thanks!

Thanks!

Thanks for your help. The query works great!