Recent content by Johnrg

Sorry, not sure what indexes are?

Hi There, I tried the following code but still the same result. Any further ideas, or something i did wrong? Private Sub Form_Load() On Error Resume Next Dim varWet, varDry varWet = DCount("*", "ProcesscboPackNoUTGS") + DCount("*", "ProcesscboPackNoCCH") varDry = DCount("*"...

Guys, I am a novice here but can anyone see anything simple in this code that would make a form that opens in seconds when connected to an Access Back End take four minutes to open when connected to upsized SQL tables? Here is the code behind the main menu command buttons event procedure...

Hi Guys, Well we found a fix, just by chance to be honest, maybe this may help some one else. If you right click the access application when its running from the task bar there is a "compatabilty" option. We changed this to "XP Service pack 3" and all our problems went away. This was the OS...

Hi Dave, Yes, pretty much everything else in the DB seems to work as expected. Its just these three forms that deal with our two biggest tables. One has 45000 records, and its related sub table has 60000 records. The queries in these forms, that drag data out of, or update these two...

Hi Bob, Thanks for the reply, I looked at the options this morning and this "Windows Themes" WAS checked. Unfortunatlly after unchecking it we are still having the same issues. One form is really bad. Its almost like something in the background start running during long queries and...

Hi All, I am really stuck in the middle with this one and am starting to wonder where to turn. We just dropped $18K on a new terminal server to run our database at work. This new server is using the windows server 2010 operating system and is using 32bit Access 2010 runtime talking to...

Hi There SQL masters!!, We have a relativelly complex Access 2010 database that we are wanting to upsize to SQL. We have done some upsize testing and most functions seem to work fine at or around the same speed that the current Access back end delivers, but there are other functions that...

Hi All, We are having lots of issues running RT Access 2010 32bit on Windows Server 2008R2 via remote desktop. Things like missing borders on form displays and multiple "white screen" frezzes when long, complex queries are executed. From looking on the net this seems to be a known issue with...

Hi There, Thanks for the reply. I have formatted this report and added the product code field but have a couple of things I can't get it to do. In most cases all the data should fit one one line, There are usually only 1-5 QTY/length records per pack, so rolls over to two lines every now and...

Hi There, Thanks for the reply. Yes, its getting there, however on the report I need it to look like this. Just one line for each pack, so I can get lots of packs on each page. Pack Number Product Code Tally (shortest length >) 123456 SG8CCAH3KDPG9045...

Anyone out there in computer land that can help me out?

Hi Guys, I have attached the excel file if that will help to import into 2002/2003. What I am look at is something like Pack1 2/2.7, 10/2.4, 15/5.4 Pack2 3/2.1, 6/4.5, 7/4.8 etc rather than Pack1 2/2.7 Pack1 10/2.4 Pack1 15/5.4 Pack2 3/2.1 Pack2 6/4.5 Pack2 7/4.8...

Guys, I am a very basic user. I have a simple table that has a shows my stock of lumber. Each bundle has a pack number and this is repeated in the table once if the bundle has one qty and length record, but can be repeated multiple times if the bundle has many qty and length records. Can anyone...

I have a query that lists the individual quaintity and length data of lumber in a bundle (pack). Each bundle has a unique number but it can have many length records depending of whats in the bundle. Some only have one, others can have ten, the average is about eight. There are 3000 bundle...