Search results

Ok, figured it out, sorta. It was saving it, but not in the folder "readingfiletest." It was saving it in my documents and naming it "readingfiletest" and overwriting itself still (wasnt adding the last fourID after it.) I added a backaslash in the code after readingfiletest: DoCmd.OutputTo...

Private Sub Command13_Click() DoCmd.OutputTo acOutputReport, "rptFileValidator", acFormatRTF, "C:\Users\Brian\Documents\readingfiletest" & LastFourID & ".rtf" End Sub Not sure what I am doing. It acts like it is saving but I see nothing in the folder upon checking it. The LastFourID is the...

I m new to this and have scoured this forum with no avail. I have a report that a user can generate, showing all of the files he's read and the dates he read them, which works perfectly. I want to create a macro that will output to the report to an .rtf file, save the file, and then open the...

I am working on a military network which contains both the pureedge viewer and ApproveIt software. My database tracks various reading files that many users will access and read. I am trying to create a form which the user can go to and digitally sign a record document once he's read the file...

The best I can do is include that portion of my database, showing what I did. I had to do 3 seperate queries to get the results. Query 1 and Query 2 were created, and than the 3rd query was run from those. Query 2 had all the people and all the files. Query 1 had just the people and the files...

Yeah, have the query figured out and it works perfectly, thanks. I was making things more complicated then they really were.

Nevrmind. After 27 hours I think my brain just melted and it finally clicked. :confused::confused::confused::confused::confused::D

I think I am getting to the bottom of things, after much research and trial, with some recent corrections to my database. At this point I have two queries. In my current database, Query2 lists every name and reading file combination possible. Query1 lists only the reading files with the names of...

Thanks for your time. I'll try that out and report back.

Is there any way to somehow put that information into an actual form and subform, so the user can go to that form and scroll through his own unread files from a list in his form, based on his name? That way when he clicks on the hyperlink for his unread file, it will send him to the file, and...

Thanks, that works, but also need a list of the names that have not read the files, and the names of the unread reading files displayed next to those names. This is tough to describe in writing. I think it has to do with an SQL statement.

I'm still rather new to this. I am working on a database to track reading files. There are many names, and many reading files read by many, thus a many to many relationship. I have 3 tables: [Names], [FileRead], and [ReadingFile]. [Names] is a many to one with [FileRead] and [ReadingFile] is on...