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 Rhinorhino 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. GregTheGeek

    Memory and working with large files

    Thanks again for the input, TonHu. I finally have the ability to load large XLSX files using the XSSF eventmodel. I started with this code, and did what we all do: tweaked it! [thumbsup2] GTG
  2. GregTheGeek

    Memory and working with large files

    TonHu, According to the page you linked to, SXSSF does NOT support reading files. However, it seems that instead of using the usermodel of XSSF, using the eventmodel may be what I'm looking for. It also allows for streaming of the file. Thank you again for your input! GTG
  3. GregTheGeek

    Memory and working with large files

    TonHu, I will give it a try. Thank you! GTG
  4. GregTheGeek

    Set visible = false from within subform

    I've revised my answer unnecessarily. This is why I call myself a geek. For the OnClick event of the button on the sub-form... Private Sub Command0_Click() On Error GoTo click_Error 'stop screen updates DoCmd.Echo False 'set the tag property Me.Parent.Tag = "hide"...
  5. GregTheGeek

    Set visible = false from within subform

    Try: For the OnClick event of the button on the sub-form... Private Sub Command0_Click() DoCmd.Echo False Me.Parent.Tag = "hide" 'this is some control on the parent form which will receive focus Me.Parent.Controls(1).SetFocus End Sub For the GotFocus event of the control on the parent...
  6. GregTheGeek

    Date add to calculate date

    If you are looking to do this in a SELECT statement, try this: SELECT DATE_ADD(`baseline`, INTERVAL 1 MONTH) AS 'ProjectedDate' FROM {TableName}... Hope this helps! GTG
  7. GregTheGeek

    Composite Keys: Good or Bad?

    Let's look for a moment at what, exactly, a primary key is. "The primary key of a relational table uniquely identifies each record in the table." (http://databases.about.com/cs/administration/g/primarykey.htm) If, by the nature of your data, multiple fields are required to uniquely identify a...
  8. GregTheGeek

    Memory and working with large files

    Dian, Thank you for your response. The data, unzipped, is nearly 400MiB - my previous estimate was a little low. Why simply opening this file with POI is causing the heap is bloating to over a gigabyte is beyond me. The main reason I'm using Java (aside from legacy support) is because most of...
  9. GregTheGeek

    Memory and working with large files

    Hello. I am working on updating a Java application that was originally meant to load XLS files into a database table - MySQL, if you're curious. It utilizes the Apache POI libraries, in part, to make this happen. It's not fast, it uses a lot of memory, but it works. Now that our organization...
  10. GregTheGeek

    using LOAD DATA INFILE; field contains embedded quotes/commas

    r937, There are a few issues with your suggestion: 1. Excel does not parse the fields correctly either. I would end up with extra fields in the problem record(s). 2. Excel should never be used as a solution in this way. Never. It's not cross-platform (meaning it doesn't run on Linux) and...
  11. GregTheGeek

    using LOAD DATA INFILE; field contains embedded quotes/commas

    Andrew, thanks for the input. Unfortunately, I do not have control over the format of the file. I wouldn't be here if I did. :-D GTG
  12. GregTheGeek

    using LOAD DATA INFILE; field contains embedded quotes/commas

    Hello all, I am trying to load a CSV into a mySQL table using the LOAD DATA INFILE command. There is (at least) one record that is causing an issue with the load. A text field in the record *contains* quotes and commas. Example: {...},ABCD,"This is some text in a field. It contains commas...
  13. GregTheGeek

    Calling a function in the BackEnd from a macro in the FrontEnd

    My apologies, I misunderstood the intent of your message. Just to be clear, you are telling me is there is really no way to do what I want by only using a macro? Unfortunately custom toolbar/menu controls will only reference macros (at least in Access 2K/2K3). I guess I will have to create a...
  14. GregTheGeek

    Calling a function in the BackEnd from a macro in the FrontEnd

    MajP, Thank you for your response. The function itself opens a form (which resides in the BE MDE), so I don't want to create yet another form just to call this function. My users are on a technical level, so really, using a macro is just for convenience, not aesthetics. * If I call the...
  15. GregTheGeek

    Calling a function in the BackEnd from a macro in the FrontEnd

    I have a back-end MDE (BE) that holds my functions, subs, and class modules. I then have this BE MDE referenced in my front-end (FE) MDB. Everything was great... until today. This thread gives a good idea of what I'm trying to do, but comes just short of giving the answer I need...
  16. GregTheGeek

    Search Windows Registry

    Golom, Thank you for the code, it pointed me in the right direction. I finally have something working! GTG
  17. GregTheGeek

    Search Windows Registry

    Hello all, I have a function that will dynamically build, based on passed parameters, a connection string to our mySQL server. I need to be able to use this code on different machines, each possibly with different versions of the mySQL ODBC driver installed (3.51, 5.1, etc). I created a...
  18. GregTheGeek

    Help with VBA Code

    Keri, Typically, when Access prompts for a value, it means it doesn't recognize one of the expressions. This happens a lot in queries when you make a type-o in one of the criteria expressions, or specify a filed that it cannot find. If you need further help, I will need more detail. What code...
  19. GregTheGeek

    How to link to MS SQL Server’s table in Access programmatically?

    kjv1611, Not that big of a difference. As I stated in my correction, all he needs to do is change the connection string. Everything else should work fine. GTG
  20. GregTheGeek

    How to link to MS SQL Server’s table in Access programmatically?

    Oops, sorry, I just realized I misread your original post. :-( I thought you wanted to get to mySQL data, not MS SQL. Really, all you need to do is change the getMySqlConnectionString function. Take a look at http://www.connectionstrings.com/ for the connection string you think would best work...

Part and Inventory Search

Back
Top