Search:

Type: Posts; User: Mike54

Page 1 of 5 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    6
    Views
    791

    Re: Printing only selected pages

    It is a catalogue of helium balloons. Catalogue could be many pages long ( 10 -30 pages) but because perhaps only a few pages have changed I would only want to print those specific pages to save...
  2. Replies
    6
    Views
    791

    Re: Printing only selected pages

    Private Sub PrintDocument1_PrintPage(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintPageEventArgs) Handles PrintDocument1.PrintPage
    Dim Photo As Rectangle
    Dim...
  3. Replies
    6
    Views
    791

    Printing only selected pages

    I am trying to give the User the option to print only a range of pages from within an entire print but if I selected pages 2 to 2 it prints page 1 then overwrites it with page 2.

    Dim...
  4. Replies
    6
    Views
    960

    Save SQL image into a datatable

    I am selecting 3 columns from an SQL table, ItemCode, ItemName and Picture and creating a datatable. The first 2 columns are fine as they are strings and I understand by default datatable columns are...
  5. Replies
    10
    Views
    1,658

    VS 2019 Re: Fonts missing

    The problem was to do with the REGISTRY not being updated. The Fonts directory was full of unwanted fonts so I deleted most of them and then when I installed the font I needed, it did update the...
  6. Replies
    10
    Views
    1,658

    VS 2019 Re: Fonts missing

    Just tried that. Deleted the font and then installed the font rather than copying but exactly the same thing happens. Works OK till the PC is restarted then it fails again.
  7. Replies
    10
    Views
    1,658

    VS 2019 Re: Fonts missing

    To add to the mystery I can go into VS-tools-options-fonts and I can see the new fonts in the drop down list but they do not work if I select them. In other programs I can also see the new fonts but...
  8. Replies
    10
    Views
    1,658

    VS 2019 Re: Fonts missing

    VS is looking for more than just fonts that have changed because all the original fonts installed by Windows like Times Roman work fine.
  9. Replies
    10
    Views
    1,658

    VS 2019 Re: Fonts missing

    If I copy the font back in again to Windows\Fonts it will ask if I want to overwrite the existing file. If I answer YES it will work till the next restart. If I answer NO or copy any other different...
  10. Replies
    10
    Views
    1,658

    VS 2019 Re: Fonts missing

    That is correct. Every other program like MICROSOFT WORD or a graphics editor like GIMP are still able to use the added fonts. This leads me to believe it is likely to be a VS problem. I have googled...
  11. Replies
    10
    Views
    1,658

    VS 2019 [RESOLVED] Fonts missing

    I recently had to re-install Windows 10 on my PC and a program I use needed an additional font adding. When I first install the font into the Windows Font Directory it works fine but as soon as the...
  12. Replies
    9
    Views
    1,192

    VS 2010 Re: Dual monitor configuration

    Without wanting to get into a discussion as to why I needed to do this it was because I gave the program to my wife to test as an untrained user and the first thing she did was try and run it on a...
  13. Replies
    9
    Views
    1,192

    VS 2010 Dual monitor configuration

    I have written a program that utilizes 2 monitors if they are available. Is it possible to configure windows from within my Basic code to ensure the monitors run in extended screen mode rather than...
  14. Replies
    2
    Views
    1,612

    VS 2010 Creating & resizing a grid

    I have created a grid of 90 boxes (9 x 10) using labels Label01 - label90 and a border style of fixed single but when I switch to full screen mode the boxes no longer line up properly there are gaps...
  15. Replies
    13
    Views
    1,505

    VS 2010 Re: Checking if file present

    I've managed to crack this now. I am using Windows 7 and when you use windows explorer to view your files it shows a path C:\Users\Public\Public Documents\ but when you look through Dos Command the...
  16. Re: Hide column in DataGridView control

    set RowHeadersVisible = False
  17. Replies
    13
    Views
    1,505

    VS 2010 Re: Checking if file present

    When I check for a file using the following it works.


    If My.Computer.FileSystem.FileExists("c:\Users\Mike\My Documents\A00020.jpg") Then
    MsgBox("Found")
    Else
    ...
  18. Replies
    13
    Views
    1,505

    VS 2010 Re: Checking if file present

    This does seem to be a file permissions issue as if I move the file to the area C:\Users\Mike\ it then finds the file OK. Originally I created a directory under C:\Users\Public\ but the same problem...
  19. Replies
    13
    Views
    1,505

    VS 2010 Re: Checking if file present

    Is that not what I have already got?

    The Message boxes are only there to help me find out what is happening. If yours works and mine doesn't I am now even more confused.
  20. Replies
    13
    Views
    1,505

    VS 2010 [RESOLVED] Checking if file present

    I am trying to check and see if a file is already present on my computer before either deleting it or creating a new one. I am using the following code but it always returns "not found" even though I...
  21. Replies
    17
    Views
    1,704

    VS 2008 Re: Copying image to new sql table

    A size of 8000 worked.
  22. Replies
    17
    Views
    1,704

    VS 2008 Re: Copying image to new sql table

    I am now using the following:

    Dim table As New DataTable
    Using sourceAdapter As New SqlDataAdapter("SELECT * FROM ItemCodes", ReadConnString)
    'Leave each RowState as Added so...
  23. Replies
    17
    Views
    1,704

    VS 2008 Re: Copying image to new sql table

    Can I have that answer in English. I'm out of my depth here but need to get this completed tonight as the second PC must be returned.
    Please show me the correct coding as this is getting desperate.
  24. Replies
    17
    Views
    1,704

    VS 2008 Re: Copying image to new sql table

    Definitely ItemCode in both tables because I have been able to copy the other fields, it is only the image that has caused me problems.
    What I find interesting with the error message is the last bit...
  25. Replies
    17
    Views
    1,704

    VS 2008 Re: Copying image to new sql table

    I am now getting the error:

    The parameterized query '(@ItemCode varchar(8000),@ItemName varchar(8000),@Picture varbin' expects the parameter '@ItemCode', which was not supplied.


    Dim table...
  26. Replies
    17
    Views
    1,704

    VS 2008 Re: Copying image to new sql table

    As I said this is a one off so I used what seemed the easiest at the time. I already had coding which worked in another program.
    My question is why is my code not working not how was the best way I...
  27. Replies
    17
    Views
    1,704

    VS 2008 Copying image to new sql table

    I am trying to copy records from one sql table to another on a different PC. I am having difficulties with the image field. I know my method is not efficient but I only need to run this once so I...
  28. Replies
    2
    Views
    694

    VS 2008 Re: Copying date fields

    Thank you for that explanation. Using parameters and now working fine.
  29. Replies
    2
    Views
    694

    VS 2008 [RESOLVED] Copying date fields

    I am trying to copy the date field on one database to a date field on another but the date format keeps changing.
    The date field on the first database is showing as format dd/MM/yyyy which I copy...
  30. Replies
    1
    Views
    654

    VS 2010 Writing to remote SQL Database

    I am trying to use a database on one PC and run my Program on another. I am able to connect to the remote Database and read records from tables on it but when I try and add records to any of the...
  31. VS 2010 Re: Creating new table in SQL database, setting primary key

    Thanks guys, the following worked fine. Had also missed the ADD

    Dim connection As New SqlConnection(PubConnString)
    connection.Open()
    Dim objCmd As New SqlCommand("Create Table "...
  32. VS 2010 [RESOLVED] Creating new table in SQL database, setting primary key

    I am trying to create a new table in an SQL database. The table is creating fine but I cannot get it to set the field ID as the primary key and to auto increment.
    Using the following code:

    Dim...
  33. Replies
    2
    Views
    700

    VS 2010 If statement with variable operator

    Is it possible to build an IF statement with a variable operator?

    I have a requirement to allow the end user to select a field No. within a Datagridview, then select an operator from a Combobox...
  34. Replies
    8
    Views
    2,146

    SQL Select using column numbers

    Can you select rows from a table using SELECT * from TABLENAME where COLUMN NUMBER = X
    or do you have to use the column name? I have not been able to find the correct syntax if this is possible.
  35. VS 2010 Combobox to display above the selection box

    Can you make a combobox dropdownlist display the options available above the combobox rather than below it or is there a clue in the name 'dropdown'.
  36. Replies
    2
    Views
    668

    VS 2010 SQL Tables in to a Datagridview

    I want to load an SQL Database table into a Datagridview but because the table is selected from a combobox I cannot preset the datagridview. Is there an easy way of doing this or do I need to work...
  37. Replies
    11
    Views
    2,942

    VS 2010 Re: Rounding of negative numbers

    Math.truncate worked fine. Thank you
  38. Replies
    11
    Views
    2,942

    VS 2010 Re: Rounding of negative numbers

    Math.Round works fine down to -27.49 but once it gets to 27.50 or lower it rounds to -28. Perhaps I should be addressing this differently as basically all I want is the Integer value.

    i.e. 27.1 =...
  39. Replies
    11
    Views
    2,942

    VS 2010 [RESOLVED] Rounding of negative numbers

    Why does the following command give an answer of -28 not -27 as I expected.

    C = Int(-2705 / 100)

    I thought Int always rounded towards Zero. As the number being divided could be positive or...
  40. Replies
    1
    Views
    697

    VS 2010 [RESOLVED] Error opening SQL database

    I am trying to open a connection to an SQL database but keep getting an error, "Cannot open database" but SQL Server Management keeps showing "Login succeeded for user ...." I can access the database...
Results 1 to 40 of 199
Page 1 of 5 1 2 3 4



Click Here to Expand Forum to Full Width