Recent content by rc-alex

FYI if it helps you with testing/designing the web database, as long as you run the "compatibility checker" on the file tab and it says it is compatible with Access Services, then you should be able to navigate around the database in Access just as you would in SharePoint 2010. So you can go...

Craig, I'm looking at CRM options for SharePoint and (unforunately) probably need to make a decision by tomorrow what route to take. How is the web database working out for you. Have you been able to set up parent and child accounts? Contacts tied to each? If you tie a CFO to the parent...

Craig, TeamMembers is the table with employee info where current salary is stored. This would be much simpler if a you could use the "Totals" line in web queries as you could simpyl find the LAST value for the given employee. SalaryChange is the table where each salary change is recorded...

Craig, Do you mean to post the new value the user just input in one table via a form, to a second table which the form does not post to? Please confirm that I understand you and I'll go dig it up. I've been on other projects the last few weeks so I didn't get it to replace the value with...

Anyone know what might be causing this, or how to advance to the next record? I don't know why it would do this. Apparently it thinks the form isn't "open" because it's being displayed on the main navigation form. Any thoughts? Thanks!

One other thing about the same set of combo boxes and command that I haven't been able to figure out but feel silly for having to ask. I have the combo boxes showing the ID's (number) so that the command will work. But I can't figure out how (except for the wizard) to set the combo boxes to...

THANKS to you both! Since the three ID's are related (yielding the report), I think requerying each of the other two boxes based on whatever one the user updates is the best way to ensure avoiding blank reports? (already tested - a blank report comes out if no record exists) Although...

Thanks. What I'm asking is, what do I do with Jeanette's code? I assume I totally remove the open event from the form? (getting rid of openArgs). Where do I place her code? Sorry, where events are new to me. Thank you.

I changed the format event but it didn't work. Sorry you lost me when we switched gears to the where clause. Make that the only code on the cmd button to open the report? No open event on the report?

The are in the report's recordset. They are comboboxes visible, but will be invisible. They are in the report header. The report still loads, but as I scroll through the pages, the three values change accordingly. I should only be able to see the one page of results corresponding to the OpenArg.

No, for some reason the fields in the report are still blank :( Private Sub cmdProviderReportCard_Click() DoCmd.OpenReport "rptProviderReportCard", acViewPreview, , , acDialog, 6 & "|" & 8 & "|" & 12 End Sub Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)...

Thanks. That lets it open the report now without trouble. However, it doesn't seem like the openArgs are being passed. When I view the report, the first ID is always the same no matter what I set the combo boxes and the other two are always empty. And it lets me scroll through the report for...

That does make sense, I think, but I'm not sure what to put in for the string. Wouldn't the string that is constructed be different for every combination of OpenArgs that are sent by the origin form? Don't I need to use a variable of sorts? Thanks

Mark, Thanks a lot! But what would you put in Me.OpenArgs? Would that not be varSplitString = Split(strPRC, "|")

Sending: DoCmd.OpenReport "rptResults", acViewPreview, , , acDialog, strPRC = "Me.cbo1ID|Me.cbo2ID|Me.cbo3ID" Open event: Private Sub Report_Open(Cancel As Integer) varSplitString = Split([strPRC], "|") Me.[EngagementID].Value = varSplitString(0) Me.[LocationID].Value =...