Recent content by marina9

Ronphx, Try: INSERT INTO tblinvoice(field1, field2, field3) SELECT field1, field2, field3 FROM tbltemporary; Hope this helps!

To determine if an environment variable for windows workgroup is available to you, run this bit of code: dim i as integer for i = 1 to 100 debug.print environ(i) next You can see the list of environment variables for your OS by pressing Ctrl + G to show the Debug window. Hope this...

Sorry, I was thinking in SQL Server terms. Need more coffee...

Hi Pat! You may want to try this: SQL = "SELECT [T-LOOKUP-PAG].[PAG-ID], [T-LOOKUP-PAG].[PAG] " _ & "FROM [T-LOOKUP-PAG] " _ & "WHERE SUBSTRING([T-LOOKUP-PAG].[PAG], 11, 3) = CodeName); " Hope this helps!

Vanleurth, Sorry for the delayed response. I live in Florida so I was dealing with a hurricane this past weekend. What you may want to do is place the requery code in the btn_type_Click() section rather than the Type_GotFocus()section to prevent the "overload" for your computer. The trick to...

I don't believe the TransferSpreadsheet Range argument will allow you to slice up a range. It's best to do the temp table as you are doing.

Schaap, Your best bet would be to place that code into another event rather than the Form_Load (as PHV is suggesting). You could place a command button (for example) on your form and have the user press that button when they want to perform an action. That way you will give the user enough time...

Hi Schaap! What you may want to do is use an if..then clause to fill in the variables. For example, if your InvestName is a string variable you can say something like: If Me.NewInvestmentNaam = "" Then InvestName = "" Else InvestName = Me.NewInvestmentNaam End If Continue to do this...

Hi Orion45, It looks like you may have an issue with the dialog box not closing properly. Try this: ... strTable = "EssayGrades_temp" Set xl = New Excel.Application 'instantiate Excel xl.Dialogs(xlDialogFindFile).Show strPath = xl.ActiveWorkbook.FullName xl.Dialogs.Application.Quit...

Thanks for the suggestion Rick! I will definitely take it into consideration.

Vanleurth, do you mean you want to repopulate the combobox with the table's recordset each time the combobox recieves the focus? Also, what do you mean you can't figure out how to choose the first entry? Do you have any code you could show?

Blorf, you are a genius! Thank you so much for you help on this matter. That is exactly what I need! Have a star. :-)

Hi everyone, Is there a way to programmatically locate a database in a directory through VBA? For example, I have two Access 97 databases (front end and back end) that will be converted to XP shortly. As a process of the conversion, my company wants to eliminate any hard coded drive paths in...

Hi ganjass, You may want to take a look at this article: http://support.businessobjects.com/library/kbase/articles/c2008617.asp Hope it helps!

Glad we could help! :-)