Search results

Thanks Got it! Took me a little while to figure out I had to change the context - I was using "=" before the subquery which didn't work, but changing this to "In" did it! Thanks namliam

All, Is it possible to filter parent records by child records (or subdata) without showing multiple instances of the parent data in the form/query? Cheers, Bobadopolis

Why not attach the requery to the OnClose event of the input form (provided the viewing form stays open): [Forms]![myForm].Requery You could use the combo box wizard for a simple method to navigate to a desired record in a form. An alternative to this is to filter the form's RecordSet using an...

Make sure in the Form's property sheet you set AllowAdditions to "Yes". The code will take care of it thereafter... What other problems are you having? Bobadopolis

You could put some code in the OnCurrent event of the form: Me.AllowAdditions = IIf(Me.RecordsetClone.RecordCount = 0, True, False) This turns AllowAdditons off if there are records, and on if there are none (hence your control won't disappear). Bobadopolis

I think something like: strWhere = "[skjema_16_gr1_ID] = " & Me!skjema_16_gr1_ID & " And [skjema_16_gr2_ID] = " & Me!skjema_16_gr2_ID Bobadopolis

OOh, and make sure your foreign keys are not unique indexes!

I'm not sure about MS date picker but it seems to me that when you're fitering by time you are actually filtering by date and time - hence, when you filter by just date you want a wildcard or something for the time part(?). As for automatically deleting records... you could run a delete query...

Well I didn't know that - you learn something new everyday (or lots of new things if you're a dummy like me!) :) vtrm - I have not used the 'Load' function before but at first sight it looks like it will not do what you want. I think you'll definitely be wanting to use the code we've...

You need to restructure your data... I envisage the same 3 tables but with the following structure: tblArtists - details of each artist (stored once for each) ArtistID (PK) FirstName LastName DateOfBirth etc... tblArt - details about the art work created by each artist ArtID (PK) ArtistID...

I didn't mention before that I'm using SharePoint as by BackEnd... I made a copy of the database FE and converted all the linked tables to local tables. The error I descibed above didn't happen! :confused: So I think I'll give up now since i don't think there's anyhing I can do about it! The...

Place: =Date() in the DefaultValue property for the control. Also, you may want to look up the 'Format' function in Help if you want to change the way the date is displayed. Bobadopolis

DoCmd.OpenForm "MyFormName" To make it invisible include this line afterwards: [Forms]![MyFormName].Visible = False You can make it visible again by changing this to true To refer to controls you can use something like: [Forms]![MyFormName]![MyControlName].Property for a property or simply...

I don't think a requery will help here. I tried this in the OnCurrent event of the form and it simply removed the #Deleted record from the RecordSet! Grr... :mad: In the mean time I've simply removed the ability in the form to navigate backwards to already entered records - not ideal but...

Hi, I have a data entry form/subform with an embedded graph allowing users to preview the data they input. When I navigate to a new record in this form the the fields in the form and subform echo "#Deleted". Yet the data is still there, it is just not shown in this form. I have tried copying...

Hi, Firstly, no attachment. Secondly, you should not be storing calculated data in a table! You need to make a query that has these calculations in then bind your form or report to this. So... in the query you want to add your fields several times, making sure you rename each to the...

In the POSC field's criteria type: <>[DUTY] Or the other way round... Bobadopolis

Bump......

In the field's criteria cell in the query design view just type: [Forms]![myFormName]![myControlName] Bobadopolis

You make a good point Brian! And actually, if your using the text box to make calculations wouldn't you have to return a zero in the FalsePart? The character would have to be numeric for the calculation to work!(?)