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...
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...
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 =...
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...
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...
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...
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...
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?
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...
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...
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...
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...
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_...
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...
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...
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...
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...
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 .....
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.