Search results

I need to pivot a table in which the values are text (i.e. they cannot be aggregated in any way). Is there any way of accomplishing this? The crosstab in Access and the pivot table in Excel both require your value to be aggregated in some way. Any suggestions would be greatly appreciated.

I have created a report in paragraph form that has text fields (with info pulled from a table) inter dispersed among the label fields that are the bulk of each paragraph. I know you can apply a can grow/can shrink property for the text boxes to accommodate different character lengths of data...

Thank you very much, that worked great. Now I am getting the same error referring to the second DLookup statement. I incorporated your previous suggestion and changed it to: Struserlevel = DLookup("strlevel", "UserNameAndPassword", "[InTblUserName]='" & Me.UserName.Value & "'") but the error...

I have been trying to piece together VBA code from this forum and the book I have to create a Login Form that opens a form depending on what UserName and Password you enter. Thanks to all the great info. on this forum I think I have come close. Unfortunately as an inexperienced user I cannot...

Thank you for your reply. I gave this a try but I still can't make it work. How does this statement look up the password and organization associated with each user? I have no experience working with user names and passwords and I apologize for the need for a step by step explanation.

I have searched the forum and found posts that almost answer my question but as an inexperienced user I need a bit more direction. I have a table called UserNameandPassword which lists the UserName, Password, and Organization for all users of my application. There are multiple Users (i.e...

Same issue on my machine I am having the same problem and cannot find a way to fix it! I am having to work on a different computer. I tried installing all add ins and reinstalling the office graphing program and nothing helped. If anyone has suggestions they would be greatly appreciated.

Thank you so much. This worked great and was so easy. Thanks again.

I have a simple table called Condition that includes a check box column that changes the value from -1 when checked to 0 when unchecked. I have a subform that feeds off and updates this table and includes all information available in the Condition table. I am now creating a form (that...