Search results for query: *

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

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

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

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 running a MakeTable. The parent table allows zero length for field "revision" but newly created table does not allow zero length. What is the VB code to change the field propery of the newly created table to allow zero lenght. Thank you. Good luck, Kuzz "Time spent debating the...

HERE IS MY CODE Dim rst As Recordset Dim cnn As ADODB.Connection Dim strFilter As String Set cnn = CurrentProject.Connection Set rst = New ADODB.Recordset STRPROMPT = "PLEASE ENTER PART NUMBER" vPTNR = InputBox(PROMPT:=STRPROMPT, _ Title:="PART...

I have inherited a table, 300+recods, with embeded images of parts. I want to take out via code or sql all those images from tblPICS and store them to \\mycomputer\thumbnails location on my network. How can I do that? Good luck, Kuzz "Time spent debating the impossible subtracts from the...

I heard that it is better to keep the BE as close to a HDD root as possible, preferably in the root, because the deeper the BE is burried, the slower, a lot slower it gets. It that true, or is this a myth. Good luck, Kuzz "Time spent debating the impossible subtracts from the time...

I heard that it is better to keep the BE as close to a HDD root as possible, preferably in the root, because the deeper the BE is burried, the slower, a lot slower it gets. It that true, or is this a myth. Good luck, Kuzz "Time spent debating the impossible subtracts from the time during...

I am running a SQL statement behind a form. Instead of all warning messages, e.g. you will now update x records, are you sure you want to go ahead...bla bla, I would only like to see a message box with "X records updated" or "X records were locked, could not update". I can start by...

Hi, I have the following statement form my form TIME3_ONTIMER timer set at 750 (I have blinking fields, that need such small value for timer). If Forms!Time3.ActiveControl.NAME <> &quot;text9&quot; And Forms!Time3.ActiveControl.NAME <> &quot;SPECNOTE&quot; Then Forms!Time3.Text9.SetFocus...

Everytime I have to do some kind of BE updates, e.g. table updates (add new fields, change fields properties) I am unable tot do so because the BE is locked. I have to run around the building sutting down all front ends, in order to unlock the back end. I figured some kind of internal shutdown...

I need to write the following expression ++++++++++++ON TIMER+++++++++++++ VirtTime = 1 + VirtTime Select Case VirtTime Case Is = 4 If ME!NOTES &quot;does not have focus&quot; then TEXT0.SETFOCUS END IF END SELECT What would be the right code for this expression? Good luck, Kuzz...

On my form there is an OLEObject field in which I store a .zip file. I need to be able to do the following 2 things. At the click of a button I would like to copy the content of the OLEObject field to a predefined folder on the HDD at the click of a second button I would like to copy the file...

this is a portion of the code from my form ============================================ ' NEW JOBORDER If Text14 = &quot;STRT&quot; Then If Left(Text16, 2) = &quot;CI&quot; Or Left(Text16, 2) = &quot;CP&quot; Or Left(Text16, 2) = &quot;C2&quot; Or Left(Text16, 4) = &quot;PROT&quot; Or...

this is a portion of the code from my form ============================================ ' NEW JOBORDER If Text14 = &quot;STRT&quot; Then If Left(Text16, 2) = &quot;CI&quot; Or Left(Text16, 2) = &quot;CP&quot; Or Left(Text16, 2) = &quot;C2&quot; Or Left(Text16, 4) = &quot;PROT&quot; Or...