Recent content by KUZZ

MajP. Basically your understanding of my situation so far is correct. I have the self-referencing tblBOM that I can loop to see how many assembly levels I have and which children components are part of which level. From here i have created a flattened BOM, that lists all children components...

Hi all! I have a table (tblBOM) that contains bill-of-materials information for a bunch of subassemblies. The BOM table looks something like this (simplified version): parentPtnr / childPtnr / qty_ofChild_perParent I need to be able to compare programatically all pairwise combinations of...

Here is what I am looking for: I have a HP LaserJet 9000 PCL 6 attached to the network. All print jobs arrive to printer via ethernet. The following print routine is required: 1. Client sends print job to printer 2. Printer prints cover page from tray 2 that has red paper i it 3. Printer...

HarleyQuinn and LesPaul thanks for the input. I like both ideas, however I went with Leslie's Best regards, Good luck, Kuzz "Time spent debating the impossible subtracts from the time during which you can try to accomplish it."

This is great, but how do I now extract a single value that is the Max of the Maxes Good luck, Kuzz "Time spent debating the impossible subtracts from the time during which you can try to accomplish it."

Hi, I need to extract max date value from 3 adjacent colums: returndate, scrapdate, reworkdate. Mind that these 3 values are in individual fields of the same record. I know how to do this in Excell. Is there a way to extract it in Access? Good luck, Kuzz "Time spent debating the...

How do I extract a list of X random records from a query of Y records, without aplying any filtering criteria other than "randomness". Ideally, I need to export the list of random records to a new table. Good luck, Kuzz "Time spent debating the impossible subtracts from the time during...

Tried continuous forms, same issue. When I try to enter new data an error box will pop up as described above, but after clicking okay it will allow me to enter. Also, check this out; I experimented with a subform in a subform in a form (3 layers total) and I do not get this error while from...

That is a compound primary key indeed. In my part numbers master table "part number" and "revision" are unique combinations. Good luck, Kuzz "Time spent debating the impossible subtracts from the time during which you can try to accomplish it."

Hi, I have a master form with datasheet subform. Main form fields (pri key) ptnr;rev. Subform fields are ptnr;rev;parent_nr;parent_rev. Main is linked to subform like this : linkchild =>parent_nr;parent_rev linkmaster: ptnr;rev. When trying to enter new record in the subform I get the following...

Hi, Just converted from Access 2000 to Access 2003 SP2. I have a database which has embedded thumbnail images for every single record. When browsing records on form all old images/thumbnails display no problem. However when inserting new images, the form no longer displays the image, it displays...

Thanks for the tip, worked like a charm. Good luck, Kuzz "Time spent debating the impossible subtracts from the time during which you can try to accomplish it."

I am trying to automate the way CNC code is sent to a CNC Machine via Hyperterminal. Currently in order to transfer a cnc program one needs to open a .ht file with hyperterminal, and do a send text file to host. Here is how I decided to automate it. The CNC code is resident in a memo field on...

I am trying at the push of a button on an Access form to copy contents of simple text file "c:\file.txt" into a memo field "memo" on the same Access form. Has anyone done this before? Please help. Good luck, Kuzz "Time spent debating the impossible subtracts from the time during which...

I am trying to get resolution to a similar problem, but I would like to see the color changing in the PRINT VIEW of an access form or report. For example I have a list of part numbers on a white box background. I need the box to change color if the part number is of class A B C D E F.... many...