Search results

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

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

Hi All, We have had a database designed in MS Access 2010 that can "talk" to SQL server if required. Our plan was to spend a month or so bug testing and finalizing tables and then transfer the DB backend over to SQL. We have 6 users, with moderate data entry and manipulation and plan to...

Hi All, We have a form in our 2010 DB that creates an EXCEL pivot table. There is a command button on the pivot table that refreshes the data in the pivot table from a .accdb database. On some of our machines we get these messages, has anyone seen these before? Note: these messages fire...

Hi There, We are getting a database developed in Access 2010 and have been plagued with "ghosting " issues from the main menu command buttons. The developer cannot replicate this in his sytem and can't explain why it is happening or seem to come up with a definite fix. As he refines the code...

Hi All, We have some code in a Access2010 DB that runs query, creates a pivot table and then exports this to Excel. It works fine if the host PC is using Excel2007 or better but most of the PC's here at work are using Excel 2002/2003 and it just won't work. The query runs but excel will not...

Guys, We are working on a complex database, based on continuous forms that seems to have issues with screen flickers and form refreshs when ever something needs processing, is changed or relates to code. The functionality is fine but it looks less professional than you would expect because...

Hi Guys, Can anyone advise if this is possible? We have a standard order form/subform with customer and delivery details in the main form and specific order details in the subform. I want the developer to include a command button that opens an EXCEL spreadsheet template and auto enters...

Guys, We have a very simple, one table, access database attached to the backend of a peice of scanning equipment. We make thousands and thousands of scans every day and the database fill ups very fast and gets slow. We transfer this data into another program each day for reporting and...

Guys, I have a query that list records under the following three simple feilds Date Required, Currency, Total Price I want to get another query to sum these records into: Month Required Currency (grouped togeather under each month) Total Price (Summed in each month above) I am stuck on...

I have setup a command button on a form to open and preview a report. The report runs and opens fine if clicked from the design page. But, when I click it from the form the report runs but then minimizes to the taskbar rather than filling the screen. I have checked the properties of this...

Populating a feild from other feilds to produce an "invoice product code" I have a manufacturing plant that combines ten individual component groups to make a finished product. I have a table setup for each "component group" with an index number, a short description and the full description...

One of our branches connects to the stock database on our server using a remote desktop connection. I am trying to set this up so that when the connection is established the Access program automatically starts bypassing the servers destop and program shortcut. There is an option to enter the...

Guys, I am new to this type of form can you please help. I have a simple form thats data source is a query. This query looks at historical customer order details. There are 19706 records when the query runs. I have created a new form with an unbound combo that row source is the customer...

Guys, I have a report shows historical order information from our customers thats data source is a query I designed based on two linked tables called OrdersHistory and OrdersHistoryDetails. The query and report run fine and show the data I need however it shows all the data for all customers...

Hello all, Our companies timber products are made up of five seperate componets. These are: Grade Treatment Dryness Finish NominalWidth NominalThickness In each category there are multiple options. The combination of one selection from each category is the product code. As you can...