Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smithbr

    Need Help with form basics

    IS there any way you could be more specific as to how I should go about doing this. I am still a newbie with Access and this is my first time working for a form. Thanks
  2. smithbr

    Need Help with form basics

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

    Two listboxes

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

    Listbox in a form

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

    Simple Combobox question

    I finished it and got it to work using AP81's method. I was wonder what I needed to do if the items.txt file was located in another directory. Also, How should I split up the code if the textbox and add new item button are on a seperate form. Thank again for all the help.
  6. smithbr

    Simple Combobox question

    The combobox is NOT databound...it is simple full of 6 or 7 different options that can be added to a datagrid. I can get new items to add to the combobox but not save from use to use. I will try AP81's method when I get to work. Alhtough I have never used a textfile before. Thanks for all...
  7. smithbr

    Simple Combobox question

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

    I have a dataset that is filled bas

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

    Formatting Datagrid

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

    Insert command on the fritz

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

    project not closing completely

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

    Month occurred minus 1

    I can not get that to work...the Paid criteria is "Between [Enter Start Date] And [Enter End Date]" I think this is messing access up. If I input 7/1/03 and 7/30/03 as the start adn end dates.....I want the balnces for 6/2003...When ever I run it using the code you suggested, I get...
  13. smithbr

    Month occurred minus 1

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

    Hello again all, I just finished t

    ...lineseqno, itemnumber, quantity, unit price, and discount %. I also have a column that is created at run time called Total that is quantity * unit price. Now to my question: How can I either get the total column to update to the database even though it is not part of the dataset. (I...
  15. smithbr

    grandtotal for datagrid

    It worked....thanks
  16. smithbr

    grandtotal for datagrid

    I has hoping to create the grand total in a label....not in the datagrid at all.
  17. smithbr

    grandtotal for datagrid

    ...Then For Each dr In DSInvoice1.Tables(0).Rows dr.Item("Total") = ((dr.Item("QuantityShipped") * dr.Item("LastUnitPrice")) * (1 - dr.Item("DiscountP"))) Next grdcomm.DataSource = Nothing...
  18. smithbr

    Strange datagrid occurance

    It worked...I had teh data member set at design time but did not realize taht the code was essentially overriding it. Thanks a lot.
  19. smithbr

    Strange datagrid occurance

    ...Then For Each dr In DsInvoice1.Tables(0).Rows dr.Item("Total") = ((dr.Item("QuantityShipped") * dr.Item("LastUnitPrice")) * (1 - dr.Item("DiscountP"))) Next grdComm.DataSource = Nothing...
  20. smithbr

    Strange datagrid occurance

    I am sorry that I did not include that in my original post. I have the data source set the my dataset and teh data member set to the table. That is why I am so confused as to why it is doing this. I even started a whole new project and created a new datagrid and adapter, connection, etc. and...

Part and Inventory Search

Back
Top