Search results for query: *

I am new to Access so I'm not sure how I would implement that...but I was really under the impression that it could be done in the actual table definition...Any suggestions are welcome.

Hi! I am designing an Access 2003 database that includes movement_header (master) and movement_detail (detail) tables. The primary key for the master table is movement_id, type autoincrement; this related to the foreign key movement_detail.movement_id. In the movement_detail table, I would...

Thank you very much Ian. I appreciate your help.

Oops, correction - our new server has version 10 installed, not XI. Sorry about that...But when I use Crystal version 10 to create a new report with an embedded OLE object (a two page Word document) it only prints the first page. Has anyone out there had success embedding a multi-page OLE object...

Thanks for the light-speed reply! We are building a new server with the latest version of Crystal...do you know if what I am attempting is supported in XI?

Hi, I am embedding a dynamic link to a multi-page PDF file in a Crystal 7.0 report. But when I view the report on the screen (or send it to the printer) it only shows page one of the embedded PDF. Am I doing something wrong, or is the application just not able to do this? Any suggestions would...

Just in case anyone else is having the same problem I was, here is how I finally resolved the issue... In the solution explorer, select the project, then in the menu bar select project - properties. Then in the properties pages window select Configuration properties - debugging. Then under...

I have very little experience to apply here, but in VB6 I could specify arguments to my application for debugging purposes simply by going to Project | Properties | Make. I am in the process of converting to VB.Net, can anyone help me determine how to do the same thing here? Thanks in advance!

Thanks to both of you for your helpful replies. I had read about the choice command but couldn't get it to run (duh!) and the info about the copy command will be helpful too. Thanks again and best wishes!

Is there a way to write an NT script that allows user input? What I mean is that I would like to interactively prompt the user for input (say, their name or a transaction number), and capture their response in a variable. I would appreciate any help.

First of all, thank you kindly for both replies. WildHare, I was not aware of the "instr" function, thanks for educating me on that. Zathras, You are correct that I simplified the SQL. As it would happen, I am now having trouble duplicating the original pair of statements. But I...

Attention Jet SQL experts, I am looking for all rows in my_table where fld2 does not contain a comma. I have discovered that the following two SQL statements return a different set of rows using an Access 2000 query: SELECT fld1 FROM my_table WHERE not (((fld2) Like "*,*"); and...

I am relatiely new to Access 2000, and have a rather general question about text fields. In my database, I have a "customer" table with a field "cust_name". If I query the customer table for distinct cust_name's I get all uppercase results. But if I visually scan the data in...

Thanks Jeremy, I appreciate your reply. Best wishes.

Hi, I am creating a series of Access 2000 queries to create and populate a database. I was wondering if it is possible to put multiple SQL statements in one query. For example, can I say something like create table table1 (fld1 autoincrement primary key, fld2 text); insert into table1...

It all depends on how your tables are set up and the details of what you want returned by the query, but here is one suggestion. If the tables are set up something like this: PROJECT proj_id (PK) proj_name proj_sponsor proj_mgr STATUS_RPT proj_id (FK) status_date status_text SELECT p.*...

Try using a LEFT JOIN something like this: SELECT * FROM employee LEFT JOIN emer_time_used ON [employee].[emp_id] = [emer_time_used].[emp_id];

Try something like this: select count(*) from mytable where condition = 1; Of course substitute "condition = 1" with your own criteria.

Sorry, lespaul, we must have posted at the same instant. My reply was certainly not meant to contradict you amigo. I supposed that the accepted field was y/n or Boolean, in which case the two phrases accept = no and accept <> yes are logically equivalent. But - in terms of readability and...

If I understand the problem correctly, you may be able to get the information you want from one table. Try something like this: select distinct courseid from approval where courseid not in (select courseid from approval where accept = no);