Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jpstroud
  • Content: Threads
  • Order by date
  1. jpstroud

    Fix for Procedure Declaration Does Not Match Description of Event...?

    I came across a problem this morning where my DB code would display the error: "The expression On Load you entered as the event property setting produced the following error: Procedure declartion does not match description of event or procedure having the same name." as described in post...
  2. jpstroud

    0x000005aa Insufficient Resources

    I'm attempting to help a friend with their computer and I'm at a loss as to the cause of the problem as I've never seen this before in Windows XP. Whenever we attempt to install drivers, software, (almost) anything, we get program hangs and end up having to quit the program. This is primarily...
  3. jpstroud

    Combine live data from two tables

    Actually, the header is a bit misleading. I need to duplicate specific data from the same table, while changing only specific data. Let me explain. I have a directory database that I maintain (note, I can NOT change the database structure - just the data) on a SQL server. I have made an access...
  4. jpstroud

    Referencing a field caption via VBA

    Is it possible to reference a field caption via VBA? I have a series of checkboxes with captions that I would like to compile into 3 different text boxes. Sample output would be similar to "Academic, Public, Special" when the options are Academic, Government, Public, and Special. There may be...
  5. jpstroud

    Spot colors on PSD images with transparency

    I'm not sure if others have noticed, but here's my problem. When working with greyscale images in InDesign (all PC versions, I started back with 1.5, CS now), you can apply a color swatch to the image to screen it. This can be a PMS color, or a CMYK swatch and affects both PSD and TIF files...
  6. jpstroud

    SQL Query suddenly stops working?

    I have an SQL query that I use to determine who is the director (or acting director) of a particular agency. The person with the lowest TeamID then lowest Ranking is who's in charge currently (this takes into account agencies who are between directors). Here is the current query: [code]...
  7. jpstroud

    Passing a control name as string

    Okay, I'm not sure why I'm having troubles with this, but I'll blame it on it being Friday :-) I'm attempting to pass the name of a control as a string to a subroutine elsewhere in the module. Unfortunately, I'm getting an "Object variable or With block variable not set" message when I try to...
  8. jpstroud

    Three in one?

    Hi folks. I'm pulling my hair out on this one. I am creating a database to keep track of product evaluations that come in. We have a table with evaluator info, one with product info, and one that stores the evaluations themselves (since the evaluator usually evaluates more than one product)...
  9. jpstroud

    Display "No Record" message on failed find

    Hey folks. I have some code that works fine, but I'd like to add more to it. Here is the code: Dim optArray As Variant, searchText As String, frmName, optValue As Object optArray = Array("Last_Name", "First_Name", "CertNo", "SSN") Set frmName = Forms("frm_CertifiedApplicants") Set...
  10. jpstroud

    Getting data based on min value of two fields

    I've got a tricky problem to deal with. First, some background: I work with a directory database. I didn't create the database, and it's VERY frowned upon when I make suggestions to change pieces of it. Needless to say, the database structure in fixed and I cannot change it. Nor am I allowed...
  11. jpstroud

    Text being cut in half

    Hi there. I've got a problem that's been bothering me for most of this week now. I have a large Access report of directory information, and everything works fine EXCEPT for the bottom-most piece of data. Access is fitting as much on the page as it can (I want this), however, this is leading to...

Part and Inventory Search

Back
Top