Recent content by kimosavi

Thanks! it does help! I just need know a server to put my DB. What would you recommend? are there free servers out there where I can put my DB? I will access the DB thru Visual Basic Application not WEB so no need to host the pages just the DB.

Hi. Kind of newbie on the whole Access on the web sharing. I am building an application in VBS. my plan is to use a small centralized Access DB as my data repository. I need this file to be on a server which each one can connect and share. what would be my cheapest way to do this (if...

Hi. I know this question has been around for quite some time but I don't seem to find the correct syntax for my query. I have a table with 3 fields: Bucket, Vendors, Docs. I want to run a query that tells me how many unique vendors and docs are in each Bucket Bucket Vendor# Doc#...

I found the solutions searching different sites.... 1. when the form loads 3 ribbon tabs exists (home, add-ins,acrobat). how can i remove those ribbons as well?? http://msdn.microsoft.com/en-us/library/bb187398.aspx look at the steps in Scenario: Marketing Projects Database will show how...

Hi. Thanks to all that have contribute to helping on my project. Almost done! I have some issues with the navigation pane and ribbons I when to Access Options and unchecked the nav. pane and ribbons. 1. when the form loads 3 ribbon tabs exists (home, add-ins,acrobat). how can i remove...

Thanks Banana, I already counted the records, so I know where it ends. I need to pick samples from random position. I decided to go 20%, 40%, 60%, 80% and 100%. doing the movenext from 0% to 100% will cause the same or similar effect as movelast. the rs doesn't seem to go to a specific...

Hi, I think problem is this is kind common but I can't seem to find an easy solutions. I have a TEXT file linked as a table (SOURCE) to my DB. I have a Query (SOURCE_WLU) that uses the TEXT file plus is linked to several others tables in the DB. i am trying to get a 5 random values out...

Ok guys, some numbers to look at... I created a simple query that sums the total dollar amounts. I have the data on both the local hard drive and on a SQL server. QT: Query Time 1. running a VIEW on ADP project. QT: 6-8sec 2. running a QUERY local hard drive. QT: 45-55sec 3. running a...

Thank you all for the replies. I already built the proper tables as "permanent views" since the data is not transactional. the problem is generating those temp tables is when the time comsuming process starts. I guess i will just have to deal with it, put some messages and some time...

Thanks RuralGuy, I had already updated the form msgs to reflect Access behavior, but it takes way from the look and feel of the tool. This tool is meant to analyse data sets ... data could be 10MB to 2GB, so in cases of small data set the performance will be nice, but the 2GB files are the...

thanks gemma-the-husky for your reply. well the problem is not so much within loops, but running extensive SQL statements. most of the code are simply MSQL = "SELECT XXX FROM XX GROUP BY XX" Currentdb.Execute MSQL so the DB is about 1.9GB on a split file, so it takes a while to run...

Hi, I have some subrutines that are time extensive. It is Ok due to the large amount of data they process. my problem is that while they are running Access says (not responding) until the code finishes. Some users think Access has crashed and tries to stop the code or restart the PC. is...

How Can I check if an index was automatically generated? In the design view of the table?

Yes. This might consist of multiple Scenarioes. but the main one is this: Building a tool that Analyses a data set. I have data/code splitted. the user will import into the data DB and a link it into the code DB. When small you can import in the set directly, but sometimes the data set...

Been working with Access for a long time, but it's the first time I have seen Access bloat so much. I have a 700MB CSV file, all text columns. This file contains about 2 million rows and 30 columns. After I import the file (using the Wizard) the final size of the DB, after compact and...