Search results

i made the code as simple as possible. "not close the app if you are going to use it again, just close the workbook, is also useful" i might try this way. Thanks for your reply.

Hello! I tried this code as you suggested but it still gives me the error. Dim xls As Excel.Application Dim wkb As Excel.Workbook Set xls = New Excel.Application Set wkb = xls.Workbooks.Open("C:\Users\msreyes\Desktop\Finalpay.xls") xls.Visible = True...

Hi All, I have this code that opens and closes an excel file. But before to close i need to refresh an Ms Query in excel the user inputs the criteria and after that the file closes. However, when i try to open the file again via the code (command button in access) it gives me error --> runtime...

[SOLVED] Re: Variables Hi All, Thank you all for your suggestions. Solves my problem! You are all been very helpful. Anyhow i'm still at around 50% of my project so please expect me to post again. :)

A good suggest. Thank you.

Hello Guys!, I got it! You just have to use & rather than And and refer to button 1 as Case 1& Thank you for all your help!

Hello June and Gasman, Thank you for your reply. They are both working fine. However , there are instances that the user will not select 2 option buttons rather 1 option button only. Like There are about 10 combinations :( Private Sub cmbContractType_Change() Dim cmb As String cmb =...

Dim cmb As String Dim evaltype() As Variant Dim f1 As Integer Dim f2 As Integer cmb = cmbContractType.Text f1 = Me.Frame112.Value f2 = Me.Frame134.Value If cmb = "Medical" Then Select Case evaltype(f1, f2) Case evaltype(1, 1) DoCmd.OpenReport "Medical", acViewReport...

Hi Again DBGuy, From your suggestion i think i figure it out :) i will get back if i will encounter some problems :) Thank you!

Hi DBguy, Thank you :) Can you please just show me how to start on it? maybe a sample code?

Hi Guys, Can someone please help me figure out how to filter records from a table based from a selected item in a combo box and export the results to excel. I have started this code and im so lost. :confused: Thank you in advance. Regards, Corine Private Sub cmdSaveRecords_Click() Dim...

Hi, Ok here it goes. I have data coming from an external database. I populate the controls in a form using a query from that external database. We all know that it is read-only as i was only given rights for viewing the the database and extract the data i want. Now, the problem is, i...