Recent content by briananderson

  1. B

    Export Query to XML via an input prompt?

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

    Export filtered query to XML

    I'm trying to sort this out right now too. OP, were you ever able to solve your problem? Would love to know how, thanks!
  3. B

    Export Query XML Button - Filter related data?

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

    Import Space Delimited, but only certain spaces?

    Sounds promising. I'm not as versed in MS Access as I'd like to be. How would I implement this?
  5. B

    Import Space Delimited, but only certain spaces?

    Drat! Thats what I was thinking. So right now, I've done a fixed width import, and am trimming all the remaining fields that didn't import correctly. Thanks for the help, anyway!
  6. B

    Import Space Delimited, but only certain spaces?

    This list comes from a pdf report document that I've converted to a text file. This report came from a database that I do not have access to. I'm trying to find the easiest route to get this data into a database of my own. Its about 300 pages.
  7. B

    Import Space Delimited, but only certain spaces?

    Unfortunately, I have tried Tab as a delimiter. Its definitely space delimited.
  8. B

    Import Space Delimited, but only certain spaces?

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

    Sub Subform displaying associated items..?

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

    Calculate Date & Round to the end of the calendar year?

    Thanks! I looked it up and used this: [firsttermexpdate]=DateSerial(Year([RegDate])+28,12,31) Works great! Thanks
  11. B

    Calculate Date & Round to the end of the calendar year?

    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] =...
  12. B

    Pass ID from one table to the next for data entry?

    I just added Me.Refresh to the button code, and it works great now. Thanks!
  13. B

    Pass ID from one table to the next for data entry?

    I'll have to take a deeper look into this, because its not working correctly for me. I'll see what I can figure out. I'll let you know. Thanks for the help!
  14. B

    Pass ID from one table to the next for data entry?

    Thank you to all who helped me on this! I took a little bit of both to make it work. The next problem I'm having is when I start a new record in FORM A, which creates a new RecordID, but I need it to save all the information inputed in the form, close it, and then open FORM B with the newly...
  15. B

    Pass ID from one table to the next for data entry?

    Thanks for the help! I'll try this out shortly. Actually, I am trying to open it in a new record in the second form. What is the minor modification?
See more
Back
Top Bottom