Search results for query: *

Hi I have a html form that I am calling an asp form from and I can't get the fields into the database. I'm not sure if I'm missing part of the needed code. <% @ Language="VBScript"%> <% ' Declaring variables Dim PlayerName, BDate, Grade, Address, City, Zip, Email, School, District, HPhone...

I am working on a VB6 project and I am trying to export fields from a listbox into a csv file. I can get the titles to export but none of the actual content from the listbox is being exported to the newly created csv file. Is there something missing in my code that can is suppose to be there to...

I am creating an windows application using vb.net 2005, and I have a parent form which I want to be able to load various child forms onto depending on which one the user selects. I have the form created and the child forms created and they display on the parent form. I am running into an issue...

I am working in VB6 I have a form that contains a text box and I need to see if the user has ended the entry with a "\" and if not I will need to add it to the end of the users entry into the text box programmatically. I am wondering how this can be done, I am attempting to use the Right...

I have a vb6 application where I am trying to change the form size and the form controls based on the users screen resolution. I have gotten the size of the form to change based on the screen resolution but the controls are staying the same size. Can anyone help me figure this out. Here is what...

I have two excel spreadsheets that I need to combine based on a specific column value. I am trying to add price totals for the inventory information that is on one sheet while the pricing is listed on another sheet. I need the pricing information to be listed in the appropriate row based on...

Hi I was wondering is there a way to update a field in an excel spreadsheet, like can be done using the update query in access. I have a spreadsheet that contains a column that has a couple values that need to be updated to the new account number so it can the values can be linked between...

I have an excel spreadsheet that contains many records and I was wondering is there a way to do an Update Query in excel like can be done in Access to update a couple values from a column.

I am trying to automate a process in order to make a monthly routine less time consuming. I have an Excel spreadsheet and an Access database. The spreadsheet contains formulas that calculate values for different fields based on values that are in other fields. The calculation all starts with the...

Okay I have a database that contains records of billing information. I have created the queries I need to display the information but my issue is, is there a way to take the total values that are being produced from the query and separating them depending on amount for instance 0-30, 30-60...

I was wondering if it was possible to use a combo box to a blank spreadsheet that contained the name of all tabs in a worksheet. When you select a tab name out the combo box that sheet would open.

I was wondering can bookmarks be added to Microsoft Excel spreadsheets so that you can have an index tab that will list all the tabs that are included in the worksheet. Similar to the bookmarks that can be created in Microsoft Word.

I have this excel spreadsheet that is linked to another spreadsheet. I was wondering is there a way to programmatically hide or delete blank rows on the excel spreadsheet. So the spreadsheet will only show rows that contain values. Okay is there a way to do this so automatically once a...

I have this excel spreadsheet that is linked to another spreadsheet. I was wondering is there a way to programmatically hide or delete blank rows on the excel spreadsheet. So the spreadsheet will only show rows that contain values.

I have results of a query that I exported into excel from access that I need to have be able to display in an excel worksheet in particular fields. Where I am running into trouble is how can I have the values from multiple columns populate one column in the formatted spreadsheet that I need to...

Is there any special syntax that needs to be used when trying to use the Format Function in VBA code.

I have a query that produces this output and I want to be able to get the sum of a field based on the Account & Subaccount matching. Here is what the query result looks like. Account Subaccount AcctDesc SumOfGross Check Date 60110 0100 ...... 4160 9/7/2007 60110...

I have a query that runs based on which fields are selected on a form. I was wondering is there anyway to number the records {Starting with 1 and incrementing for each record resulting from the query}

I am trying to send the results of a query that runs when a button is clicked on a form. Originally I used teh DoCmd.TransferSpreadsheet to export the information but I was informed that by using the DoCmd.TransferSpreadsheet method you are unable to dictate which fields records should go to so...

Does anyone know of a way to export an access queries result set into an Excel spreadsheet that I have created.