Search results

Looking at your relationships, you have 2 primary keys set in your Order Info table and Order Item Table. The logical thing to do (it seems to me) is 1. In the order info table only have the OrderID as the primary key. The CustomerID is your foreign key and links to the Customers table making...

Hi there, I think you will have to use code. Presumably you don't need to store the entries in your text boxes as they would be bound to your underlying tables etc. Have you tried removing the Iif function from the control source of your text box, making it unbound, then set the value of it by...

Try this =DLookUp("[Specs]","tblAssys","[ListID] = [Forms]![CurrentList]![ListID]")

You might find it easier to have sub-reports that are based on your queries. When designing your report you can only assign 1 recordsource. Generally if report is designed to display data from multiple sources then you would create 1 query as its underlying recordsource and this query can be...

You need to test for a zero length string: If Tier = "" Then TierInfo = "" End if Also have a look at using the Nz function

Create a new query that is based on your multiple queries then base your report on that new query

oooaarrrgggh :D

Hi It's far easier to put the criteria in the underlying query of your report. So let's say the name of your field on your form was OrderID, in the criteria for that field in your query you would put =[Forms]![yourFormNameInHere]![OrderID] This will work when you open your report form your...

Yes you can. Have a look at Access help, there's a whole load of information about customising the built in menus or creating your own menus and tool bars

This may or may not help you but I got around this problem by setting my currency field to a number data type and then adding another field which held a value list of the three currencies I use : Sterling; Euros & US$ That way each record had the currency identifier and I can then perform...

Hi, What I do is I have a table (tblUsers) which stores the user name, password and permission level. I force the user to login to the database by a login form and when they click OK there's a bit of code that uses the DLookup function to return their permission level and their username. These...

Ok need a little more information... Does your report run? What are you trying to report on? If your report runs are you getting the correct data? Does it ask for any parameter values? Etc.. Rob :confused:

Hi there I don't think you can e-mail objects as they are i.e. a query as a query. You can e-mail the results by using the SendObject action. If you need to e-mail the structure of the query then, providing your recipient has exactly the same .mdb as you, why not import the query into a new...

Apologies for that, I should have read your post properly :D The suggestion I gave would be fine for one record but it wouldn't update itself if you hover the mouse over the next record of the same field. As an alternative this is what I use which may help you: Create a label on your form...

Try this in the Mouse_Move event Me.yourControlName.ControlTipText = Me.yourControlName.Value

I thought you might have a problem as the db was devloped in 2000 and I had to convert back to 97 format for you. So it may have lost some of it's functionality :rolleyes:

Hi Chewy Well I have had a quick look and first impressions are the screen is well laid out. Nice one and I like the fast scroll feature. Did you get my e-mail? Rob

Hi Chewy I wouldn't mind having a look too please :D Also interested in seeing other people's designs Rob rdunstan@seacore.co.uk

Try this Private Sub CmdHide_Click() Me.TrialCadetAdd.Form.Visible = False End Sub

Hi Just a few things you may want to try:- 1. Compact and repair the back end tables 2. Just check to see all your table relationships are still in place. I had a problem a few months ago where suddenly the database operated extremely slow. It was by chance that I noticed one of the...