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!

Register Log in
  • Congratulations derfloh 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: sandra45
  • Order by date
  1. sandra45

    Create Pivot Table & Export to Excel in VBA

    Hi, I've been searching for websites which give some ideas on how to create pivot table and export it to Excel by using VBA. Can anybody give me reference where I can find the tutorial or guideline? Thanks. Regards, Sandra
  2. sandra45

    Null Value QueryDefs Problem

    Hi all, thank you very much for your posts. Yes I want to have records based on parameter passed by users. If no value in any textboxes, then all records should be returned. I do use e.g. [test1] under row Criteria in QUERY qry_ALL, and this parameter [test1] will get value keyed in the...
  3. sandra45

    Null Value QueryDefs Problem

    Hi Jerry, does it mean I have to create new parameter for each parameter on the query? For example test1 parameter in QUERY qry_ALL. Thanks a lot. Regards, Sandra
  4. sandra45

    Null Value QueryDefs Problem

    Hi, another problem that I dont know how to solve, please help!!! I have a QUERY called qry_ALL, a FORM where the user puts in data to find records. I have 9 text boxes for user input in the FORM but of course not all text boxes will be filled in. The parameter value is null and I expect it...
  5. sandra45

    Populate List Box with QueryDefs

    Hi, thanks very much, it works fine and faster. I have another problem now, if the parameter is "" in this line of code e.g. qryQuote.Parameters!test = Me.NGOName error message will show up. Do you know how to deal with this? if one parameter is "", then the query will only look for record for...
  6. sandra45

    Populate List Box with QueryDefs

    Hi All, I need urgent help here. I need to populate a listbox based on data input by users. I have many textboxes for inputting the data by users. Then these data will be set as parameters for the QueryDef. Below code works fine but the problem is: it takes so long time to populate the...
  7. sandra45

    Empty Combo Box

    Hi all, I've found the problem, it's just the column width that I need to set to show the data, sorry for the inconvenience caused.
  8. sandra45

    Empty Combo Box

    Hi All, I've an Access 2000 form which consists of several combo boxes. Combo A will influence the data shown under Combo B. Combo C will influence Combo D, and so on. Strange things happen when I use "AddItem" in my VBA code for ComboA_change event. Combo B's rowsource type has been set to...
  9. sandra45

    Value Change from Several Input Text Boxes

    Hi, thanks a lot, it works great!!!
  10. sandra45

    Value Change from Several Input Text Boxes

    Hi, I want to change value of one input text box based on values changed from several input text boxes, can this be done? Let's say box A=8, if box B is changed to 1, value in box A=(8-1=7), and if box C is changed to 2, value in box A=(7-2=5) and so on. Can anyone tell me how to do this...
  11. sandra45

    Calculate Time Difference

    Hi, I have a form with 3 text input boxes let's say. Input 1 stores value of "clock in" time in the office; Input 2 stores value of "clock out" time in the office; Input 3 stores value of the difference between clock out and clock in time. Problem encountered: I can have correct differences...
  12. sandra45

    How to Obtain Value DISPLAYED on Screen

    Yes, this is what I'm currently doing. Thanks Chris. Regards, Sandra
  13. sandra45

    How to Obtain Value DISPLAYED on Screen

    Hi Chris, yes, I'm retrieving records from a database based on parameters submitted by the user, the records found then displayed on screen. Then the user has the option to convert displayed data to Excel if they want to. Instead of processing/retrieving data from server, I just think that...
  14. sandra45

    How to Obtain Value DISPLAYED on Screen

    Hi, I want to get the values displayed on screen and transfer it to Excel spreadsheet, however I don't know how to obtain those values directly from screen. For example values on screen: Name Age James 33 Nadia 25 Please help me, many thanks. Regards, Sandra
  15. sandra45

    Place Image on Other Image

    I expect to have about 30 submissions. Can you be more specific on what you mentioned here: creating the image for each submission and dynamically link to it from the server side? Regards, Sandra
  16. sandra45

    Place Image on Other Image

    There will be a form to input data, and when the user clicks the submit button, a circle will be added on a big rectangle on the web page. When another user visits the site and input data and clicks submit button, another circle will be added on the same rectangle. In the end, there will be...
  17. sandra45

    Place Image on Other Image

    Hi, I need big help here. I have two images, image 1 will be the shape of a rectangle, image 2 will be just a circle. On each click on submit button from a user, image 2 will be placed on image 1 on certain position x and y. When another user visits the site and clicks submit button, image 2...
  18. sandra45

    Load Graphics Triggered by Event

    Hi Jeff, thanks for your reply. At this moment I haven't got an agreed idea on the event and how the image will be shown. It might be that when the user has sent registration to the database, it will be the event to trigger the loading of the image on the "other" page. Each registration will...
  19. sandra45

    Load Graphics Triggered by Event

    Hi, is it possible to load graphics/image triggered by an event? For instance, picture A will be embedded to an html page if an event happens. Can anybody inform me how to do this? Thanks. Regards, Sandra
  20. sandra45

    Collapse Expand with Image

    Hi Simon, I still get the same error message. I've changed the code using div instead for all objects inside a form and it seems to work fine. However, does not work in Netscape 7.1 for the following codes: document.all document.getElementById document.layers[obj].visibility = 'visible' Any...

Part and Inventory Search

Back
Top