Search results

Did you check out the microsoft link at the bottom?

Hi Paul, you beat me to it... :) if you are using brackets as the paramenter in the query definition itself [Enter value here ] , how do you "save" that value? Larry

I know this isn't the "best" way but I'm not familiar with VBA enough to guide you in that direction. What I would I do is set the parameter as a "form" text box instead of having the parameter pop up through the query. you can still run the query the same but instead of [?] you would have a...

See if this will help... http://www.access-programmers.co.uk/forums/showthread.php?t=190908&highlight=Add+image+form

Try this... On the afterupdate event of the check box try this Private Sub Check16_AfterUpdate() If Me.Check16 = True Then 'Purple Me.txtSubject.BackColor = 9116245 End If If Me.Check16 = False Then ' Yellow Me.txtSubject.BackColor = 65535 End If End Sub Here's a...

I have multiple users for different area hospitals that "could" be having and AAR at the same. Since the tables are in the back-end they will be using the same questions, so I don't think I can "flag" them because then others wouldn't be able to use them at the same time. I wrote this...but...

Wouldn't the QID in the Answer table be that flag? Along with the AARID? When they choose a question, it automatically places that QID and AARID in the Answer table.

Hi! I have an easy one for you...because I have a brain fark! I want to have my combox "remove" a question after it has been selected and the user moves to the next question. I feel it would need to be based on two criterias. AARID is Null AND QID is null. The two table I have are...

Thanks Brian!! Worked great! I'm going to try to modify it it a bit on other project to look through "All" the forms. That may be another thread. Larry Thank you again!

Great Thanks Brian! I'll give it a go tonight when she gets home. Larry

I have looked up what I'm trying to use but keep coming across the use of "autofilter". I'm sure that isn't the way I want to go. I'm better in Access but this is something for my wife. :) What I want it to do is this: For Each Row in Sheet 3 IF Sheet3!CellD (Number as text) =...

Good afternoon, I have a spreadsheet where I need to do the following and I don't think it can be done with formula in a cell. If Values of Column D in RABU Sheet equal Column D in Adjustment Sheet Then Copy Row on Adjustment Sheet to "All for Table" sheet. If Sheet!("RABU & UB")D: D =...

Check your "Where" critieria... is the Me!cboFilter a text or number?

Paul...your code is the best! :) is there a way to have the query export to excel using the "IN()" where statement. I have no problems exporting the "entire" query to excel but I need the selected people to be able to export. The internal department needs excel to import into their DB.

hi everyone! Could you help me find where the syntax error? it's like needle in a haystack for me... Dim stDocName As String Dim varItem As Variant Dim strWhere As String For Each varItem In Me![lstEmployee].ItemsSelected strWhere = strWhere & "EmployeeID = '" _ &...

Bob...you just made a 10000 watt light bulb come on!! THANK YOU!!! The whole point for me to do unbound forms was to be able to get everyone on at the same time....After reading my and your threads again and again (in case i missed something)...I have put front ends on serveral PC's and in...

Both are correct... now on to the task at hand... :) I'll let you know how it's working. Thanks Bob! Larry

Okay, I'll check that out and see what I can do with it. I thought that if you have 'Bound' form to a table, that when the form is open, it locks the table so no one else can open it.

Hi Bob, It's still not playing nice... :( I am uploading a demo db so that you can see what it's doing. Open the DeathRecordReview DB Open the only form in there. :) I put a couple of labels explaining what I want it to do. Is there a better to go about this? Larry

Actually it is the same database tables. Some tables are linked to SQL server (pull and review data), others I created to collect the data needed. What I want to do is create an unbound form that every one can use at the same time, They'll need to select their hospitals and a date range by...