Search results

  1. M

    Add Text to Chart when Data Value = 0

    The chart generated from a query contains data for both temperature and flow over time. Occationally the data shows zero for n records. Time and zero data are still recorded. I need to place either a marker of some text over the zero data area on the chart stating "Communications Failure" as...
  2. M

    Patient Table Sort

    I have a patient table with The following Fields: Last_Name First_Name DOB Phone Address City State Zip We are want to send out mailers to our patients. As an example, we have four family members at the same address and phone. We only want to send one mailer to the household. We want to...
  3. M

    Append from Two Seperate Systems

    I have Access 2007 running the same app on two differant PC's. They both collect the same data. Occasionally, one of the internet connections goes down on one of the two PC's thus is looses data. ( Data is being logged from remote sites to the database. I copy the data base from the first system...
  4. M

    Programaticaly Change Chart Properties

    I have a chart with the Y axis showing temperature, and the X axis showing time. With the Chart in the Design mode and then double clicking to get to the graph properties, I select the X axis, right click "Format Axis". Under the Scale Tab there are 3 numberical entries: "Value(Y) Axis Crosses...
  5. M

    Detail section Formating

    I have created a report that I want to look like a quote or an invoice. I have the Report Header displaying the Comany, Customer name, Address ,city , state, zip, Quote number and date. The Page header has the labels for the fields needed, ( Part number , Description ,Qty, Price etc..) The...
  6. M

    Combo or List Box Error

    When trying to add a list box or combo box to any form (existing or new), I recive a pop up stating "No valid fields can be found in 'PARTS'. Please select a new source" Then: after clicking 'OK', a second popup "Banyan Database can't find the field 'fpk_frmFpk' referred to in your expression...
  7. M

    How to run a windows Shortuct from Access

    I have a shortcut that is created by another program(windows program). When I double click the shortcut from my desktop, the appliation launches. The application I am speaking about creates shortcuts and runs various internal macros. I need to select one of the Windows/ Application shortucts...
  8. M

    Changin Chart properties programatically

    I am recording pH data accross in the y axis and displaying the time stamp on the x axis. Depending on the duration of the report, Daily, weekly, monthly, The x axis gets pretty jammed up with time values. I have tried to use the "Graph" Class and its members, but they allways error out. The...
  9. M

    Replication Newbie

    I must admit, I am completely confused regarding this replica concept. I have read everything I can get my hands on. Here is what I need to do. 1)Have host system collect data over the internet at a remote site. ( This is done and works well). 2)Have a PC at the remote site running the same...
Top Bottom