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 Chriss Miller 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: *

  • Users: emik
  • Order by date
  1. emik

    Run-time error 3052 file sharing lock count exceeded

    Hi guys, This is a strange problem I recently encountered. I found a fix for it on Microsoft's website but I want to understand the problem and how it might potentially affect my program. The error is: "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry." Essentially I...
  2. emik

    How to use a field with spaces in a recordset

    Thanks Tom, works great!
  3. emik

    How to use a field with spaces in a recordset

    Hi, I currently have a process to import an Excel file using the Transferspreadsheet method. The Excel file has fields with spaces, so the field names in my Access table must match (thus having spaces). In the code for a field without spaces, the recordset is test =...
  4. emik

    Creating a status bar

    Yes I did that, but it's in very technical terms. I'm looking for a more english translation on when I should be using it. Yielding control to the operating system and returning a value of open VB forms doesn't help me understand why it works in this particular instance. Thank you.
  5. emik

    Creating a status bar

    Hey it works! Thanks for all the suggestions. A few follow up questions, why do I need to explicitly identify controls? eg: why is Me!txtPercent different from just txtPercent since it's on the current form? Lastly what exactly does "DoEvents" do? If the code is running, why is it necessary...
  6. emik

    Creating a status bar

    Hi guys, I've created a percent counter by using this code in a loop, so with each iteration i and j get increased and a percentage is shown. Dim strFormat as String j = j + 1 Total_progress = j / i strFormat = Format(Total_progress, "0%") txtPercent.value = strFormat...
  7. emik

    How can I get Access to run faster

    These are all very good suggestions. The way I was going to go was to create the 2 queries, one where it matches and one where it finds un-matched and doing it in 2 parts would speed it up (plus I wouldn't have to check conditions). However what I realized was the data was at a lower level...
  8. emik

    How can I get Access to run faster

    I'm not sure because there are conditions I need to check. I know limiting the number of IFs and conditions will make it go faster but I have no choice. I need to look through each record, if a match is found determine the type of match, so I have a short CASE statement (only 4 elements)...
  9. emik

    How can I get Access to run faster

    Hi, I've never written a program with this many records before and the time it takes to process is through the roof. I have 1 table with 5,000 records and another table with 160,000. What I need to do is loop through the 160,000 and update the 5,000 accordingly. Essentially my code looks...
  10. emik

    Take certain values from report details into report page footer

    Hi, I have a dynamic report report and based on a certain criteria I want to put records into the page footer. For example, if my table looks like this: Item Cost Use ----- comp $1,000 my computer car $2,000 house $3,000 where I live I want the...
  11. emik

    Creating and populating a new Excel file through Access VBA

    I hate not being able to modify, I meant until Monday
  12. emik

    Creating and populating a new Excel file through Access VBA

    Thanks for the advice, I'll check it out. Some priorities came in though so I probably won't be able to get around to it until then. Thanks guys.
  13. emik

    Creating and populating a new Excel file through Access VBA

    Hi, Here is what I'm trying to do. I have 6 queries and I need to output the data to the same Excel sheet with calculations that I will do in Access. So essentially I want to create an Excel file, write my values to it and then save it. I know the starting part would be something like: Dim...
  14. emik

    Formatting and Rounding

    Ok, I say forget the comma! Round(Number / 1000000, 1) - works great, I wish I knew I was missing an arguement, it would have saved me a lot of time.
  15. emik

    Formatting and Rounding

    Ya I realized that it returns a string with replace because when I try to sort it by Marketvalue it takes the first character, so $33,9 is now smaller than $4,1. Oh these horrible users.. ;)
  16. emik

    Rounding to 1 million and formatting it with a comma

    The only thing I see now is when I sort (it needs to be sorted by highest market value). It does not recognize the first 2 digits, so it seems it is looking at the first number and deciding if it is bigger or not. eg: $33,9 $4,1 $5,8
  17. emik

    Formatting and Rounding

    PHV, Someone just posted the exact same thing to me. This is the greatest website ever. Thank you to everyone who helped me on this one.
  18. emik

    Rounding to 1 million and formatting it with a comma

    It worked! Thank you so much.
  19. emik

    Rounding to 1 million and formatting it with a comma

    Hi Golom, It works when I use the code you gave me but no in conjunction with how I'm building the value: Market: Replace(Format(Sum(Round(([MarketValue]/100000))),"$#,,.0"),".",",") it just returns: $,0 Could you explain to me what that code is doing in more detail? Thanks.
  20. emik

    Formatting and Rounding

    Hi anotherhiggins, I'm in Canada and for some reason (whether it be right or wrong) the user wants the comma. If it were me, I'd just round and be on my way :) I got this from a user in another forum: Replace(Format(34450000.00,"$#,,.0" ),".",",") but when I replace the 34450000 with my...

Part and Inventory Search

Back
Top