Search results

Hi! In my report I have a lot of questions picked out from a table. Since they are picked out, they will not be numbered in order if I use QuestionID. I just want the numbers in front of each question to be in order, starting with 1. I guess there is a simple code I can put in my report almost...

Hi! I have a form with a long list of posts. The administrator of this form should be able to pick out just some (e.g 25) of the posts in the list and then make a report of the ones picked. I need good ideas how I can do this. And I'm not very good at this, so please keep it simple, thank you!

Hi I have a form where I have listed a lot of questions. I want to mark one of the questions, click a button, and that question moves over to another field. Is that possible? And if yes, how do I fix that?! Thanks!

I have this scoring query which compares a given answer with an actual answer (multiple choice test). IIf Actual Answer = Given Answer AS Correct and so on.... (The whole query is made by Mile O Phile) Is it possible to link this Correct data to the form? If the answer is right and the Correct...

I have two tables with the same fields and records in both. When a user updates one of the tables I want the new data to be automatically copied into the other table. Is it possible, i.e when the user exits the database or close the form? Regards, Kent

Hi! Is it possible to change the background on the optiongroup after the user has checked one box? I have a multiple choice form, and the user has to check off one box in the optiongroup before he goes to the next post. If he hits the right answer, I want the white 'field' in the background...

Hi! I'm trying to import a Random Selection Module made by Mile O Phile into another database, but get an error message: Compile error: User-defined type not defined I've tried to import the whole database into a new, empty one, but still get this error. What is wrong? Regards from the Rookie

I have some jpg's in a table, and tries to show them in a form. I've put in the control source and everything, but the picture will not come up in the form. Only a jpg-icon and the name of the file. Can someone help me? Regards, Kent

Somebody who can 'translate' this into a vb code? If Record = New Then Optiongroup = Null I want the optiongroup to be 'grey' every time I go to a new record (blank form), but not when I enter a form where the optiongroup already has been used.

Hi! I've made a query which counts a defined type of records in the table, and it works all fine. But when I try to put this result in a form, I just get an error in the textfield: #name? The SQL is something like this: [Query]![My control name] What is wrong?

Hi! I have a form with multiple choice question, and the user goes through all the questions by clicking a button which leads them to the next record (question). I just need a simple vb code which tells that the user has finished the last record. One code which gives a MsgBox with text and one...

Hi! I have a database where the user go through multliple choice questions, one question on each form. And the user can go through all the questions in the database. But I want to make a random 30 question test. Is that possible? Is it possible to program the database to pick out 30 random...

Hi! I have an optiongroup in a form, and a button which jumps to the next post. If the user forget to mark the optiongroup, I want a a popup when he press the button. I guess it will be an if- else sentence in vba? I'm not in to vba, so I need some help with this code. Thx!

Hi I have a 'start menu' on my database. In the bottom of this menu I would like to tell when the database was last updated. Is it possible? Not when the database was last visited, but when some of the fields in the table were updated. BR, Kent Endresen

Hi I have reset all the post in the table, and I use Autonumber on the posts. How can I reset this so that the new post will get number 1 and not number 'next after the posts I deleted'? BR, Kent Endresen

I've made a Input Box where dedicated users have to type in a password. But when the password is typed, it comes in plain text. How can I change the code so that there will be a mask on the password field? The code I have now is: ... strInput = InputBox(Prompt:=strMsg, Title:="Protected Area")...

Is it possible to find open source access databases on the web? I'm supposed to make a database, but I will not be able to do it due to lack of skills and time... BR, Kent

Hi! I have a Form with some textboxes and a Option Group. Is it possible to make a button that blanks out all the boxes, if the user wants to start over on that post?

Is it possible to have Temporarily Posts in a Table, which can be automatically deleted when the user exits the database? Example: I've made a multiple choice Form where the user can mark of one of the options in the Option Group. The option which is chosen, returns a value in a Post in the...

I've made a main menu, and the user can navigate to different forms from the menu. I want some of the forms to be password-protected, is that possible? How do I make a password dialog box? I'm a rookie! ;o) Thx!