Search results for query: *

In Excel 2007, I have the hardest time with CONCATENATE. I have 2 columns of text that I want to concatenate together (row by row). If in cell C2 I enter =CONCATENATE(A2,B2) the result is just THAT-- As if I had put quotes around the whole thing.

I have an Access DB of personnel-type info. The info originates online in different Excel files that are updated on different schedules. Each is renamed according to the date it was last updated. I cannot link the online files to the DB, so I have to save them to my computer and link or import...

Is there a way to combine 2 text fields in a table to make a third in the same table? Example for one record: Field1 = 1 Field2 = a Field3 = 1a

I have a pdox table of some 3000+ records. I was trying to change the driver language and wound up with a corrupted table. I ran the table repair and wound up with only 378 records. Did this a couple times. Each time the 'copy of' table shows the correct size, but is mostly unreadable. The...

Is there a way to put a database such as Access or Paradox on an existing website so that guests can query it for data, but not edit it?

I would like to put a combo box onto my form. The associated table has one field that has different spreadsheets as objects for some of the records. I would like the user to be able to choose a record from the first column (name of a publication), and see the spreadsheet of data in the 2nd...

Definitions please: What is the difference between a composite index, composite key, vs primary + secondary index. Is creating a composite key as simple as defining 2 fields as keys? I haven't seen any good how-to references on this.

How can I add a field to an existing form without starting from scratch?

I must have done something to hide the standard menu bar in Word. Control-V does nothing, right clicking only shows the short cut, paste, etc menu. I've tried right clicking all over the document and edges with no luck. Any other ideas? I looked in the MS office tools folder & it doesn't...

I would like to write a program to change the table name in a query, and then run the query. The table structure will not change, nor will the checked fields. Reason: I always forget the fields (predetermined) I'm looking for.

What, in SQL lingo is a Token? I get references to it in some error messages.

I created a 2 table query using a data model. It ran at the time I created it. Then I saved it for future editing and use, but when I try to call it up, I get the msg "Expecting consistent number of columns in all rows of table" The related Help, says it may have an incorrect # of...

I am trying to use the changeto command in a query to change a numerical (N type) field with a calculation. This would affect all the records in the table. I get an error msg saying I am trying to link 2 tables (WRONG) and the fields are not the same type (number fields should have no...

I would like to query two tables of different structures. My goal is to create a new table with select fields from each table. Pdox says the query appears to be asking two different questions. Does it mean that the tables have to be the same structure? What is the point of having...

Thanks for the tip, however I managed to fix it already, although I don't know how well. The directory with the problem had the file pdoxusrs.lck I realized that the other directories didn't have that, so I moved it out of the pdox environment. So far, so good. I am just not sure if I can...

I used to have Windows 95 and was using Pdox9. Now I have a new machine with windows 2000 Professsional. I store the Pdox files on two network-type directories. I can access one directory but not the other. The error msg says the "directory is controlled by another .net file", and...

Recently when I have been on the web and clicked on links, I get one of two error messages: 1. The plugin did not initialize properly or 2. The plugin was found but an error in the plugin has occurred ...A brief description/definition of 'plugin' would probably be helpful as well. Thanks

I have a primary table (for data)and an auxilliary table (for comments) Aux. doesn't have comments for every record, only when Primary has a 'y' in its comments? field. When entering data, is there a way to trigger Aux. to open for edit by entering the 'y' into the Primary comments field? I...

I currently use Pdox9 (Win95), but the table was originally a DOS version 4 table. I thought that the table would be updated with each new paradox version, but I am trying to make a lookup table and I get the error msg that the table needs to be more current (the language is listed as...

I don't know if this is the right forum... I am wondering if someone can recommend some references to help understand pdf files (create them, etc.).