Search results

You need to create a unique indentifier as your primary key for the table with the companyname field so that you can have more than one company with the same name. The other option (and perhaps the better one?) is to have a table with company names, a table with addresses, and a third table...

Are you building this option in your query or in VB code? Easiest way would be to have the form which sets your beginning and ending date use the datediff function in it's default value box. Just set the datediff as you have on the switchboard to be the default value for tBeginDate and tEndDate.

Could you post your solution so that anyone else searching for this problem can find it. Thanks! :)

If you want to declare the date value then you need to use # signs not '. Concatenate two strings with an ampersand, not a +, and put a semi-colon at the end of your SQL statement. strSQL = strSQL & " AND ((tblResults.DateNumeric) Between (#" & Me.StartDate & "#) And (#" & Me.EndDate & "#));"...

Here's an interesting one for you, I have two ways of searching. If there are more than one sites with a record in the query, then the db opens a form which lists all of the sites in detail so that you can select a specific one. I'm using a recordset clone and bookmark from the second form for...

Combo Box updating despite BeforeUpdate Event Okay, I had an event in the Click property of the box. So that problem is solved. Now here's the problem... whenever I tell it to search, rather than just searching for the record, it updates the value in the combo box to the record that is...

Check out this site. I found it using the link in the post I linked to above. http://www.info-zip.org/pub/infozip/UnZip.html#Win32

Did you search this forum yet? Try this: Zip Files in VB

Stupid question but, did you include "Between" before that string in your query?

Well it seems that your issue is related to queries. How are you not using queries in your database? Most of your reports and forms should be based off of queries as this helps protect your tables and makes your data much easier to access and manipulate. If you want to print the report based...

I have a combo box on my bound form which has a control source in the query and a row source of another query. The combo box has the following code associated with it's BeforeUpdate property: Private Sub cboSiteName_BeforeUpdate(Cancel As Integer) Dim rs As Object Dim rst As New...

Set an event in the subform to bookmark the record and then set the parent form's bookmark to that record.

How did you define the row source for the list box? And how are you storing the notes in your table? Is each note stored in a separate field, or is this one large memo field with notes stored in it? It sounds like you need to check your query to see that the case number for the subform is...

It sounds like you need to have code in the On Current event of your form which scans the fields and sets the properties as required. Have the code get the value of the field that holds the requirement (Me.FieldName.Value = True) and then set the properties of the remaining fields...

Wow. Well to start with change your structure! :) You should have a table with customer information, another with order information, a third with package information, and a fourth linking the customer with the order numbers (so that a customer may have more than one order). Set a unique ID...

would that parameter be the second date? I.E.: the ending date? I notice that you have two boxes, what appear to be a start date and end date, however not speaking German... Now if you could translate that into Spanish... :)

Well you could create a report with a snaked column feature and have the report read the records from the query, triggered by the On Click event of the form.

Found Answer I had the wrong set up in my combo box's row source. I set it to only one of the two fields that needed to be updated in the recordset, not both. Chalk it up to being sick (or stupidity... either one really...) :)

I am working with SJ McAbney's post on updating a table using a combo box when the entry is not in the list. However, each time I try to add a new entry I get an error message that I am creating a duplicate value in the primary key or index. yet the value is added to the table which the combo...

Aiden, Is the control you are searching unbound or is the control the box you are using for the search. If it is unbound, then how are you searching it for a primary key? If not, then try setting a bookmark rather than using GoTo