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: *

  1. buzzboychicago

    How do i resize an external swf file that i'm playing?

    on button click i have this code on (release){ loadMovie("Contact_Us_Page.swf", "_root.ClipTarget"); play() } is it possible within that to say to resize it to a certain xscale and yscale how would i do that? any help is greatly appreciated! thanks
  2. buzzboychicago

    HTML table align="center" valign="middle" problem

    I'm using this code to center a flash object on an html page... (so that no matter how the window resizes it floats in the middle of the window both horizontally and vertically) it is centering it horizontally but valign "middle" doesn't seem to do anything. The ojbect stays glued to the top...
  3. buzzboychicago

    Access Report/ Images Missing when printing, What size should i use.

    I need to imbed a company logo into a report for labels. I have a couple questions. 1) What type of image file should I use for access reports? Jpeg? Gifs? etc. 2) What DPI should I use. I realize I can resize the image but I want to design it in Illustrator and I want to design it at the...
  4. buzzboychicago

    Access Report Preferred Image DPI and Type

    I am designing a lable report, and designing a logo in illustrator. What file type do I need to use for access? And most importantly, what DPI are access reports designed in? Every time I bring in an image its too big and causes the page to bloat.
  5. buzzboychicago

    Excel Macro Check for Null field

    On entry of data I need to check A1 through H1 to find the first null field. How would I do that programatically?
  6. buzzboychicago

    Excel, Check Fields with Macro VBA

    on entry of data I need to check A1 through H1 to find the first null field. How would I do that programatically?
  7. buzzboychicago

    Recordset

    Okay... I need to take a normalized table ID Item 23 Apples 23 Oranges 23 Bananas 24 Grapes 24 Kiwi and convert it to ID Order 23 Apples, Oranges, Bananas 24 Grapes, Kiwi The "Order" Field being an array with 1 or more items. Does...
  8. buzzboychicago

    Max of recordset (Recordset Newbie)

    Below is some code that I want to use to programatically add data to a table. However, where it says "Insert Calculated Field Here" I want to find the max of the INVOICERESEND table. Not sure what the syntax would be of if I have to use some sort of SQL statement. Private Sub...
  9. buzzboychicago

    String Email

    If I have a table that has and AccountID and an Item, and I have multiple items per account ID for instance Account ID Item 2453 ProductTypeA 2453 ProductTypeB 2453 ProductTypeC How do I get the list of those product types into an email string? I...
  10. buzzboychicago

    Sending Form data to query criteria...thread702-794545

    thread702-794545 is kind of what Im talking about. I have a small form with to date pickers... and have referenced those in the query... Between [Forms]![Form8]![StartDatePicker] And [Forms]![Form8]![EndDatePicker] If I open the query...the query does actually display records in respect to the...
  11. buzzboychicago

    SQL, Recordsets, Forms, Subforms...

    Hi, I am creating some dynamic forms and need to be able to query off of the data that is in the form including unbound fields. For example... I have a subform with a list of records that I want to export upon the click of a command button, but I only want to export the ones that have checks...
  12. buzzboychicago

    Running Totals/Billing/Access Subforms

    Okay Complicated Design Question... Lets say a customer signs up for a tek support allowance. They buy $600.00 worth of calls. Different Types of calls cost different amounts. Category A costs 20 Category B costs 30 Category C costs 40 However...if they exceed their allowance each...
  13. buzzboychicago

    Running Total In Subform with criteria

    Hi, I have an unbound field in a subform header that I want to have a running total in. Most people suggest using =Sum([Quantity] in the field source But, I'd only like the to be added if another field in that subform meets a certain criteria. Does anyone know a good way to go about this. If...
  14. buzzboychicago

    Security UserGroup Based Formatting...

    Does anyone know of a way or variable to call on that I can determine what group someone is in when the form loads. I have different buttons and I want a button to be grayed out if that option is not available to that person (which all depends on the security group they are in)
  15. buzzboychicago

    Copy File to Folder, add Hyperlink to record and other Details

    Hi. I have explored the hyperlink and the OLE object properties and from reading what other people encountered determined that I need to index records using the hyperlink method (so that the files aren't embedded needlessly in my database.) However. I don't know how to go about creating the...
  16. buzzboychicago

    Indexing PDFs and Word Documents

    I know in access you can have pictures that are stored in a folder and page through them. Is it possible to set up access with VBA to be able to attach specific pdfs or word files to a specific record? Anyone have any tips or threads regarding this?
  17. buzzboychicago

    Help with Batch File deployment of Access DB

    Okay, I am trying to write a batch file as many post have suggested to use to distribute and update copies of the latest frontend of my access database. The below post explains some of the coding. However, I am very new and have no idea where to even put that code. I tried creating a text...
  18. buzzboychicago

    Function to determine operating system...

    Does anyone know a way to get programatically determine whether a user is on XP, 2000, or 98? The application needs to be called differently from the two so I need to determine that at runtime. Thanks!!
  19. buzzboychicago

    Programming a subform like a message box.

    Okay, I know it might be complicated. But how would one go about making a form behave like a message box? For instance... If I have a close button on my bound form, and on the click event of close I make a subform popup giving the user checkbox options of "Save and Close" "Cancel Changes...
  20. buzzboychicago

    Securing Access Walkthrough...

    A while back I had found a link that walked you through setting up a new workgroup and setting up security for access. Does anyone happen to know the link? Thanks

Part and Inventory Search

Back
Top