Search results for query: *

Hello. I have a database to charges from vendors. We have three vendors, and all three send us a bill once a month. My DB has several tables. One for vendors which containg vendor id, address, etc. The other is for products. Each product is offered by only one vendor. This table has a product...

Hello. I have a form that is used to enter data. I would also like to use this form to enable the user to dynamically query the data. For example, if the user wanted to find every customer in New Orleans, the user would click the "clear" button, and the form would clear, and then in the City...

Hello. I have a strange request from my boss, and I cannot seem to figure it out. We have a db that we enter certain invoice information from vendors. We only receive one invoice per month. My boss wants to have two comboboxes on a form, one for the month, and one for the year. I am able to...

Hello. I have a db that is being used to track telephone charges for my company. We have two separate phone service providers, and we receive two consolidated bills per month. Each bill has over 50 phone lines (phone numbers) associated with it. I would like to set up a data entry form that...

I have a db with three tables. One table has employees, and consists of an employee id field, and some other demographic info. I have a product table that contains product id field, and product description field. I have the third table that links the product sold to the salesperson, as well as...

Hello, I have two csv files. One file contains all checks paid for a month. The second file has all checks that cleared the bank in the month. I am trying to create a report that shows only the checks that are outstanding, which means that they are in the first file, but not the second. I...

I have an excel file with 13 sheets/tabs. One sheet for each month, and one sheet as a "recap." The twelve monthly sheets are identical, except for the data contained within, but the layout is identical. On the recap sheet, I have a cell that is validated with a list containing the twelve...

Hello, I have one sheet that consists of four columns, and many rows. The first column has my different locations, and each location is listed only once. The second column contains daily sales for the period. Each row is has a value in the second column. The third column has a sum of the...

I have an excel sheet that has 12 ranges, one for each month. All of the ranges are on the same sheet. All ranges are identical, except for the data. I have a combobox that has the 12 months as the options. I am trying to write a function that populates cells on a "recap" sheet based on the...

Hello. I am trying to create a custom function that uses the offset function. I am creating this to eliminate some of the input parameters, which will allow the end users to only have to input two parameters (the rows and cols params). Here is my function: Public Function roff(x As Integer, y...

Hello, I am new to VBA, so please bear with me. I have an excel file with 13 different tabs. One for each month, and the last is a summary sheet. All of the monthly sheets are identical, except for the actual data in the cells. I want the summary sheet to combine and sum the information from...

Hello, I am using CR 9. I have created a report that lists all outstanding payroll checks. There is no grouping or subreports in the main report. The report consist of simply: check number, check date, and amount. The problem is when a check is voided, that check number is listed twice...

Hello. I have never written a loop formula befor in CR 9. I am working with a report that lists all of the checks written for a particular month and the various details. My system sometimes skips check number out of the blue, I don't know why. I would like to do something similar to a bank...

Hello. I have a created a budget report using CR 9 and this budget includes almost 100 different funds. My report is grouped by the different funds. I would like to create a table of contents that simply state the fund name and the page number that it starts on. I have tried creating...

Hello. I am trying to create a simple tic-tac-toe game as a learning experience. I am stuck on getting the computer to play "his turn." What I am trying to do is create a random number, and then loop through all of the buttons on the form that are empty, counting each empty button until the...

Hello. I am working with VB2005 and Sql Server 2005, both express versions. I have a simple table that contains four columns. Table name is "mytable" Column names are: "ssn","Last_Name","First_name", and "hire_date" I would like to do a mass import of all my 600 employees into this table. I...

Hello. I am working with VB2005 and Sql Server 2005, both express versions. I have a simple table that contains four columns. Table name is "mytable" Column names are: "ssn","Last_Name","First_name", and "hire_date" I would like to do a onetime mass import of all my 600 employees into this...

Hello. I have a masked textbox for a date (the mask is: 00/00/0000). I also have a buttn next to the textbox that when clicked will open up a monthcalendar. I am stuck as to how to return the value selected from the month calendar to the masked textbox. Here is what I have so far: Private Sub...

Hello. I am working with vb 2005 express and ms sql server 2005 db. I have a form with several textboxes and comboboxes, etc. I have a binding navigator that is working fine for flipping one by one through the dataset. I would like to add a button that would allow me to search the database...

Hello. I am trying to save my query results from Microsoft SQL Server to a text file. My code is working out perfectly, except I need to format the data elements. 'create the reader Dim reader As SqlDataReader = (sqlcommand.ExecuteReader) 'create the builder Dim sb As...