Recent content by MikeSr

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

I am stuck with my query. As I mentioned I was able to get the count. How do I use the count to add the new data? Do I create a new field in my "Customer" table and add the String data and or the first name to that field? I have tried to implement the "Addressee" as a field name in the query...

I was able to get the sort to show the correct count by Last name and phone number. There are to many surnames that are the same in the same zip, so Phone worked just fine. I am stuck with how to implement your algorithm. Can you provide more detail as to how I go about using the query that...

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

Sure, I am logging analog data from a PLC (programmable logic controler) that is located in another state. I do this by using a software application called KepServer EX. It then places the data in my defined Access 2007 data base. Since I have to use a VPN connection, it disconnects at the...

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

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

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

Tried all of the above. Nothing worked. I closed Access 2007 and then re-opened it. That solved the problem. I should have know better to begin with. Thanks for your kind and quick responce. Still don't know why this happened.

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

Thanks for your help. I contacted the Macro Pro Software mfr and this is what they came up with : Dim RetVal As String Set wsShell = CreateObject("wscript.shell") Set proc = wsShell.Exec("C:\Program Files\Workspace Macro Pro 6.5\Workspace Macro Pro.exe send-email.wksp /u") //Shell command is...

Thanks, but I should be more specific. I am using a program called Workspace Macro Pro. This program creates macros to do things like start a program, run it for 60 seconds and then shut it down. You can create many macros. The program creates desktop shortcuts for each macro. Hope that makes...

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

Learned a bit more. I was using a report with a chart object on it. Apparently you cannot use a report. Once I used a standard form with the "Default View" property set to "Single Form". I was then able to access the Chart properties programaticly. Try this using a report, and it doesn't work.

Ok, here is what I have so far, I add the following code: Dim mygraph as chart Set mygraph = me.graph0.object etc... What happens is I get error message 2771 "The bound or unbound object frame you tried to edit doesn't conatin an OLE object" How do I fix this? I have a graph on a...