Search results

First of all, There are no rules with regard to organising tables in your relationship window. Just sort them out so you can see them as best as possible. But if there are so many that it becomes really difficult do ask yourself, Do I need them all? You shouldn't be breaking any of the rules of...

Second Bird: Set the Data entry property of the form to yes.

U shouldn't need any kind of query. The subforms should be showing the information from the tables just the same as the main form. I found a problem similar to this one time where someone had a subform which wasn't linked to the main form.....they were just like two separate forms. Is this the...

Is the Dataentry property of the form set to yes. If so change it to no.

Well, If you want to pull all records from certain fields in a Table all you have to do is put the fields you want in the query. Leave out what you don't want. You don't even need to set any criteria. Am I still not hearing exactly what you want?

Not sure did you change your original post Kita__N. But my suggestion should solve the problem even if it is a little long winded.

1) Create a Query to identify the amount of work orders for the day in question. If you will only ever want todays date enter =Date() in the criteria of the Date field. Other wise enter [Enter Date Here] in the criteria. 2) Create a second query based on the first one. In this query click the...

I think you're stuck here mate. I might be wrong cause I have to honestly say I have never used so many criteria in a single query but I don think you can have more than 255 criteria per query..........but that said maybe you can split it up into two or three queries. And a form is definately...

Not sure if just using the presence of a grade higher than 0 to be an indication that a class was taken. Can a child not get zero % in a class? Can they be absent from a test? If you think it is what you have is sufficient, all you need is a simple query. Set the criteria of the grade field...

I'm going to leave this one open to the floor. Cause, while I have done something very similar I don't remember exactly how to do it and I haven't time to go looking for the DB in question now. Maybe Tomorrow if I get a chance and Noone else has resolved your problem Shane :)

Or, create a form with just a combo box containing your values on it. In the criteria field of the query enter something like this: [forms]![myFormName]![MyComboBox] Put a command button on the form to run the query after the selection has been made in the combobox

If you have a report so you can tell any employee at any given time what reserve they have you have the answer there. That must have 2 queries behind it. One which takes all records relevent to the employee from table reserve, and a second which totals the values in the reserve field (i.e...

You want to total the amount in the Reserve Table? Is that the total on the reserve table or the total per employee on the reserve table?

That kind of depends on the type of security that is installed. I think there has been something mentioned here before abouting accessing a password protected DB......so do a seach. However if all that is wrong is that when you open the DB you access a switchboard or something similar just...

To be honest I don't think you can have a report like you want. That would involve having a variable amount of fields in it. Reports don't work like that.......they are like a DB Table.......you can't (technically you shouldn't) have records of different lengths. If anyone else knows how I'd...

I think the best you will be able to do is group the report by Activity. So you will have Report Title Activity 1 Name _____________________________________ User 1 User 2 User 3 Activity 2 Name _____________________________________ User 1 User 2 etc.

U got in before me Tess!

Simple enough, Build a form with a combo box or list box of the values you want to be able to enter. I presume your report is running of a query if you want to limit your results to certain values. So, in the criteria field of the query enter the following [forms]![my form]![my field]...

Hi all, What I want to do is have my access database send an e-mail to a particular address every time a (numeric) value in a certain field falls below a predefined level. This doesn't have to be instantaneous. I would imagine it would be necessary to write a query to return the records in...