Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. marina9

    Adding records from one table to another

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

    Determine windows workgroup name

    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...
  3. marina9

    SQL with function mid ?

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

    SQL with function mid ?

    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!
  5. marina9

    updating a combo box after updating its table source

    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...
  6. marina9

    How can I specify what columns to import from Excel to Access?

    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.
  7. marina9

    Problems with Me code

    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...
  8. marina9

    Problems with Me code

    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...
  9. marina9

    Trouble importing Excel spreadsheet

    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...
  10. marina9

    Locate Database through VBA

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

    updating a combo box after updating its table source

    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?
  12. marina9

    Locate Database through VBA

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

    Locate Database through VBA

    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...
  14. marina9

    Unmanaged Reports Passing Database Logon Info

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

    VBA Query Export Formatting

    Glad we could help! :-)
  16. marina9

    VBA Query Export Formatting

    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...
  17. marina9

    VBA Query Export Formatting

    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...
  18. marina9

    Conditional Search

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

    Conditional Search

    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...
  20. marina9

    Conditional Search

    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)...

Part and Inventory Search

Back
Top