Search results

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

Thank you very much pbaldy! That was EXACTLY what I was looking for. Just adapted the code to suit my database, but it worked!

The issue is that I have multiple values (release name) that a user needs to select which ones apply to their project. If they apply to their project, then the value (release name) needs to be copied to a new unique record created in another table. Each of these value creates a new record, so I...

Looking for coding help (and perhaps an example) that would help solve the following. Any help is greatly appreciated. The user will be creating a new project that contains a bunch of releases. The releases have standard names which are stored in a table tbl_ReleaseNames It should be noted that...

For those interested, I resolved the issue finally, had a slight error in one of the macros I converted to VBA. It appears that the solution was removing every single macro in the database and converting them into VBA.

For those interested, I have converted all macros into VBA, rebuilt the database by importing all elements, and still no luck :( We are all using the same version of Windows 7 and Office 2007 as well. Any further suggestions would be greatly appreciated...