Search results

Try this: Create a new query in the query designer. Add your two tables and link them. Add some dummy data into the criteria fields you wish to search against. Try it out to see if it returns the records it should. Then from the View menu, select SQL View. There is your query. All u have to...

BTW, to answer your question, try: If Market = "2" and StartDate > #1/1/2004# then opt2004 = -1

U could try just checking the year? For example: If Market = "2" then if Year(StartDate) = 2004 then opt2004 = -1 opt2003 = 0 end if if Year(StartDate) = 2003 then opt2003 = -1 opt2004 = 0 end if end if

Always a pleasure to help a fellow Aussie... Even if u are from Melbourne! :D

I have a database which about 10 people use pretty much all day. It's set up so it uses a front end and a back end, and i had both the front end and backend on the server until recently. Half the people are using it directly and the other half are using it via Citrix. Problem is the front end...

U could probably do that in code by grabbing each contact for that company and creating a value list for the listbox... Do u have another table with company details or something that company name is related to? If u do then i should point out that the way u have that table set up is not the...

Nothing that i can see, unless u spelt frmSearchPerson wrong ... What if u try closing the form before u open the other one? Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmProposerMain" stLinkCriteria = "[ProposerID]=" & Me![lstResults] Me![lstResults] = ""...

Do u only want to display it like this? In a report or form? Or do u want to store it in the table like this? If it's just to display in a form or report, change the format property to: 00\*00\*00\*00

Are your totals coming from the query or are u calculating them in the report? Where are the totals located (ie which section/footer?) Does the report only display the one record?

Not 100% sure, but the way i see it, U have a combobox that contains 2 fields: CustomerID and Name The u have a subform that has a textbox which is displaying customerID. Is the subform bound to the same table as the Main form? When u say u created the subform from the main form, i assume it...

The way i've done this is have the user select the report at the top of the form (using radio buttons), and then select the criteria they want to report on down the bottom (using combo box's mainly). Then when they click the print button, i build a (rather complex at times) filter (although...

When i changed over to sql server, it changed all my table names (added dbo in front of them), so i had to rename them all back again. Could this be the reason?

The easiest way... Go into startup options (Options menu -> Startup) and select the form u want displayed when users open the database, under the Display form/Page combo box. Remove the Check from "Display Database Window" Remove the Check from the "Allow Full Menus" Remove the Check from...

Try changing rs.[Fivecents] = Me![Txtmultiply5cents] To rs![Fivecents] = Me![Txtmultiply5cents] As for bracketing, u don't really need any. So: rs!Fivecents = Me!Txtmultiply5cents Would work fine. Bracketing is mainly used when field names have spaces...

Ok, there are a few problems there... With your name search combobox on frmPerson, you were trying to use it to search the form as well as store the name in the table. That's why it added a new record everytime u selected a name. Remove the [name] field from the combo box's control source...

Good question... :confused: Problem is, the required property in a table only works for each record in that table. As the partNo is in your subform, there's no real way of telling access that every time an order is placed, a partNo is required... By default anyway. U could probably get...

I did a simple test in a query and this worked ok for me: SELECT people.pFirstName FROM people WHERE (((people.pFirstName)=[people].[pLastName])); That's pretty much what your example is isn't it? I'm using Access 2000.

No your subform should be based on your junction table, cause thats where the data will be stored. Say your tables look like this: tblOrders ordNo ordDate etc tblParts partNo partDesc etc tblJunction ID jOrdNo jPartNo jQtyOrd etc Then your main form is based on tblOrders, and your subform...

No, the delete record command works on the currently selected record (in the same form as the button). U usually get the "The command or action 'DeleteRecord' isn't available now" error when there is no current record selected (or the current record is a new record?) or if your recordset isn't...

And if u want to know more about gotorecord, look up 'GoToRecord action' in Microsoft Access Help. It explains it much better then i could, lol. :D