Search results for query: *

That is exactly what the problem was, sorry I thought I had responded already. Brings back memories of FORTRAN and DO Loops!

I'm sorry, I mispoke. The front end is on the central computer in our lab in accde format and the backend on the server. I did create a shortcut and place it on the server, would that be an issue? Probably. Thanks for your help, the code behind the filter list box is fantastic. I am certain...

I'm using Access 2007. I created a split database and protected the front end as an accde file. I have a document search form that queries a listbox (looks like it was created by MAjP: Filter Sort List Box) of documents to choose from. It worked great before I split it, converted the front end...

Thank you seaport!

I've attached my database in Access 2007. I am getting a MsgBox Popup with the docID (my primary key for my main table) in quotes. I can't figure out what I wrote in the code to cause this or if it is something more major than I can see (I'm very new to VBA). Does anyone know why this is...

It does, but I had to set the Allow Additions to Yes and put a line of code in the Before Insert to keep new records from being added, otherwise when it returns no records, it freezes the detail section empty. I also did a workaround for the #Error property by recoding the control source for...

I used MS Access 2007 to create a continuous form with the Allow Additions Property set to Yes. The user selects from a combo box and uses the After Update Properties of it and a "Find As U Type" text box, to filter the form. However, after an entry in the text box returns no records, I don't...

Wow. I just went over the previous thread. The work flows look like a great idea. I went ahead and changed the work flow table to incorporate the dates and employee info. From what I understood, I modified the Work Flow Titles table to handle each step: manager signature, QAQC signature...

Duane, I looked into your suggestion, however the main form is already sorting the subform for docID (tblDocInfo PK relationship one to many with tblDocWorkFlow dwfDocID fk). I am posting the tblDocumentInfo below. In addition to filtering for docID on the main form, I need to filter (2)...

Majp: I just noticed your initials in the FilterSortListBox module. So I think that confirms this is the same project...

I took over this project for a previous colleague, not sure if she was Colebean. Nicole? I saw this forum in her notes. I think I'm pretty close to finishing this up. Kind of hard coming in the middle of a design!!

Thank you Duane. I will try it out and post the results. Looks like this will solve both of my questions! Thanks again.

I tried Me.cboEval.Form.Filter = "dwfTitleNo=1" Me.cboEval.Form.FilterOn = True In the AfterUpdate for the combo box Name cboEval Me.cboSig.Form.Filter = "dwfTitleNo=2" Me.cboSig.Form.FilterOn = True In the AfterUpdate for the combo box Name cboSig My form is set up like this: Form...

I had received some advice as follows: "From your mainform, you can set a Filter on a Subform like this: Me.NameOfYourSubformCONTROL.Form.Filter = " dwfTitleNo=1" Me.NameOfYourSubformCONTROL.Form.FilterOn = True Note the NameOfYourSubformCONTROL; this may or may not be the same as the form...

I am trying to get (2) pages of the tab control to filter subforms based on a combo box entry. I can't get the Filter property to work or an embedded macro run a query. The combo box is from tblWorkFlowTitles and stores the value as dwfTitleNo dwfTitleNo tblWorkFlowTitles 1=Draft Evaluations...