Recent content by tikkat3

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...