Recent content by sandra45

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

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

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

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

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

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

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.

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

Hi, thanks a lot, it works great!!!

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

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

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

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

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

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