Search results

Really don't want to double post, but I'm finding this is more of a query issue than anything. I'm trying to export a filtered query to xml. I'm experimenting with filtering only one field: WHERE ((([PART OUT - SET ITEMS].SETPURCHASEIDLK)=5)); Exporting to XML works just fine. But if I try...

I have a form with a subform that has related data from a query in it. I'm trying to create a button that will export only the related data into an XML file. I've only been able to export the entire query (along with all the unrelated data). My knowledge of VBA is mediocre at best, so I know...

I'm trying to figure out if its possible to import a text file thats space delimited in to access. See the example text file below. I can import it via space delimited, but the titles of the movies that have spaces gets parsed up too. Is there a way to just parse the first few spaces and then...

I'm somewhat green on this kind of stuff. What I have is a catalog of film titles. Each one of those titles have multiple distribution agreements. Each one of those agreements have different territories. So I have three tables: Titles, Contracts, and Territories, each one has their own ID# and...

Any idea how to calculate this? [RegDate] plus 28 years. Right now I can do that with this: DateAdd("yyyy",28,[RegDate]) This gives me : [ExpDate] = 2/15/1950 + 28 years = 2/15/1978 I'm trying to get the date to round to the end of that calendar year (12/31/1978) Ex. [ExpDate] =...

Pass ID from one form to the next for data entry? I feel like this is a simple answer, but I'm rather a newbie at all this and I am having a difficult time trying to search for the answer. I want to link multiple forms together using the same record. I have a series of questions that have...