Search results for query: *

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! :-)

JPeters, Hennie has given you an excellent example of some format programming you can use in your application. Some additional tips: To format an entire column to "General" via code, you can add 'format excel spreadsheet With myXl 'your Excel application object...

One trick I learned from another thread is to export your file to Excel, open the spreadsheet, create a macro where you manually format the entire column (and perform any other formatting you would like, such as auto-fit, highlighting, etc.), stop the macro and review it's code. The programming...

Thanks ESquared for your suggestion. I will definitely take it into consideration and see if I can revise the stored procedure as you suggested. :-)

Thanks despierto for your reply! That really helped isolate where the issue was. Turns out the SQL was not reading the quotes to indicate the field is a string. When I changed the last SET = @Where statement to SET @Where = @Where + CASE WHEN @BrokerName IS NULL THEN '' ELSE ' AND [Broker...

Hello everyone, I've created a stored procedure that accepts various input parameters and builds a dynamic SQL statement from them. Here is the procedure: CREATE PROCEDURE dbo.sp_LPXCustomerLimitBrokerSearch @Status VARCHAR(2), @RegionCode VARCHAR(3), @LincsCode VARCHAR(5)...