Search results

Ok thanks again, however I still need to know how to refer to the specific records (and therefore comboboxes) represented in the detail section of the form. My looping idea is currently through SQL, similar to the form recordsource, updating the selected field of all subrecords in THIS form...

Thanks for the tip Pat but I do want to update the records. If probably won't be all of the records needing changing, but possibly 5 out of 7. The difference comes about because the supplier whose statements I parse for this has a slightly different classification system than I want to use.

If I can't do this through an update query, how do I reference the detail sections of the form so that I can loop through them? eg: for each ........(something to reference a detail record) if cboSelected.Value = "True" lstType.SelectedValue = lstSelectedValue.Value endif next

Thanks again, the classifications will be valid but incorrect. The user will select the new classification from a dropdown box on the main form (list of payments being in a subform), then click the 'change classification' button. So in summary, I should have this as a button calling code along...

Thanks for the replies. Yeah I have a drop down on each record, but this functionality is for changing say 15 at a time. What is the VBA to reference and loop through detail sections on a form?

Hi everyone, I'm having a problem with a subform I have which shows payments for a particular supplier. These are automatically imported from the supplier, and sometimes (about 10%) they have the wrong classification (the field paymentType in my Payment table). Is there a way I can have a...

Yep cheers man I didn't find a calendar control (had been using date pickers anyway) but there was a long while where it was still throwing the "missing reference" error. I've deleted the missing reference on my 2007 version, in the hopes that this will work with 2010.

Bob, is there any cheater way to find a calendar control? I can't see one in my db, and I've set all text boxes to datepicker, but on export to 2010, this missing reference error still comes up. Is there a way to see where the reference is called from?

Has anyone got TOP syntax working in a DELETE query? I am trying to delete all records with the most recent date. The syntax works with SELECT eg SELECT TOP 1 Payments.DateOfPayment, Payments.* FROM Payments ORDER BY Payments.DateOfPayment; But doesn't port to DELETE. Clues?

I've found the error handler wasn't working because I had the wrong setting in tools > options > General > Error Trapping

This is what I am trying to do. The error comes when copying my template across to the output folder. Is workbooks.add better than workbooks.open? Why wouldn't my error handler be working? I have an On Error statement at the top, but the code breaks at the call to filecopy, showing the standard...

In VBA, I am exporting to a template. My checking goes to the extent of checking if a file exists, and getting permission to overwrite: If Dir(sOutput) <> "" Then ' If output file already exists varConfirmOverwrite = MsgBox("The output file name already exists, would you like to overwrite...

Ah I see. If I was tackling this, and the text doesn't have to be changed, I would create seperate labels for each of the bold words, and place them over the non-bold text. Will that work? Otherwise I don't know of a way

Are there any templates? My database is a collection of various payments, and I would like to create a good summary report of them all, much like a profit/loss statement. I'm messing around with a report, creating basically the whole thing in the report header, since no detail is required and...

Yes. Each control has their own formatting. With the control selected, you can modify this as with word/excel etc

I know I'm bringing this back from the dead, but I still haven't found a good solution to this problem. The user will want to enter amounts/details into textboxes, then have the amounts added to the calculated total. These added amounts/details have nothing to do with the records being reported...

I found that creating a new subform through the wizard, and linking the masterfield to the control helped, as per http://www.fmsinc.com/microsoftaccess/forms/subform/master-link-fields.asp and...

I am having the same problem. I modified my master query to have no .* field reference, but now my subform won't requery. Instead it prompts for the LinkMasterField, as if it doesn't exist

Sorry to bring this back from the dead, but how did you solve this problem? I have a similar problem with creating a new record via subform. It appears I need to pass a primary ID from the main form, to the new record.

Hi all, my current problem is that I have a many-to-many relationship which returns odd numbers of duplicates when queried. Each payment has a unique payment ID, but there are duplicates of this payment ID. I could just get the top 1 payment ID, but that seems like a patch rather than a fix...