Search results for query: *

Hey guys, I have a simple question that I was hoping someone could help me out with. I have a couple of tables,a query,a report, and a form. I want to use the form in such a way that the user selects a associate from a combobox(cboName)(populated with data from tblAssociate) and that...

Hey guys, I am editing a form that has a listbox populated with all the employees. The user selects a person, and clicks a button and is shown a report of all that person job duties. I now want to be able to go in and change the job duties and descriptions without having to go directly into...

I have what I know is probably one of the simplest questions in the world for all you guys here at Tek-Tips but I can not find the answer in access help for some reason so I thought I would go to the pros. I have a parameter query where the user types in the associate's name for the data they...

I have a combobox that I want the user to be able to update if it does not contai a choice he needs. I tried to use this code: cbotype.Items.Add(txtcboadd.Text) It would add the needed choice but only for tht session, once i closed the program it would disappear. Is there any way to save it...

I have a dataset that is filled based on the parameter of the invoice number entered. I want to to display the info from the dataset in a more concide fashion than it is generated. Below is a sample dataset. COMM PRODUCT INV# BROKER TOTAL DATE 0.02 0074 30202 INSI (null) 5/2/2003 0.03...

Does anyone know if it is possible to remove that default blank row at the bottom o fthe datagrid without lossing the ability to add new records. ( I add new records through textboxes and want to take the ability of the user to add through that bottom row). Also, is it possible to remove the...

I have an add button on my windows form that sometimes works and sometimes does not. Sometimes if I quickly double click it will add the new record, other times it just takes on normal click, still other times it will not insert the new reord at all. Does anyone knwo why this might be...

I have a vb.net application that contains 2 forms. When I try to close the project, the form disappears, but the projct is still running....I have to hi tthe stop button to close it out all the way. Here is the code I have to get to form2 and back to form1: 'To form2 Private Sub...

I have a query set up right now that pulls commission information for a data range the user types in through start and end dates. Now, I want to show in the query the previous balance for the broker...(each month, the balance is stored by broker, date, and balance) Essentially I need to find...

Hello again all, I just finished this VB.net program I was working on and started testing it when I noticed a huge hole in it that some how I missed from the beginning. I have a datagrid that is filled based on a access DB. The columns that are in the datagrid include: lineseqno, itemnumber...

Hello again, I have read that it is not possible to get a grand total ina datagrid. (adding all the rows of a particular column) I was wondering though, is it possible to find teh grand total another way an display it in a label somewhere on the form. The column I want to total is one that...

Hello all, I have a strange question about a datagrid I created at design time in VB.net. For some reason or another, my dtagrid displays as if it is part of parent child table. When I fill the datagrid, the datagrid closes almost and I have to click on the + in the upper left hand corner adn...

Hello all, I have a question about ms access reports. I have a report that is groups the records by broker. The report automatically starts a new page after each broker. Now, I have a page number on the bottom of the report, but I would really like to have the report display the number of...

I have a datagrid i am trying to update and need to know a way I can get it to only update those fields that have nothing in tehm...I have it written now as dr.Item("Paid") = "" but this is not working....how else can I write this so it works?

I am have a horrible time trying to get this update to work correctly in my datagrid. I had it working yesterday and when i came in this morning it would not function right. I am trying to get the datagrid to add today's date (through lbltdatedisp label)to the paid column in my datagrid. I...

I am having a problem inserting data into a database. I had it working yesterday and when I can in today it would not work. It works sometimes when i click the add button twice real quick but does not work if I only click it once or twice slowly. Does anyone see anything in my code that I...

hello all, Does anyone know how to make it so that a column that is calculated will base its calculation on which of two radio buttons is checked. IF yes is check I want the calculation to take the discount off the total, if no is checked I do not wan tit to take the discount off the total...

I have a datagrid set up and have a the last column set up as a calculated entity. I want to know how I can hide a column so it does not show up inthe datagrid but is still in teh dataset so it can be used in the calculation. Brent

I have a couple of questions about a project I am working on involving an access database and a vb.net windows form. I have an Access Database that is used to keep track of brokers commissions. On a form, I display the line items from a particular invoice (based on the invoice number typed...

Hello all, I have been trying to figure out how to get a datagrid to work for way too long now and have made no progress. I have tried to st up at design time and programatically. I think I would rather do it programatically, partially so that I can see what happens and will be able to...