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 Wanet Telecoms Ltd 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: tonywilliams
  • Content: Threads
  • Order by date
  1. tonywilliams

    HELP! DLookup and my report wont work??

    I have posted a number of posts in the Access newsgroups concerning my problem with DLookup. I have had a number of the experts with helpful suggestions but I still can't get it to work! This is what I am trying to do: I have a table called tblmaintabs which holds year to date data for a...
  2. tonywilliams

    Help with DLookup and calculated controls

    I have a calculated control in the detail section of a report. The calculation is =[txtDomfacsoleqtr]-(DLookUp("[txtDomfacsoleqtr]","tblmaintabs","[txtMonthlabel]= [txtqtr1]")) The calculated control is called prevqtramount. In a footer I want to calculate the sum of this and have used...
  3. tonywilliams

    Before or After Update?

    I have a form that contains a number of numeric controls. There are a number of rows and columns of figures and each row and column has a total.The user fills in all the controls, even the totals. I have validation code on each total to make sure the total is correct (the user wants to key in...
  4. tonywilliams

    Problem with calculated field in report

    Can anyone tell me what's wrong with this formula? ([Sum Of txtClients0]*[txtclientstotal])/[Sum Of txtClientsTot] TxtClientstotal is a calculated on the report the other controls come from a query. I get an error message asking for Extra "(" in the formula. I've tried putting () around most...
  5. tonywilliams

    Printing an Access report with two different page formats

    I have a 4 Page report , only the second page is in two column format. At the moment I have to print page 2 as a separate report and then collate it with the other pages. Is there any way to print a report where the page formats are different. I have tried inserting page 2 as a subreport but...
  6. tonywilliams

    Combining two tables in Access 2000

    I want to combine two tables into one. I have a table (tblmaintabs)with all the field definitions from two other tables (tblmain and tblturnover). I now need to update this new table with the data from the other two tables.However both the existing tables have 2 fields that are common ie...
  7. tonywilliams

    Deleting Files in W2k

    I have W2K pro and cannot delete files from Windows Explorer or shortcuts from the desktop. I gat a message that says cannot delete file cannot find specified path. if I am deleting from Explorer the path must be OK. What's going on anyone know? Thanks Tony Williams

Part and Inventory Search

Back
Top