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 Rhinorhino 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: uthomsst
  • Content: Threads
  • Order by date
  1. uthomsst

    Referencing a user defined type

    I am writing some code where I want to reference a user defined type via a fieldname which is held in a variable. Does anyone know how to do this i.e. Type TestType desc as string code as string End Type Dim FldName as String Dim AUDT as TestType FldName = "desc" [AUDT.FldName] =...
  2. uthomsst

    OWC Combination chart issue

    I can create a chart using code no problem, bar charts etc. I can create a combination chart using a bar chart and line chart however when I set the second data set to be a scatter graph, it takes over the chart and the whole thing becomes a scatter graph as opposed to a bar chart with a line...
  3. uthomsst

    Adding a line to a graph

    HI I've developed a system that produces automated bar charts based on the frequency of something i.e. density/weight etc and emails them to me. However I want to add a minimum and maximum line to the chart so I can see which bars are with the minimum and maximum ranges. Can you do this if so...
  4. uthomsst

    #Name? Problem when using ADE

    I have a database (ADE) that works ok on my PC. This database was developed on my machine and turned into an ade on my machine. When I go to another PC on all my date references it comes up with #name?. If I load up the adp the date references are fine. I can then create a new ade on that...
  5. uthomsst

    Compiling an ADP

    I developed an application in access (My First One) as an ADP. Using the information in here I have managed to create an ADE file (Had compile errors and wrong file format). My application runs in a small centered window but when I run the ADE access launches itself fullscreen with my small...
  6. uthomsst

    Trying to count in report using IIF or SUM(ABS) not working

    I have a problem with a report where I am trying to count the detail records in a report but exclude both null and zero values. I have looked through the forums and found a couple of answers but they do not work for me. I am using a ADP project and using MSDE (Free SQL) as the backend. If I...
  7. uthomsst

    Correctly using dates with and SQL Query in an ADP

    I am using access 2002 to create an.adp project. I have a number of tables which I have imported from an old mde database that someone developed. In this database there are two fields d3cdate (ShortDate Format) and d3ctime (Medium Time Format) The database is held on an MSDE server (Latest...
  8. uthomsst

    Filtering a subform from its Parent in a Access 2002 ADP

    I have created an access 2002 project (.ADP) with a series of tables stored within MSDE. I want to create an enquiry form where I can enter some data (ie. date from, to) into fields on the form and have the data appear in the subform below. I would then like to use this data in a report. I...
  9. uthomsst

    Data Types from Recordsets in Lotus Notes

    I've wrote some code to extract some data from lotus notes into access using odbc but I have a problem with the field types. If I use the code Let texttest = rstnot![NorD] This will set my text field to the correct value from the notes recordset field. BUT === In some cases you cannot use...

Part and Inventory Search

Back
Top