Search results

Hello All, I am trying this code in Access 2007 that you listed above: [ Public Sub CompactDatabase() 'Run this code before closing the Database. Dim vStatusBar As Variant On Error GoTo Err_CompactOnClose If FileLen(CurrentDb.Name) > 2000000 Then...

Hello, I found this thread while doing a search. It does not appear when you click on the link. I would like to view this. Can a Moderator or Administrator fix this? Thanks, Kurt

Thanks, So how do I correct this. I do believe this is trying to work in the Immediate Window. How do I change it to display the info in a table or what is the best way to rewrite this? Thanks, Kurt

Hello Everyone, I have been more involved with Excel VBA and I am getting back into Access vba. I have the following code: Private Sub Command2_Click() Call TableInfo DoCmd.OpenTable "DBdata", acViewNormal, acReadOnly End Sub Function TableInfo(strTableName As String) On Error...

:eek:Hello, Thanks for your reply and yes. It is a zoned architecture that I am dealing with that drives the need for the asp.net front end. I have also heard of a conversion utility called ConvertU2. Does anyone have any experience with it. It comes highly recommended. Apparently SSMA...

Hello All, I am converting some Access 2007 databases to SQL Server 2005. I understand that my forms will have to be recreated in ASP.net. I am evaluating some software to help with the conversion. I would like to see if anyone has used anything that they really liked and why. Another...

Hello, It worked I opened the View Immediate Window! Whew you are da man! Do you happen to have some script handy where I can export this to an Excel spreadsheet? Many thanks, Kurt :):):):):):):):):)

Hello Brent, Whew thanks for that great info! Yep that was a lot! I tried running this code: BTW I am using Access 2007 Public Sub ObjectCounts() Dim qry As DAO.QueryDef Dim cnt As DAO.Container 'Delete all TEMP queries ... For Each qry In CurrentDb.QueryDefs If...

Hello DocMan, I forgot to mention to you in the last email that we had a baby girl Stephanie Grace Monday night. She was two weeks early weighing in at 4 pounds 7 ounces and 17 inches long. This is my second batch. I have a 23 yeard old daughter who is graduating college in May to be a RN...

Hello DocMan, When I try this code I get an error message: Public Sub countTables() Dim table As Variant Dim tableCount As Integer tableCount = 0 'You can iterate thru the Forms collection to see which forms are open 'Or iterate thru the AllForms collection to count forms in the...

Hello, Thanks for your fast reply. I clicked on the link and it will not redirect me. Can you post the actual link instead so I can cut and paste it? Thanks, Kurt :)

Hello Everyone, I know it can be done and I have seen some code snippets before, but how can I use Access vba code to count all forms, tables, queries, reports, vba modules, objects to get a total count of each for an Access database? Any help is greatly appreciated. Thanks, Kurt :)

Thanks Hello Milo, Thanks that worked. Can you take a look at my new question? Again many thanks! Have a great day! Kurt

I am showing some more detail here: Tank ID Owner Description Component Name Cat_Type Volume 123 owner a component 1 TR 143.00 123 owner a component 1 TR 142.00 123 owner a component 1 TR 140.00 I want to only show one...

Showing one line item matching fields in same record Hello All, Hopefully this is a better description of what I am trying to do. I want to just show one count in the previous example per record and a sum on the volume. I don't want to keep listing the same product name over and over again...

I wanted to make this clear. I have a report that shows: Tank ID Owner Description Component Name Cat_Type Volume 1 owner a component 1 TR 143.00 1 owner a component 1...

Hello All, How can I get this to appear once and sum on a field? Let's say the field name is Owner_Desc and the field I want to sum on is Volume. What kind of formula would I need? Thanks for the help from yesterday's question. Thanks for reading! Have a great day! :) Kurt

Hello All, I am having problems with this syntax in Cyrstal 10 Formula editor: If {ORDER_MV.O_CAT_TYPE} in ('TS') and {ORDER_MV.OM_REPORT_GSV} >=1 Then {ORDER_MV.OM_REPORT_GSV}; I want it to display the results of {ORDER_MV.OM_REPORT_GSV} when the condition in the IF statement is met...