Search results

I'm having the same issue where it is returning the bottom 3 dates rather than the top. I tried changing the sort from ascending to descending as suggested, but no luck. Any thoughts? thanks, Mary

I'm trying to do the same thing. Can you share what worked? Thanks, Mary

Grzzlo, Thank you!! it did the trick!! Mary

Thanks so much! I'll give that a try! Mary

Here's the code to open the form: Private Sub Command73_Click() Dim stDocName As String Dim stlinkCriteria As String stDocName = "frmUpdate3" stlinkCriteria = "[IDProj]=" & Me![IDProj] DoCmd.OpenForm stDocName, acNormal, , stlinkCriteria The form that opens is a continuous form, with the...

Hi all! I can create a button that opens a new form with the related records from the first form, but I would also like to be able to add a new related record. I can add a record, but it is not picking up the ID. frmProjectIDProject has button that opens up second form where the IDProject is...

Ok, I want to click a button to add a new record as well as see the related records. I can make a button to add a new record or see the related records, but not both at the same time. I used stLinkCriteria to see the related records and doCmd, go to record, acNewRecord. Any suggestions...

Thanks, Bob. I hadn't thought of doing it that way. I was hoping to see the list of choices on the left, and have the id populate the subform on the right. The way you described is how I have it set up with project being the main form and task being a subform. I really appreciate your input...

Is there anything I can do to make my question more clear or can you point me in a direction for more research? Thanks, Mary

I wanted to clarify that the append query is working, but I want the append to be only for the checked records for that project. I checked that the joins seem to be correct for the junction table: tblTaskList idTask (PK) TaskDesc TaskYesNo tblTaskDetail idTaskDetail (PK) idTask (FK) idProject...

Here's what I'm trying to do: I have a table that contains a list of tasks. If the checkbox =yes, then I'd like to copy those id's to a junction table. I can get 1 record to copy, but not all. I was using a macro with Set Value. ( I also tried an append query, but it didn't work as expected...

Ok, I got it to work by loading a generic printer, text only. My original printer file must be corrupt. Here's the article that helped me solve it: http://support.microsoft.com/?id=224148 Hope this may help someone else! Thanks, Mary

If a brand new db has the same issue, could access itself be corrupt? Thanks, Mary

Thanks. I'll give it a try. I did try and create a test db with 1 table, 1 qry and 1 report, and I got the same results, so I'm hoping it's just because I'm not actively connected to a printer. Thanks, Mary

I'm working on a laptop that is not currently connected to a printer, although one is installed. I'm working on a new db and this morning I have tried to create a report both manually and using a wizard, and I get the "unable to create report" message box. I can open other reports from other...

I always think about what I'm trying to get out of the database to help with design. Good Luck! Mary

Thanks for the suggestion. I only have 200 at work :( I appreciate the suggestion! Mary

Here is my dilemma: I need to track if testing has been done on about 15,000 compounds. This needs to be done on a quarterly or annual basis depending on the item. Here is a simplified table structure (with longer field names for ease of understanding!) tblItem idItem annualOrQuarterlyTest...

I'm working on a db to track testing that needs to be done on a quarterly basis for about 15,000 line items. Ultimately, I'd like to run a query that would tell me which items where the testing is due or overdue. I was thinking of a junction table, called tbl Results set up as follows...

I am trying to figure out if I can do a search within a search on the forum. Thanks, Mary