Search results

Thanks for the input, but I cannot see an error with the Referential Integrity - there are no orphaned records - but I am using the Referential Integrity to force the creation of the new record on the subset and it is this which seems to be failing. If I were to post the database might you have...

Hi. I have a question prompted by database behaviour that I do not understand. I have two tables with related records, one being a subset of the other. I have joined the tables in a query with a Left outer join relationship. I have put the query results in a form, and when a User clicks a...

Thanks - so now I have found that query reults are uneditable when: "Query based on three or more tables in which there is a many-to-one-to-many relationship" but a workaround is to set the form's RecordsetType property to Dynaset (Inconsistent Updates). Matt

This is a very general question, but a problem that I hit repeatedly in my low level database work - I am not trained in databases at all, but have to use them to get on. I find that when basing forms on select queries that are stacked on each other - (ie one query shows the results of two...

Sorry I am not being clear. What you describe is what I have done. But the value list does not "drop down" when clicked, it simply displays one line. This is why I was looking for a variable to change the number of displayed rows (List Rows).Screenshot better showing design attached.

Hello Bob. By "Value List" I mean where I have typed a list of possible values separated by ";" into the Row Source of the table or form. These values are generally static and rarely need changing or enlarging. When I use a Combobox, I generally set Row Source either directly to a table or a...

Hi. Within a form I have created a number of Combo boxes, and Value lists. I wanted to stick to value lists where possible to minimise the number of extra tables I had to create. However, I cannot make a "Value List" drop down in the same way that a Combo box will - it stays as one line with...

Got it now Ray, Ive got it now thanks. The second combo wasnt always updating so I put in a requery clause for the second combo on enter, so that it was always refreshed from the first combo (if that makes sense?). Thanks very much Matt BTW I tend to always put in "ID" autonumber columns...

Thanks Ray. Cascades work well when unbound. How do I then bind these to a table so I can use them for Data entry? If I bind the form to the T_Pot_Spec_PR table, and then give control sources to the Combo boxes, Ware works correctly, but Fabric is blank. Thanks again Matt

Thanks. Ive stripped out all but what is relevant. I want to enter data for sherds of pottery. The pottery is assigned to a "Ware", and then to a "Fabric". So in the form F_Fabrics_test I want the first combo to show distinct wares from T_Wares and the second to show the possible fabrics from...

Hello. I am a low level user who doesnt go looking for problems with simple relational databases, but I have a problem now! I cannot get two synchronised boxes to work properly. I have used various methods that I have found on the MS site - eg...

Problem solved. My error seems to have resolved itself....I had an after update running on the whole form in addition to particular fields, and this is what was causing the confusion. Following removal, a compact and repair, and a reboot, things are behaving as they should. However, I think...

Thankyou modest - here it is. I wrote the database, so any problems are fundamentally my own (although I got help on one of the now obsolete modules) On the "FCustDetails_Payments" Form are 2 subforms. On the bills subform if a new record is entered in bill, date is entered by a Macro and the...

Still no response to my problem..... If no one can help specifically, can anyone give a general pointer on this problem. Can I view the VBA code underlying a form if the Macros have not been converted to VBA, or do they not exist in viewable code until a conversion to Module has taken place...

no takers OK, so no takers on this so far.... Just so I know is this because a)my problem is badly phrased and it is not clear what I am asking b)there is a very simple workaround that I should know but being a novice I dont know it? c) This an access problem If anyone would care to see the...

I have two subforms on my main form. Both subforms are very similar and comprise two fields each. Both have an After Update event set on one field to enter the current date into the other field. In one form I can update a record, press F9 and everything is smooth - I can proceed to somewhere...