Search results

To display the current month, create a text box and place this in the control source: =Format(Date(),"mmmm") To display the previous month, create another textbox and place this in the control source: =Format(Date()-31,"mmmm")

If you don't understand the need for "all those relationships," I'm afraid I'm going to have to suggest that you read up on database design before we go any further.

Okay, post your mdb again and I'll show you -

Are you using an autolookup query as the source of your form, or are you using code behind the combobox? If you use the combobox wizard on your form, and your form's record source is not blank, the wizard will give you an option to "find a record on my form based on the value selected in the...

You create a field called total_cost any time you want to know the result of a calculation, in a query or in code... Re: Access reference books, I have the Access 2000 developers handbooks ( Publisher: Sybex /Authors: Getz, Litwin, Gilbert). I also have a good VBA book called Access 2000 VBA...

Here is the revised db.

Hi - I did some tweaking to your form. Take a look and let me know if this meets your needs. I have a couple of other observations that I think you should consider when you're designing this database. 1. You should have a separate Projects table whose primary key is an autonumber field...

Take a look at the MS Knowledge Base article #310803 for information on reference issues. HTH Elana

Okay, is any value at all being saved after you perform the calculation? I don't quite understand why you're using a combo box to hold a calculated value. Also, FYI it is usually not a good idea to store a calculated field in a table. Can you post your database so I can look at it?

Are you getting an error message? Also, please confirm what the name of the combobox is -

If you're trying to requery the combobox cbototal_cost, then you need to requery it After Updating the no_units field. After Update Event on the No_units field: me.cbototal_cost.requery

Yes - I have done this before. Please take a look at the MS Knowledge Base Articles 102527 and 103135 for information on how to do what you want to do. HTH E

Put some code on the "on no data" event of the report to deal with this. Use a msgbox indicating there are no records, or have a text box that prints "no records" when there is no data.

Then take out the "cbo" if those letters aren't actually in the name of the combobox. =[combo2].[column](1) "cbo" is a prefix I use when I name combo boxes. Helps identify the type of object when I'm doing code. HTH Elana

what is the name of your combo box?

Obviously if you set the required property to True, then you must enter a number even if none exists, so you would enter 0, which then violates the Indexed(no duplicates) property of the field. I tried this and it worked though - do not set the required property to True and do not set the...

Yes, place an unbound text box on your form. In the control source of the text box, place this code: =[cboYourComboBoxName] This will display whatever value is located in column(0) of the combobox. If you want to display a value that is located in another column in the combobox, enter this...

For it to display the ampersand, you need to place two ampersands in a row in the field.

It is sorting on personnel FName/LName first, then on the clientname. Try changing the order by moving the clientname field ahead of the personnel name fields. Personally, I would change the source of the combobox to SELECT tblClient.ClientID, tblClient.ClientName FROM tblclient ORDERBY...

It should work if you have indicated the sort order in the query that is the control source of the combobox. If you have already done this, then post the SQL code behind the query and let's take a look at it.