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 Rhinorhino 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. MarcMellor

    Why won't my Data1 Control work on an MDIForm?

    I am trying to put a Data1 control on an MDIForm linked to an Access database with a PictureBox control linked to a field in the database, but no picture appears and the Data1 control will not step through records. All this works fine on an ordinary form, so what am I doing wrong for the...
  2. MarcMellor

    Can I harness Windows XP text to speech facility using VB?

    I notice that Windows XP provides Microsoft Sam as a text to speech facility. It would be very useful for the educational program I am developing for pupils with reading difficulties to be able to press a button to get the text of a question read to them. Is there any way of harnessing XP's...
  3. MarcMellor

    How can I resize a Toolbar (AlignLeft) at runtime?

    I have a program that needs to resize as a proportion of ScreenHeight and ScreenWidth so that it is full screen on any resolution setting. I have two Toolbars on a MDIForm, one at the top and one on the left hand side. The top one resizes as a proportion using Toolbar1.ButtonHeight =...
  4. MarcMellor

    IS THERE A WAY TO DETERMINE THE CURRENT PRINTHEAD POSITION?

    I am using a PictureBox to contain some science questions that will be downloaded from a database. This allows to me to mix all sorts of text, tables and diagrams. I want to be able to print off all these in order with question numbers next to them. I can do this by placing 2 questions per page...
  5. MarcMellor

    HOW CAN I PRINT THE CONTENTS OF A MSHFLEXGRID?

    I need to be able to print the contents of a MSHFlexGrid. I can't find the syntax to do this. Also the MSHFlexGrid is on another form that will not be showing, will this cause any problems, ie will I have to filter and refresh the adodc data control on that form first? Lastly is there a way of...
  6. MarcMellor

    HOW CAN I RENAME AN ACCESS DATABASE FORM WITH VB?

    My problem is that I am using my first column as headings for the rows, ie like a spreadsheet. To introduce a UserID I really need a 3 dimentional version with each layer for a different user. I suppose I can add another 360 rows along with their UserId each time a new user registers but it...
  7. MarcMellor

    HOW CAN I RENAME AN ACCESS DATABASE FORM WITH VB?

    I have a template Access database form where both the rows and colunmns have headings and there are about 360 cells which will be filled by each user over time. Each user needs their own form, and I am only expecting small numbers of users (3 or 4 at most). I need to be able to 'open' the...
  8. MarcMellor

    How can I print the contents of a PictureBox?

    Thanks PGA, Works just fine!
  9. MarcMellor

    How can I print the contents of a PictureBox?

    I can't seem to print the contents of a picture box - I just get some numbers. Printing the contents of a TextBox works fine with Printer.Print Text1.Text so why doesn't Printer.Print Picture1.Picture or Printer.Print Picture1.Image work? Any ideas?
  10. MarcMellor

    How do I setup a new Access database from a template using VB?

    Thanks, Zemp, but I will need a separate table for each person because over time all of the records will get filled and they will all relate to one person only. This is because it builds up a score for each type of question(360 rows), answered correctly(fields), the total attempted...
  11. MarcMellor

    How do I setup a new Access database from a template using VB?

    I have a database table set up in Access as a Template, named "MyResults". It contains about 20 fields and 360 rows with empty records. When a new user registers, I want to be able to make a copy of this template and name it UserCode & "Results" so that when they log on the...
  12. MarcMellor

    How do I Print the contents of a PictureBox?

    I have a large number of science questions stored in an Access database as Long binary data (this allows me to use MSWord to combine a complex mixture of text and diagrams). These can be downloaded into a PictureBox according to parameters set up by the user. I want to be able to print the...
  13. MarcMellor

    HOW DO I GET AN ACCESS RECORD INTO A VARIABLE?

    I tried your suggestion, Onbleu, but exactly the same problem. I have some text boxes bound to the database temporarily so I can see what's going on. I've also got an MSFlexgrid control as COUNT doesn't seem to work without it. What seems to be happening is that the MoveLast takes us to the End...
  14. MarcMellor

    HOW DO I GET AN ACCESS RECORD INTO A VARIABLE?

    I want to select a group of records from an Access database according to certain criteria and then pick one at random and deposit the IDNumber (the Primary Key AutoNumber) in a variable to be used later. This is what I have so far: Data1.RecordSource = "SELECT * FROM QuestionsDatabase_...
  15. MarcMellor

    Why does Access AutoNumber mismatch with VB?

    Oops! Now I understand why all this complicated use of ' and " and & was needed! Unfortunately I'm still having a problem. My Data1.RecordSource Move NumberOfSteps is intended to put the QuestionID into a TextBox whose value can then be picked up with my RowNumber variable. I always get...
  16. MarcMellor

    Why does Access AutoNumber mismatch with VB?

    I need to download some questions from an Access database by selecting according to certain pre-chosen parameters and then pick one of these at random. QuestionID is the Primary Key AutoNumber in Access, RowNumber is the VB equivalent, QuestionLimit is the full count of questions under the...
  17. MarcMellor

    SSTab still giving me trouble

    SOLVED IT !!!!! (I'm back to that code, by the way, because it is the most elegant and none of the others resolved the problem any better anyway). It occured to me that if putting a refresh statement before the select statement made a difference to its operation, then perhaps it wasn't...
  18. MarcMellor

    SSTab still giving me trouble

    The problem with strTestString is that its like the MsgBox suggested by Foada above - and this does indeed work correctly at the very same time as the wrong selection from the database is showing. I have stuck "Module 1", "Module 2" etc into appropriate records in the...
  19. MarcMellor

    SSTab still giving me trouble

    Nope, Sivav and Strongm, both produce the same problem - starts out of step, skip a tab and your in step, do it again and your back out. And yours was so nice and elegant, Strongm .....
  20. MarcMellor

    SSTab still giving me trouble

    Tried your suggestion, foada, and got the same problem, so long as I stick to an orderly sequence - Module 1, 2, 3, 2, 1, 2, 3, 2, 1 it is a step behind. If I skip from Module 1 to 3 or the otherway round I can get it right and then its fine while I am back on the orderly sequence. Go off this...

Part and Inventory Search

Back
Top