Recent content by ExoDus84

The field types for both the source and destination files are equivalent in terms of data types. I don't have keys on them at the moment. Naimlam's example above is kind of what I'm looking for, although I need to match up a field from both tables and pull in locations that match that equal...

Thank you, Namliam. I'll give this a try and see what happens.

Hey everyone, I still haven't found a valid solution to this. I tried using a sql update query, but it doesn't work, since the join is not a direct one to one. I may have 1000 open locations with profile name A, but what if I need to update only 50 part numbers with unique locations? I'm...

Can you be a little more specific? I'm not that familiar with VBA quite yet. I'm not sure where I would begin with this.

Unmatched queries are simple if your table structure is sound. The problem is your data is not structured very well. You'd want to have an identical field name / data type for both tables. Such as Employee ID in table 1 is equivalent to employee ID in table 2. You need something to be able to...

Hey guys and gals, I've got an issue that perhaps some of you can point me in the right direction for. I'm looking for a way to grab values from one table that match a criteria, and append them/update them to another, but only grab one value once. Example: Part ID ---- Profile...

Thanks for your response, lagbolt. What I'm basically trying to do is run a macro until there are no null values in a certain column. I'm thinking the DCOUNT function should work as well. What I need my code to do is this: 1) Run mcr_Location_Update macro. It will append some values, but...

I've also tried doing this via VBA. I'm very new to VBA, keep in mind. This piece of code is kind of doing the same thing, but again, getting stuck and not exiting correctly. I put this on the click event of a command button. Me.txtCount.Requery Me.txtCount.SetFocus Do While...

Good Morning, everybody. I'm new to the site, and wanted to first introduce myself, and then ask for help on an issue that's been getting me stuck for a few days. I'm having an issue looping a macro, given a condition. I have a form, frmMain, with a table as a recordsource (tbl_PDC_Parts) with...