Search results

Hello, I have a letter (which is on our electronic letterhead) from a word document that I want to copy/paste (or other method) into an Access report and then lay my address/variable data fields on top of the letter/access report. All this works just fine as I've done this a few other times in...

Really good tutorial... http://devzone.zend.com/node/view/id/627 Install... You can install all these separately which can be a pain or do as I do and get an all in one install solution such as... http://sourceforge.net/project/showfiles.php?group_id=14045 This allows you to have all up and...

I figured it out. It all came down to how to use "Like" in an "IIF" statement. I was trying "IIF(UserID="R12345","R12345",Like "*") When I should have been using "Like IIF(......)" Never knew that! http://www.access-programmers.co.uk/forums/showthread.php?t=130047&highlight=iif+wildcard

Maybe making the question more simple will help :) In my query the UserID gets the criteria from the reference to the hidden form. In the event that there is "NOT" a match I would like the default to be to show "All" records. Currently the query only runs when there is a match. HTH.

Hello, I have a query (used in a combox) with a field called "UserID" and in the query I would like to have the UserID field get it's criteria from the "User" field on a hidden form. I have it for the most part however, I have two users (myself and another) that when we use the combo box we se...

Bummer! :( Thank you

The problem with that is I have a lot of work into the form right now and have to integrate an approval system for variouse sections of the form as the managers have to review and sign-off on it. But thank you

I have a form that has apparently reach the maximum section height of 22". I'm guessing I need to go 40-50" and would prefer to not use tabs as this form is already one of three tabs. This form is for managers to review filled out forms and not for data entry as I know doing it this way would...

Haven't attempted it yet as it is part of a bigger project and I have been working on some of the other parts. It goes pretty slow when you're learning while you're earning :) But, I when I get there I'll give an update. Thanks!

Maximum Form Height Reached I have a very long form which is not for data entry, it is for management to review only. I would really like to have it run continuously downward but I seemed to have reached the maximum height of 22". I would like to not have to use tabs as suggested in my...

That did the trick! Thank you very much.

Hello, I have main form and an associated subform. The subform only has one record per main form association. The problem is even though there is no second record in the subform it lets you advance to the second record which is blank (because it doesn't exist). Now I know you can not show the...

Resolved There were a few other things (as I found out) that were strange as well. So in Excel I went to the "Help" menu and found "Detect & Repair" which seemed to do the trick after running it and restarting my computer. Thanks for the help!

Hi Brian, Q1 - It's there Q2 - I am looking in the VBA Projects window and see it under senario #1, but do not see it under senario #2.

When I open excel from the Windows menu I see that the Personal.xls is there like it should be. But if I save a workbook or open one from double clicking it's excel icon the Personal.xls is not there. I am stumped?

I work for one of the largest companies in the world and so I think you can be rest assured that as far as the equipment goes...definately suspect. Thank you again I'll attempt to modify as you advised and let you know. Thanks!

Hi Brian, Thanks for the hints, I will give it a go. I understand pretty much what your saying I think. But, in troubleshooting it, I had just used the first part of the code and was having the same issue. First part usded... For Each LCell In Cells.SpecialCells(xlConstants, xlTextValues)...

I have acquired this macro and on a small (>1000 rows?) scale works great. However, I have 43,000 rows X 10 columns or so and that's where things get ugly, I have not been patient enough to see how long it would take. I am new to VBA, but went through the basics to check if it had calculating...

I could see where one might think that :) As I stated, this is in an effort to learn Excel VBA. But there are times when you want the best of both worlds (Excel/Access) and it is nice to know your tools.

Well Brian, very impressive indeed. This is exactly what I was looking for, and even more. I just have to pick it apart to see what makes it tick now. Thank you very much for the schooling