Search results

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

Thanks for the reply, So how would you guys approach this? How do I make multiple components of a product that we manufacture togeather into a product code that means soemthing to a casual user? Thanks JohnG

Hi Paul, Thanks for your reply. The thing I am am struggling to get my head around is how to use product codes in this application when the combinations are so vast. I personally think that we don't need a product code for each combination of selections but everyone one I have discussed...

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

I have a form that has several pages. I use these forms to add data to three related tables. I have created a SQL Query that links the tables togeather as the record source for the form. The relationships of the three tables are one to many and then one to many. The idea is that I have one main...

Thanks for the answers guys. I think I understand what you are saying however in terms of actually entering this data in for each record/pack how would we go about this process if we have a pack has that multiple different lengths that need to reside in each record? It would be a very time...

Goodmorning all, I work at a sawmilling company down here in New Zealand and we are looking at getting a new database designed rather than buying an off the shelf access system. The timber products that we sell are made into packs (bundles). Each pack has a unique number. Each pack is...

Guys, I have a report that has a few feilds that very ocassionally have more data in them than I have allowed space for. I don't really want to increase the row height, the feilds width, or the font size to accomodate something that is an exception rather than the rule. Is there a "scale...

Thanks Guys, appreciate your help and input. JohnG

Guys, I work at a sawmill and we have a database that we use for our stock and order control. We have forms to add, ammend and view stock items and customer orders. I want to develop the database to include multiusers form(s) for despatch and invoicing including automatic order and stock...

Guys, Got it to work at last. The Expression was fine. The error was two of the feilds had the same name so we double calculating. Thanks for all your input. JohnG

Hi Bob, Thanks for that, no still same error. I ran a couple of tests and it seems like (for some crazy reason) its looking at another feild before when caluclating. Heres an example: The data in the feild Original6000 is 65 . The expression should return 65Xoriginal6000 = 390. But its...

Anyone have any experiance with remote desktop connections?

I have two seperate sites using our database which is stored on our main head office server. One of the sites in another part of the country connects to our main server through remote desktop connection. Two of our forms have "email" command buttons. When clicked they convert a report into a...

Anyone comment on why the expression may not be calculating correctlly?

Hi Bob, Data type in record source table is set to "Number" - Long Interger Thanks JohnG

Guys, I have the following text box expression that is giving me an incorrect result. As an example if I have 546 x 6.0 I should get 3276 but my expression is returning 3112.20 As another example I had 45 x 6.0 should have returned me 270 but it returned me 256.50 Can anyone see any...

Guys, I have the following expression in an unbound text box in the detail section of a report. I have checked it is working fine, which it is, and have made it invisible...