Search results

Something like this in the main form's current event... Private Sub Form_Current() With Me.MySubForm.Form If .Recordset.RecordCount > 0 Then .AllowAdditions = False Else .AllowAdditions = True End If End With End Sub

Looks right to me. Did you try it? That's what I'd do. I have a folder at C:\Inetpub\wwwroot\TESTASP\ that has a bazillion tiny ASP pages (aptly named) where I tried things I didn't fully know about until I eventually got them figured out.

I should have read that a little closer. I hope what Neileg added has enabled you to get it working.

If it's an autonumber field, you don't want the single quotes.

If it's a string-type field (text, memo...), you need to wrap the criteria in single quotes. So you'll need to work out some logic to build the appropriate query syntax.

DELETE * FROM MyTable WHERE Left(MyField,1) = 'S'

I totally misunderstood your problem at first... Your criteria is a string, right? Me.frmsubjobinfo.Form.RecordSource = "SELECT * FROM jobs_query WHERE " & strSearchType & " ' " & strSearch & " ' " (Spaces are inserted between quote marks for clarity...remove them.)

I have searched high and low for this: How can I get FileDialog to open with "My Computer" selected? When I tested to see what the InitialFileName property of the FileDialog is with My Computer selected, it comes out as "My Computer\"...but setting that as the InitialFileName property is...

1. Does G19 contain a full path and prefix? ("C:\Folder\SubFolder\[FileNamePrefix]") 2. Try commenting out the 'ActiveWorkbook.SaveAs.... line and put in MsgBox Lst ...make sure it comes out as a fully qualified path and filename.

Perhaps AppActivate("Name_Of_App_As_It_Appears_In_TaskBar")

Don't forget that in the control you are selecting, you need an AfterUpdate event to requery the latter control(s). Private Sub MyCombo_AfterUpdate() Me.lstMyListBox.Requery End Sub

Private Sub Command1_Click() DoCmd.OpenQuery "NameOfQuery1" DoCmd.OpenQuery "NameOfQuery2" DoCmd.OpenQuery "NameOfQuery3" End Sub

I have never used it, but I watched the demo... It probably would be overkill, but some features seam like they'd really hit the spot...like the project management portion. I think we have a guy at work that's used Visio...I'll see what he thought of it. Thanks for all the inputs.

Try this: There are many ways to do this (in code). I don't think you can do it with a query, because you have to evaluate each of the six tkt #'s against 8 columns from the Draw table. I attached a rough sample...

I downloaded that...I like it, but our needs would include summary reporting of all projects' status. We also have distributed offices that need access to the info. Thanks for the link...I routinely look around in CodeProject, but never saw this one.

This was my first thought when I arrived at my job just over a year ago. Although I had never used Project, I knew what it was for. I brought it up and was quickly quieted with "We used that before, and everyone hated it!" If anyone out there is using a modern version of MS Project and...

Thanks alot for that, Rak. I found "TheBrain" to be very intriguing. I don't think it's exactly what we're looking for, though...I'll have to look into it a bit further. What we need is a checklist-driven process tool to manage a project from start to finish. It would automatically load...

The controls wizard for combobox will do this for you...turn on the wizard and put the combo on the form. At the last page of the wizard, click on "store the value in this field" (or something like that.)

To pull the 1 or 2 digit month from the left: Left(MyDate, Len(MyDate)-4) To pull the 2 digit day from the middle: Mid(MyDate, Len(MyDate)-3, 2) And of course: Right(MyDate,2)

Thanks for the suggestions. I should clarify, though... I was looking for thoughts on using a reference table to guide a process through the wickets. I suppose I'm over-complicating the idea in my head...I just thought someone might have a novel idea how to structure such a thing. We are...