Search results for query: *

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

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

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

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

Hi, I have one image that I want to expand/show or collapse/hide some text boxes, labels of <td>, and button such as reset and submit. Can anyone help me please? Thanks. Regards, Sandra

Hi, I want to have my text boxes left aligned on the same column position, e.g. text box A on row 1 column 20, text box B on row 2 column 20, text box C on row 3 column 20. How to do this? Thanks a lot. Regards, Sandra

Hi, I have error message on every event I have in a single form, either it's a mouse move event or a mouse click event. The error message is: The expression On Mouse Move (in this case) you entered as the event property setting produced the following error: statement invalid outside Type block...

Hi, I have a M.Access database residing at the server at the office. If I have an ASP page stored at my ISP company's server (another city), how to access the Access database by using the ASP either with ADO or RDO or better suggestion? The reason for this is, to let users from anywhere to...

Hi, how to set Microsoft Access at the time the application is opened, ALL menu bars and toolbars are hidden. I ONLY need to show one toolbar, i.e. Compact and Repair Database. How to do this? Thanks. Regards, Sandra

Hi, I've created one query to filter record from three tables: -TblTitle (consists of books' title, subject, ISBN as the primary key); -TblTitlAuthor (consists of ISBN and Au_ID); -TblAuthor (consists of Au_ID, Author name). I have TblTitlAuthor because TblTitle and TblAuthor has many-to-many...

Hi, I have one combo box A that will show another combo box B when an item in combo box A is selected by the user. I set the code under combo box A_change(). The code will do the followings: 1.When user clicks one item in combo box A, it will look at the relevant table on the database and get...

Hi, I understand that Replication can help me in this scenario: -I have two separate offices A and B; -each month data in B needs to be sent to A for consolidation into A's database; -B needs to send &quot;only&quot; each month's data for consolidation purposes, not the &quot;WHOLE&quot; data in...

Hi, I have two places (A and B) that will use the same database (same application). On a regular basis, let's say place B will send data from all their tables they have at that time to place A for consolidation purposes into A's database. How to do this in VBA code? I want to create a form...

Hi all, I have a problem in sending out e-mail using MAPI. The message does go via Outlook Outbox folder and then Sent folder. However, it does not come to the recipient's e-mail address. Can anyone help me here please? The code is as shown below: Private Sub Form_Load()...

Hi, I have code running at client and server in one asp page. After the user fills in data in the form, the asp page will call itself and response.write &quot;thank you&quot;. How to append a close button below the line &quot;thank you&quot; and close the window? As you know the response...