Search results for query: *

Thanks HitechUser! For some reason, I had to enter a bunch of extra quotes, but it works!! DJ

I am using a table (like the one HitechUser described) to populate my list box. I would like to use that table to grab the real names from. I think this would cause me to use a combination of VBA code and an SQL query. DJ

I have a form that lists all of the tables in the database in a list box so that the user can select a table to view. I don't want the actual table names displayed in this list box. EX. for iElements table, I want to see "Elements" for iCombatDamageDefs table, I want to se "Combat Damage...

Hi! I have created a hierarchical structure from a flat table. Ex. TABLE RegionID RegionName Population ParentRegionID 1 USA 276059000 2 Texas 20044141 1 3 Illinois 12128370 1 4...

I may have a parent/child table that looks like this: ID NAME CHILD 1 Arnold 4 1 Arnold 5 2 Karen 3 3 Rick NULL 4 Tommy 6 5 Nicole NULL 6 Sam NULL The resulting tree would look like: + Arnold + Tommy...

Thanks for your help up until this point Michael, but if you don't want to help me any further, you don't have to (aka you can choose not to reply). Of course I had looked into TreeView before replying. My question was more like, "I thought this control worked for displaying data." I have read...

Does this work with queries or forms only? Thanks, DJ

I am looking for some good online resources/references for representing hierarchical data or trees in Microsoft Access. Please Help! Thanks in advance, DJ

I have several yes/no columns in my table. I exported my table to a text cleaning application to clean some memo fields of non-printable characters and when I imported the table back into Access, the yes/no fields showed up as (0) and (-1). Do you have any idea how I can get them back to check...

Yes, there are always the same number of "rows" per "record". There are random empty rows so there is no consistency as far as odd or even number rows containing data. There is, however, an Autonumber assigned to each row (i.e. every name field has ID=6).

I have imported an Excel worksheet to Access, and the formatting is really bad. I need a query that converts a table that looks like this: FIELD1 ID 1234 NAME John Doe PHONE 555-1212 To a table that looks like this: ID NAME PHONE 1234 John Doe 555-1212

I want to create a query that allows me to select multiple fields with multiple criteria. For example (pseudo-SQL): SELECT Field1 WHERE ID=6, Field2 WHERE ID=8, Field3 WHERE ID=11 I know this may not make much sense to do, but I need to find out how to do it. Please Help!! ~D

It was given to me in this format with a sequential unique ID.

I guess that's where I'm struggling. The only way you know is when a new value in Ans field. You know that all of the Qi values (up until the next Ans) belong to the above Ans.

I have a table that looks like the following: Ans Q1 Q2 Q3 Q4 a 1 2 3 4 b 1 2 3 4 But I want it to look like this: Ans Q1...

I have this table: Table_A DATE BILL AMOUNT 8/20/04 Gas $30 9/15/04 Electric $20 10/4/04 Water $10 7/30/04 Cable $60 8/1/04 Phone $25 8/5/04 Electric $22 9/2/04 Gas $28 9/1/04 Water $14 I want this table: Table_B Gas Cable Electric Phone Water $30 $60 $20 $60 $10...

Okay, that gets a table into Excel, but how do I know anything about relationships. My original question was about keeping the relationships intact. Maybe I just don't know how to get to the information in Excel. Thanks for your help, DJ

We are trying to make the database viewable via the Web. The person in charge of doing this wants the database in comma or tab delimited format. I want each Access table to be a different Excel sheet. I don't know how excel keeps track of relationships between tables.

Is there a way to export an entire database to Excel and keep the relationships intact? DJ

Thanks Zameer. I had already done the google search and got that page, but it's for Access 97 and I don't know enough about VBA to convert the code to VBA Access 2002. I didn't know about the Documenter in Access. It gives a lot more info than I hoped for, but it will do for now. I really need...