Search results

Thanks, but I am not sure that this will work properly for me. There are a number of sub forms embedded into the main form and it is the data within these subforms, which needs to be influenced by a checkbox/starting point.

I have a form, which will use various sub forms and comboboxes. The database I am creating is to track non-conformances across the business. The combo dropdowns will be different depending upon the department selected (Engineering, Manufacture, Installations, Service). Is there a way so that if...

The video is useful, but still not getting the results. The Product box in the form will show the product code when taken from the drop down list (combo) I want the Type box to filter its choice in the list so that its results are relevant to the product code. In other words the types are...

I am having real problems with a cascading combo box, which I cannot get right. There is a subform in my main form which lists and records the products on each job. This subform shows in datasheet view. Each line records the product, size extras and type. It is the type that should be a...

I am trying to create a calculated field in my form. The calculation I am attempting to create is the cost of installation labour. In my table1 (the table where the calculation will occur) I have a date field, installation hours and the unbound calculated field. There is a separate table...

The crosstab query works. However, it will not display the data as I need it. I think it is probably a simple solution - but what?! The current results display as: Contract ProductA ProductB ProductC 1111 1 (Prod A column) 1111 5 (Prod B column) 1111 2 (Prod C Column) 2222 7 (Prod A column)...

Thanks. I will have a look at crosstab and see if it does what I need!

I am not sure if this best belongs in the Report or Query forum. I have been asked to create a report which details line by line (each line a contract number) the products sold in a given timeframe against that contract. Most of the report has been easy to set up, but I do not know how to do...

I have a form, which contains both sub forms and sub-subforms. Everything is working correctly - except for one annoying (and potentially dangerous) thing. When a new record is started, the data is logically entered into the main form first, and then each sub form thereafter. However, What I...

Thanks for your help on this yesterday. The subform in datasheet view was the solution and makes life so much simpler. Your suggestions all worked perfectly. My problem with the database itself was eventually tracked down to an incomplete piece of VBA which I thought had been discarded, but...

Thanks for responding Mailman. I sort of understand what you mean, but not fully. If I have a table with just Product and Quantity (along with Contract to link the record back to the main table), when it comes to data entry through a form, how am I able to enter and view more than one product...

I could use some advice on how best to structure a query. I have the following fields: Contract, Activity Date, Product1, Quantity1, Product2, Quantity2, Product3, Quantity3, Product4, Quantity4, Product5, Quantity5 At the data entry stage Products1-5 are entered from a combo box, which...

Found the problem! My own stupid fault in giving a field PK status when it is a field which will only get data later in the data entry process. The main form just needs to popluate it with core job data at this point!!! Thanks for the help.

Neileg, thanks for your quick response. Funny enough I have just this minute managed to come to the same result, when your post came in! An ongoing problem is the last one I mentioned. The third table will not update and I cannot see why. Through the subform I am getting the error message...

It has been a while since I last set up a new database and I am having trouble with a main aspect of the table design. My database is to keep a log of all projects within the company. The area I am having trouble with is how best to set out key data within the table(s). The following fields...

Still having grand total problems in my report footer! I have followed Microsoft's instructions under support.microsoft.com/?kbid=208835 At lease I am getting a result, rather than an error, but I do not understand the result. As the article explains, I am sending the sum results of the...

Attached is an edited version of the database. Some fields, which are not relevant to this report/query have been deleted. The union query I had been trying to get set up should consist of the RSub... queries. My aim at the end of the day is to get to the position of being able to create a...

To try to get over some of my previous problems, I have tried using a Union Query - I understand this might help me get the results I need. Below is my SQL, which is meant to combine the results of the 10 individual queries. Have I misunderstood something, or not done something right? I am...

The reason for needing the fix number as well as the visit number is due to the way in which the database was originally set up. The visits are recorded through a subform with the main project data being in the main form. For each stage (Fix) of a project a separate record is created - albeit...

I have attached 2 screenshots: The first shows one of the queries, which filters out the specific data needed. There are another 5 of these (2nd fix, 3rd fix etc). The constants across all the queries is the C/Q number and date. The [Fix] field varies according to the fix number. The second...