Search results

What data type is the task field? I looks like memo, can you change it to text? You should be able to as long as the values don't exceed 255 characters.

What do you need help with? Also this is not too secure, if a user held down shift while opening the file it would open up the database window. From there the user would have full access to your db. I would suggest using User level security

In the SQL statement for the query for the report you could add Distinct after the SELECT

What about a cross tab query?

You would need to use an append query. An update query will update existing records, and append query will create new records.

Thanks Wayne. You sunk the Eight ball on the break there. I know, its a lame joke but I noticed you were a pool player.

I found a good link it is below. Any thoughts? Comments? On the link. http://jonathanstark.com/recursive_data_structures.php

Can you explain what you are trying to accomplish? It looks to me you are inserting random records. Let us know the whole picture and we can help.

What about the below table schema? Thoughts? Comments? tblParentNode NodeID - PK NodeName tblChildNode ChldNodeID- PK ChldName tblParantChildAssociation NodeID - PK/FK ChldNode - PK/FK This way, if a child node has children I can just add a record to the Parent table also. Any advice is...

I am designing a form with a treeview control and am looking for suggestions on how to setup my tables to store the information for the nodes. The issue is that a child node, can have children. So the Child can actual be a parent. So two tables with a one to many relationship doesn't seem to...

I think you could do this with a main report with Grouping set on the Site field and an embedded crosstab query. Link the crosstab to the main report by Site.

Thank you Minkey!!!!

You are correct but I would need an adapter to connect a USB cable to a Serial Port. I have only seen it the other way around. Thanks for the thought.

Does anyone know how to change COM 1 to a USB port instead of a Serial port? Can this even be done? Thanks in advance for your help.

So you want all the HTML in a single record or all the data in the HTML table in a single record?

Can you link the tables into one db?

Access uses VBA not .NET. You can use classic ADO within Access but not ADO.Net.

What is the point of being RUDE to someone trying to help? You need to learn some manners. :mad:

Why do you want to duplicate records?

instead of Dim,Obj outlook As Outlook.application Use dim ObjOutlook as object set objOutloo=CreateObject("Outlook.Application")