Recent content by duthiedon

Mmmm, I used the MsgBox Me.OpenArgs on both forms and they are not the same value.... mmmmmm

Both strFilePathFrom and strFilePathTo were defined as strings. The code works just fine until I add the line of code: Me!AssociatedFeedback = Me.OpenArgs I've experimented further but no luck. The code in the other form that opens this form where the args is located is as follows: Private...

Thanks vbaInet, it doesn't like the following line of code in the cmdSave function: FileCopy strFilePathFrom, strFilePathTo The funny thing is, that it works when I don't use the "Me!AssociatedFeedback = Me.OpenArgs" in the code. Not sure the connection... Any help is greatly appreciated!!

Hi vbaInet, that's because I don't know where the error is occurring. Just get the dialog box when the user executes the cmdSave function.

Need some help badly! Have been struggling with trying to resolve this issue for awhile with various solutions. The code is a mix of someone else's and mine. Essentially the form is like a document library, based on the parameters in the form, it takes the original document that is selected by...

Excellent! It works :) Thank you very much spikepl!!

Thanks spikepl, that's what I had tried earlier, and just did a copy and paste in case i made an error, and it only wants to update the 9 records that already have a value set.

Thanks plog, I ran the query and I get a message saying "An update or delete query cannot contain a multi-valued field" Spikepl, I need to update them all, the 9 already have the value set, so it doesn't matter whether I update the remainder of the 9 or all of them, it will have the same outcome.

Interesting, first it's generated by MS Access using their standard interface and I just showed the SQL from it, and it's also in the same format that MS Help has. Here's all my fields in my table: ID-Vendor > (Index and autonumber) Vendor > text field Created > date field BusinessAddress >...

Hello! Have been struggling trying to find an answer on why an update query isn't working when trying to update an multivalued field. In this table, there are 647 records and only 9 of which already have a value set in the "AssociatedProject" field. More than one AssociatedProject is associated...

Thank you very much, you triggered an idea so I filtered on the creation date of the record. Guess sometimes a second set of eyes does help :) For future use, the original code now looks like: Private Sub Command17_Click() Dim strSQL As String Dim db As DAO.Database Dim...

That would work I think, I'm not an expert coder, do you have an example I could follow?

Have a form that contains fields AssociatedProject, AssociatedRelease and then the user hits a button to create a new record and a new form opens to display this newly created record which sets the fields and also sets a field called Type. There is no issue with setting the field values and the...

Thanks pbaldy, I think I need new glasses :) I'm using the code to check before closing the form, and I ran into another problem where the DuplicateNumber was not null because the record itself shows up in the Dlookup, so I included another filter to filter out the acceptable record. Here's my...

Solved: Checking for a filtered duplicate value on a form before closing Below is some code that I'm struggling with and I get an error message "Type Mismatch". Have tried several different ways but had other issues, so I'm posting to see if anyone can help. Perhaps I'm missing something or...