Search results for query: *

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

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

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!

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.

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

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

Hi, I am new to creating db statements in Access 2000 and would appreciate your feedback. I have three tables: ORIG_SHIPS id vessel type MVMT_TYPE mvmt_type_id mvmt_type_abbrev MOVEMENT mvmt_id mvmt_type_id In my database, movement.mvmt_type_id is currently null in all rows. I would like...