Search results for query: *

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

Is a plan's last execution timestamp stored on any of the SYSIBM (or other) tables? I can find the last bind timestamp, but I am looking for the last execution timestamp. Any insight is greatly apprecited.

OR: Create the MAKE TABLE Query you want in design view - Test it to make sure it does what you want. In you code, place: DoCmd.OpenQuery &quot;Make Table Query&quot; Still new to DB's and enjoying learning day by day - me, too!!!

MS Access 97: An easy way to generate code is to create a Macro with the function you would like to accomplish. Then select the &quot;SAVE AS/EXPORT&quot; option under FILE. Select &quot;SAVE AS VISUAL BASIC MODULE&quot;. After that you may elect to include &quot;ADD ERROR HANDLING TO GENERATED...

James, It looks like it utilizes the size of the box on the form prior to loading it with data. I've been playing with the CanShrink/CanGrow, but it appears these values can only be set in the Property Box. I'm still trying to find a solution. Sorry my previous post didn't work. D

Try this in the Detail On Format Set the height of the shorter fields to the field that should be longest. This works if a particular field will always be the longest. Or compare the fields.Height and organize the code to set the others to the .height of the longest. Example Code...