Search:

Type: Posts; User: kutlesh

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Can Access export a report data to an editable Access table or to Excel file?

    We often need to edit the data in a report, but the Access report contains formatting which interferes with data editing in Excel. Also if you try to copy the report directly from its page in Access...
  2. Re: How to display the left panel with tables, queries, forms etc in Access 2017

    Nobody understands the question?

    The panel where the tables, forms, queries, reports are listed. How do I show it, so I can use it?

    What option do I select in options?
  3. How to display the left panel with tables, queries, forms etc in Access 2017

    In Access 2000 it was a single button that displayed the window with all available objects in Access database. However Access 2017 is a Microsoft riddle.

    Can somebody tell me how to see my tables,...
  4. Is it possible to export Access queries to the outside world auto?

    We work here with alot of data and we must make sure that the data has good quality, meaning, data passes all validation rules.

    We have many Access 2000 (mdb) and no Access 2017 (accdb) files...
  5. Re: How to resolve name of linked table in Access 2000 with VB6 code?

    Tables exist originally in MS SQL Server, and people here tend to link them as ODBC data-sources with an Access 2000 table name, not necessarily same as the name of the table in SQL Server, which...
  6. How to resolve name of linked table in Access 2000 with VB6 code?

    Hello. We make new tables each year with same structure but slightly different table data in MS SQl Server.
    So if the table is called, MY_TABLE_2021, for this year it will be called MY_TABLE_2022....
  7. Re: Why do I get error "Unexpected error number 80040154: Class not registered"

    I used third party tool to build installed for Win10. Didn't even bother anymore with P&D Wizard.
    Was it Inno Setup
    You have a build script and you modify it to suit your needs.

    You can also...
  8. Replies
    18
    Views
    11,446

    Re: Convert VBA and VB6 code to C# or VB.NET?

    Yes I mixed two questions. Probably more appropriate is to upgrade old Access 2000 apps to the new Access 16.

    EDIT:

    Hmm, why I bother so much. Just upgrade the old apps in new Access.

    I...
  9. Replies
    18
    Views
    11,446

    Re: Convert VBA and VB6 code to C# or VB.NET?

    Yeess, we have lot of legacy code, made in VBA and Access 2000. Yes its easy to say, never use Access...
  10. Replies
    18
    Views
    11,446

    Re: Convert VBA and VB6 code to C# or VB.NET?

    Yes we have new Access, 365 or that version 16, whatever.
    Is it painless to import old Access code to new? Have somebody tried it?
  11. Replies
    18
    Views
    11,446

    Convert VBA and VB6 code to C# or VB.NET?

    Is there rather painless way to convert old VB6 or Access 2000 VBA code to C# or VB.NET?

    Any tutorials on the topic?
  12. Re: Which exceptions get thrown by ADODB.RecordSet methods?

    A leftover from a legacy applications.
  13. Which exceptions get thrown by ADODB.RecordSet methods?

    Which exceptions get thrown by ADODB.RecordSet methods, for example Open() method in VB.NET?

    Also can you name exceptions of other important methods?
  14. Replies
    1
    Views
    1,488

    Learning MSBuild?

    I was wondering if somebody tried this course on pluralsight:...
  15. Re: I got links for free ebooks for my birthday but none works...

    Yes, that is the email :)
    But the links don't work
  16. I got links for free ebooks for my birthday but none works...

    Hmm, I got a mail by your site for my birthday but none of the links work.
    Is this april fools joke? :p :D

    Happy new year everybody :wave:
  17. System libraries that Access 2000 is using to run VBA, macros, etc...?

    We have lot of Access 2000 applications that contain VBA, Expression Builder rules, Access reports, macros, queries etc...

    Though we have licensed VB6 IDE and recently switched to Windows 10 on...
  18. Re: Proper way to move trough a WinForms form automatically or pressing Enter when ne

    Nice example of using validating. However it doesn't cover automatic jumping to next control. I tried something like:



    Private Sub MaskedTextBox1_KeyUp(sender As Object, e As KeyEventArgs)...
  19. Replies
    17
    Views
    7,121

    Re: Proper way to use Validating event

    So how can I set the damn thing not to show the messagebox twice one after the other???
  20. Replies
    17
    Views
    7,121

    Re: Proper way to use Validating event

    Lol, so tricky to make it work... why it shows the same MessageBox twice, one after the other?

    First validate event called when the field looses focus, and the second when called...
  21. Replies
    17
    Views
    7,121

    Re: Proper way to use Validating event

    Yes that does make a difference. And yes I guessed it right, the MessageBox should be of type OKCancel ;)
    Now the bottom left "Cancel" button on the form seems unnecessary. Or is it?
  22. Replies
    17
    Views
    7,121

    Re: Proper way to use Validating event

    Yes, pressing cancel or OK won't allow closing the form. Also form "X" button fires validating and doesn't allow me to close the form.
    Only when I input value in the required range, I can close the...
  23. Proper way to move trough a WinForms form automatically or pressing Enter when needed

    A form consists of around 40 fields and many of them are masked text boxes, limited to receive only numbers. There are also few combo boxes until you fill all the fields with data and eventually...
  24. Replies
    17
    Views
    7,121

    Re: Proper way to use Validating event

    Coded a form like this:

    173177

    The day text field has CausesValidation set to true and here is the code behind:



    Public Class Form4
    Private Sub MaskedTextBox1_Validating(sender As...
  25. Replies
    17
    Views
    7,121

    Re: Proper way to use Validating event

    :) Yes, I don't use Convert.ToInt32() since it throws exception in my actual application. I have built my own function that returns -1 if the conversion to positive integer fails or the actual...
  26. VS 2005 Re: Combobox stays in blue once the focus is moved to other field?

    By documentation, do you consider MSDN on WinForms? We have a CD of MSDN but I don't have it installed.
    Or you have some docs on this site about WinForms mechanism?
    Or maybe this...
  27. Replies
    17
    Views
    7,121

    Re: Proper way to use Validating event

    What do you mean by Cancel button? Show message box with Ok/Cancel buttons?

    Also validating event doesn't get called if I set CausesValidation to false. Do I miss something?

    Made a sample code...
  28. VS 2005 Re: Combobox stays in blue once the focus is moved to other field?

    Didn't know that, but thanks for the advice.

    I should be using TabIndex and SendKeys to move trough the form?
  29. VS 2005 Combobox stays in blue once the focus is moved to other field?

    Not sure what is the problem here, I have few combo boxes which

    drop down style is DropDown,
    AutoCompleteMode is SuggestAppend
    AutoCompleteSource is ListItems

    Though I explicitly move the...
  30. Re: Keyboard button that doesn't change value in ComboBox when pressed.

    Not sure what it does but certainly works:



    Private Sub ComboBox1_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles ComboBox1.KeyDown
    If...
  31. Re: Keyboard button that doesn't change value in ComboBox when pressed.

    Turns out, my combo boxes are of style "DropDownList" which doesn't allow typing in the combo box field and only items in the collection are allowed for selection.

    If I set it to style...
  32. Re: Keyboard button that doesn't change value in ComboBox when pressed.

    Hmm, is there a difference between Visual Studio 2019 and 2005?
    Because on my home PC I have VS 2019 and Left arrow key when using this code:



    Private Sub ComboBox1_KeyDown(sender As Object,...
  33. Re: Keyboard button that doesn't change value in ComboBox when pressed.

    I actually tried with Left arrow key which didn't change the value of the combobox while PageUp did jump to previous field but still changed the value of ComboBox.

    Hmm



    Private Sub...
  34. Re: Keyboard button that doesn't change value in ComboBox when pressed.

    How to reprogram different button, like say, Space or Left arrow key or PageUp so that it works like Shift + Tab and go back one field in the list of form fields?

    Should it be on KeyDown?


    ...
  35. Replies
    17
    Views
    7,121

    Proper way to use Validating event

    I was working on old VB6 apps, and yes there were validating events which couldn't even allow the user to close the application using the "X" button at the top of the window.

    Though VB.NET also...
  36. Re: Keyboard button that doesn't change value in ComboBox when pressed.

    Yes, perhaps that should work. Ok will check the tab indexes.

    Should it be



    Private Sub cboPol_KeyDown(ByVal eventSender As System.Object, ByVal eventArgs As...
  37. Keyboard button that doesn't change value in ComboBox when pressed.

    I have a VB.NET application and it is for data entry. There are several ComboBox components and only recently I changed going backwards trough the form with Left arrow to PageUp, since pressing...
  38. What marks xls document as malicious when oppened in Excel 16?

    I collect data trough Excel document(xls, Excel 2000) and there are like 300 people across the country who fill these excel files and send them to me.

    I have an Access 2000 application that reads...
  39. Re: How to deploy application to a network disk location with MSBuild?

    Nobody knows anything on the topic or its a dumb question?
  40. Replies
    36
    Views
    3,150

    Re: Do you drink beer?

    She looked like Pamela Anderson after nine Coronas :bigyello: :p

    I have to also agree that I don't like Amstel and Heineken. But Carlsberg and Kromabacher are my fav for now.

    She looked like...
Results 1 to 40 of 237
Page 1 of 6 1 2 3 4



Click Here to Expand Forum to Full Width