Search results

Hi All, I've tried several tactics to see if I can check if the workbook in the code exists before running the actual code - I can't seem to get it right. Can anyone please help? Thank You! Rem OPEN WORKBOOK Dim XL As Excel.Application Dim xlwkbk As Excel.Workbook Set XL = New...

Bob - You Are The Man Good Sir!!! Your suggestions did the trick!! Thanks!!

Hi Bob - I suppose I am stuck with this issue then. I used it appropriately, but I still see Excel Running. Also, when I use it, for some reason, I can't return to Access from the VB editor - I have to force shut the DB and then reopen. . .

Hi All, I have a module in my Access Database that opens Excel and runs an Excel Macro. As it stands now, the user can see Excel opening / closing. I don't want the user to see this. In Excel there you can use appliction.screenupdating = false to prevent this type of thing. I can't...

Thanks guys - I'll try both ideas! It doesn't sound like access has anything specifically to deal with this . .

Hi All, I have a form which looks fine except the data and controls on the form take up about half the size of the screen - so when the user opens the form there is this wide, empty area on the right of the screen. Do I have any design options to remove this w/out making the form a...

Thanks Good Buddy :)

Bob - I know you are good friends with the top Microsoft Programmers - can you give them a call and have them figure this out :)

Thanks Bob! Did ".xlsb" work for you?

Well - If I change the extension to ".xlsb" then it works - I don't understand why though? I am happy it works! What is Binary intended for?

Fellas - thanks for the help. I send the DB to a co-worker who only has Excel 2007 and she received the same error when she tried to open the Excel file?

I have Excel 2007 on my computer though? If I change it to ".xls", when I open the file, it asks to convert? Do I need to remove 2003 from my computer?

Hi All, I can't understand why this is not working. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qryMyResults", "K:\SouthWest\Analysis DB\Weekly test\Book1.xlsx", True The code saves the file, but when I try to open it, I get an error message for an invalid format or...

Hi Brianwarnock - I am not in the office today but I will try it first thing on Monday - I left the project unfinished yesterday. So, just to be clear, I use the IFF statment for each field I wish to sum, IIF([High] = "YES",1,0), IIF([Med] = "YES",1,0) etc . . then use the sum rather...

Thank You Bob! I am going to spend some time taking that apart and learning from it. Thanks!

I Understand Bob - I sadly inherited the table. I created a form (for a work around) and placed the formula below as the control source - but that gives an error. Can you spot my error? =DCount([ID],"AssetQry",[HIGH]="YES")

Sorry Bob :) The assets are Fields. So I have, for Exmaple, in one field "High Risk Asset", the entry for that field would either be "YES" or "NO". The in antoher field I have "Low Risk Asset" with either a "YES" or "NO" then "Medium Risk" . .etc . . .it doesn't seem I can do this in a query...

Hi all, I have a query I am having a tough time resolving. I have a dozen IDs. Each ID is a client that owns 5 different types of Assets. Asset A, Asset B, Asset C . . .ect. I am trying to create a query that would count how many of each asset a client owns. A crosstab query didn't...

ChrisO - thank you very much for the guidance. I will be working on this now and I will try to adhere to all your suggestions. Thank you for taking the time to explain the code also - I've been going through your explanations and they are very helpful!!

Hi ChrisO - that worked perfect - I just didn't know it could be that simple! THANK YOU!! I also used this to revert the form back to record 1 after the filter shows a blank record. Please let me know if this can be done better! Thanks! Me.Filter = MyString Me.FilterOn = True...