Search results

The user wants that after the data is being exported into the excel file, the file opens up automatically. I export data using this code: DoCmd.OutputTo acOutputTable, "Wbt_Orders", acFormatXLS, strDb & datExst & ".xls" Please suggest if I could open excel file from the code? Thanks

Well, the thing is it is not really a procedure, it is just a sub...so I wouldn't place it to the module.

Hi From form1's code, I open form2 assigning some of the fields values. DoCmd.OpenForm "Form2" Form_Form2.ModelID = Me.ModelID Form_Form2.PIN_SerialNumber = Me.PIN_SerialNumber Could I also call one of the Form2 procedures from within the form1's code? Thanks

Here is my problem: The table looks like that: Name Count Joe Polina Joe Nick Polina Nick Nick Joe 2 Polina 2 Nick 3 The last three lines represent the count of how many times each name appears in the table. So, what I need is UPDATE QUERY to...

Please if anybody has an example of the transaction using DAO, share it with me. I am copying two huge tables and want to be able to rollback the Delete or Insert statements in case something happens during the process of Inserting or Deleting. Please help Thanks

Hi Does anybode have an example of DAO transactions? Please help me out.

Hi I use functions Date() and Format in my application with Access 97 and everything works quite nicely But I just tried to run on another machine (laptop), and they both didnt' work What could be the problem What VB references may be missing? Please help me with this. THanks

I run this code to find out how many records there are in the table docmd.runsql ("select count (*) as intX from table1") but vba gives an error. How else would I get the number of the records in the table from the code?

How from code to get the number of records in the table?

I have this problem My form has a huge listbox that contains many records. By double clicking the appropriate row (record) on that listbox, user opens that record in another separate form. The form with the listbox statys open as well. So, user makes changes to that record, closes form, and...

Hi I have this routine that copies one big table into another. How would I control the process, so that in case something happens I could roll back the changes in the tables or do something else to make sure that all the data has been copied, etc. Please if anybody has that routine, could you...

Hi How to make that when my form opens, the default for the combo box would be the first value out of that combo box values? Thanks

Hi Is there a way to code somewhere on the form so it would automatically refresh every 60 seconds? Thanks

yeah, thanks but...how to prevent tab from going back again to the first field?

I have this problem. When I tab to move through all my fields, once I reach the last field and then I press tab again, the cursor gets back to the first field. The problem is by going back to the first field it erases the content of all fields. Can I prevent that? And is there way to prevent...

Hi Is it possible to first apply the filter to the report and then output the report to the excel file? With this code I just open the report applying the criteria: DoCmd.OpenReport "WbtReport", acViewPreview, , "[AssetStatus]='active'" Can I actually send that filtered report to excel not...

hi The standard report toolbar has 'Analyze with Excel/Word' button that sends the report to the Excel or Word. Can I control the location where the file is being sent? And one more question, on the report I have a check box, but when I send it to excel using that report button, that field...

Hi I am getting to the end of my Access application development (my first application ever) So what I am looking for is the advice on how to test the application, where to emphazise my testing, what not to overlook. Please help me with your professional tips. Thanks a lot

Hi i need to check if the value entered in the field is numeric, 5 digits and starts with 9 Please help Thanks

Hi I have a couple of procedures where I insert stuff from SQL table into my local Access 97 table. What I want to have is the error trapping so that if any errors occured while inserting the table, I want to stop inserting, delete the things that were inserted and start the inserting all over...