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!

  • 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: *

  • Users: MikeCt
  • Content: Threads
  • Order by date
  1. MikeCt

    Setting desired column in datagridview to combobox,checkbox

    Hello I have a Datagridview which is populated from a sql query. The order of the columns and binding of the grid are handled at runtime. Problem is I cannot find a way to assign the combobox and checkbox to the columns I desire. In the example below column (1) and the last column share the...
  2. MikeCt

    Creating a relationship between to tables in the same database ( runtime )

    Hello I tried to make thing as simple as possible for clearity Fisrt I'm working in VB6 I have a simple form with a command buton on it The project has a reference to Microsoft DAO 3.6 Object Library There are 2 table in the database ( Patients ) & ( Medications ) Patients has 3 Fields (...
  3. MikeCt

    DAO Connect with VB2012

    hello I'm just starting to switch from VB6 to Visual studio 2012 - Visual basic for applications In the past i've always connected to my access databases with the code listed below changing the strSQL string to filter my tables. I tried to keep this simply and clear as possible with the...
  4. MikeCt

    WebBrowsers new url address

    I'm using VB6 and I have a form with a WebBrowser control and a command button Private Sub Form_Load() WebBrowser1.navigate "http://www.google.com/" End Sub Starting from google.com webpage, I begin my search Once I find the website needed I would like to save the url of this new page...
  5. MikeCt

    Programming in the future

    I've been programming with VB6 for quite some time. Problem is with the new windows operating systems( windows 7 & 8 ) I've been having a harder time getting them to run as smoothly. As much as I love VB6, I find I must start moving on if I want to run my applications in the future. Visual...
  6. MikeCt

    Testing for no value in a recordset field

    Hi I have a table with 5 fields Dates Date/Time User_1 Text User_2 Text User_3 Text User_4 Text When I use the statement below, my recordset consist of every date that has a value in all four of the user fields SELECT Dates,User_1,User_2,User_3,User_4...
  7. MikeCt

    Using KeyPress event with DateTimePicker Control

    Hi I have a form with 2 DateTimePickers controls, DTPicker(1) and DTPicker(2) I have the procedure below but the pressing of the return key does not trigger the event. If I press a number key the event is triggered. How can I detect if the return key is press if the keyPress event does not work...
  8. MikeCt

    DateTimePicker drop down calendar closure

    I'm using the DTPicker on my form. When the user enters a date that is is out of range I want to disable the DTPicker till the the user presses the "OK" button on the message that appears. Problem is the Date entry part of the DTPicker is disabled with DTPicker.enabled = False, but the drop...
  9. MikeCt

    Extracting values with decimal point from a text file

    Hi I trying to write a procedure that can extract numbers from a text file, then multiple that value * 2, then parse the new value back into the text file. Example of text file ( ORIGINAL ) N1G90G81X-5.75Y1.5Z-.25R.01F2.5 N2X-3.832Y.25 N3Y-1.916Y.35 N4X0Y.45 N5X1.916Y.55 N6X3.832Y.7546...
  10. MikeCt

    Filling multiple frames with option buttons at runtime

    Hi I know how to load controls at runtime, but now I would like to add a number of frames at runtime and then add (3) option buttons into each frame all at runtime. ( For each line of info on the form I need to select only 1 of 3 options ) Thanks Mike
  11. MikeCt

    Disabling the close form button

    Hi On a form there are the 3 buttons that control the form MinButton,MaxButton, and the close form button. Is there a way to disable the close form button at runtime? What event is triggered when this button is Pressed? Thanks Mike
  12. MikeCt

    Printing into paper form

    Hi I have a paper form that I need to fill in with data from the program I've written. I would like to print the form at the same time as filling in the data. I've been trying to find where to start but if I inquire about forms, I get info about building forms on the screen used with...
  13. MikeCt

    Problem with compiling program

    Hi I've finished my program which uses Access for it's database, I ran it before compiling it an EXE file and all worked perfect. I compiled it into an exe file and now when I try to retrive data from the access database I get the generic Microsoft error " (Name of Program) has encountered a...
  14. MikeCt

    Problem with closing a form

    I've written a procedure where one form opens another form using " frm_InventorySearch.Show vbModal " This second form collects user inputs then send back this data to the original form which performs a search to find the correct record. The correct file is located and the outcome is correct...
  15. MikeCt

    change event with Multiline textbox

    Hi I have 3 textboxes on my form named tbox1,tbox2 and tbox3. tbox1 and tbox2 have the multiline property set to false. tbox3 has the multiline property set to true. I tab down thru the textboxes not changing anything in the textboxes. I'm able to tab thru tbox1 & tbox2 without triggering the...
  16. MikeCt

    Waiting for a command button press

    Hi Is there any way to make a procedure wait till a command button is pressed ( Much like "ok" in a message box) Thanks Mike
  17. MikeCt

    Moving Cursor in textbox

    Hi Is there a way you can move the cursor past what is entered in the texbox so that any future typing will be added to what is already there. Private Sub Tbox_Brand_Change() If Trim(Tbox_Brand) <> "" Then If Len(Trim(Tbox_Brand)) = 1 Then Tbox_Brand = StrConv(Trim(Tbox_Brand)...
  18. MikeCt

    Testing a textbox entry for numbers only

    Hi Is there a way to test if a entry into a textbox contains only numbers, I would like to stay away from using a Masked edit box if possible. Private Sub Tbox_Price_LostFocus() If Tbox_Price <> ???? then Msgbox("Invalid entry, Please enter numbers only") end if End Sub Thank Mike
  19. MikeCt

    Testing for recordset opened

    Hi I would like to know if there is a way to test if a recordset is still open. I would like to place this in the form.unload procedure to be sure the recordset are closed on exit. This example give an error if the recordset has been previously closed If rsRs1.RecordCount > 0 Then...
  20. MikeCt

    Sendkeys with Windows 7

    Hi I've been using the following statement in my apps to trigger the tab key when the user presses the enter key. I use this to move from textbox to textbox with the use of the enter key for data entry. If KeyAscii = Asc(vbCrLf) Then SendKeys "{Tab}" I'm writing a new app for a new computer...

Part and Inventory Search

Back
Top