Recent content by K9Boxer

When building the query for the Subreport, in the Criteria column, right click with your mouse and select Build. In the wizard that is provided, you can select "Reports", which opens a drop down list of all Reports. Select your main report. The second column will show all columns...

I believe you need to set the column to 'Not Null w/Default'.

UPDATE Local, Server SET Local.ID = [Server].[ID] WHERE ( (Local.Name = Server.name) and (Local.ID <> server.id) ); Should be what you are looking for.

Ok.... a few questions... Are all three tables already in existance -or- are you looking to execute a 'Make Table' Query that will result in the new table? (Meaning that the rows will be replaced with each execution.)

Where is this code placed? Thanx

One option is to store the 'Video Name' on the customer record instead of always pulling the Video name as a result of a join. Another option would be to add another key field: Video#, Video Assign Date (date name assigned to the number), Video Name. When selecting a video for a customer, the...

Just a note on AutoNumbers.... If using Random generation, negative numbers are also generated. FYI

Within your code, in the problem areas, place 'DOCMD.SETWARNINGS FALSE' prior to the execution of the offending code. After which you may elect to SETWARNINGS TRUE.

Found the answer. We use Platinum at our location. It captures the execution detail of plans. We then extract the data and place in DB2 tables for summarization at a latter date. Great info. when looking into possibly obsolete plans.

I believe that this option exists at your database level. In MS A97, it is found under OPTIONS; EDIT/FIND. In development mode, try changing this setting, and redistributing the .mdb to the machines with RunTime installed. Let me know if this helps.

No. Check Boxes are Boolean entities. Only the two values (0/-1) are possible: (also expressed as True/False -or- On/Off etc....)

I would create a query (Q_SumExtendedPrice) that resulted in : Supplier_ID, Sum(ExtendedPrice) Where Date => '01/01/2001' Base your form on Q_SumExtendedPrice If you need additional Supplier Information, Create another query (Q_SumExtendedPriceWithSupplierInfo) by joining your master...

It appears that you are trying to do a date function on a text field. This won't work. Determine the date where Now() - 180 days and put into a text format [TextDateCurr-6Mo]. Change your code to [DateofFile] >= [TextDateCurr-6Mo] Perhaps this will work for you.

I have tried to supply your values in the statement.... Forms![X]![Y].Form![PO_Number] An easy way to get this information: In query design Right Click on Criteria Select Build Select Forms Select Loaded Forms (have your form open) Select Main Form (+) in the folder Select Sub Form...

Check out: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report?fn=db2v7s0fet1st.htm .-1-------. >>-FETCH FIRST--+---------+---+-ROW--+--ONLY------------------->< '-integer-' '-ROWS-' The fetch-first-clause sets a maximum...