You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, download files, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
If you have any problems with the registration process or your account login, please contact contact us.
Free For All and Off TopicDiscuss everything here – cultures and recipes, general electronics and politics, the latest TV show or what kept you up late last
night - you decide. Just chat it up.
I'm just gonna chuck this out here, I hope no one minds too much.
I've been working on a VERY basic database for the last few days, which I am very close to completing, but I now have a nice dent in the wall, where I've been banging my head in frustartion due to the problem I've detailed below.
Using SprintDB Pro on my Ipaq, which can handle some SQL comments what I'm trying to do is....:
Program an on click event for a button control (called 'Select'.) that will take/copy/move some data in the form of a text string (e.g. "The client is advised to blah blah blah".) from an unbound edit box control (called 'txt_Com1') on a subform and place it into another edit box control (called 'txt_Review') which is bound to a table field called Poscom.
I'm looking to be able to select just one comment from a range of six comments, each comment is presented in a seperate edit box control, with all the controls on one subform there are also 6 comments per subject, with a total of approximately 15 subjects. Making a total of about 90 potential comments. The selected comment will then be reviewed and inserted on to the data capture form once it has been placed in to the edit box control (called 'txt_Review'.
I've already tried DBforums.com (no reply) and the Developer of SprintDB Pro (can't understand me/is too busy). So my options are limited.
If anyone can offer any help or point me to a more appropriate forum I'd be much obliged.
__________________ Afterism (n) - A concise, clever statement you don\'t think of until too late.
To err is human, but to really foul things up you need a computer.
Ok, keep in mind, I have never used sprint db before, but I think I get the gist of how to solve your problem. First, since I don't speak the sprint db language per se, what I would do given the parameters you've stated is to start at the bottom and work up. First to get your "select just one comment from a range of six comments, each comment is presented in a seperate edit box control" working...Is there an option for a drop-down where you could select the comment? If not, once again start at the bottom. Create a button for each of the 6 options. Once you get that working, then you'll at least have the hidden structure right, then you can work on the interface later.
Logically speaking, just a thought, I am not sure if you might be doing things backward. In other words you'll want to "nail down" the unchanging aspects of the database like if the 6 comments never change, then you can make them all solid variables that you can apply to each subject. If on the other hand the comments change, but the subjects stay the same, nail down the subjects to variables (button clicks, drop downs, etc.) and apply them to the ever changing comments. Like I said, it was just a thought.
Hey, I'm interested in knowing if I am even close to helping, if not, post your code then we can really get to work...
In a nut shell.
On the subform I've set up a cbo_box with a drop down list of the 15 subjects. Selecting one of the subjects populates the six edit boxes with comments regarding that particular subject.
I have command buttons next to each edit box with the intention of clicking the button and the text in the adjacent box gets inserted in to another edit box on a seperate (Main) form and so in to the data capture table. <- the only bit that doesn't work
Clicking on the command button also closes the subform and reopens the main form. I can then review my selection, edit it if necessary and then complete things by clicking on another command button, which will add a new record and things start over again for the next subject.
The comments are in edit boxes as some of them are quite lengthy, but less then 255 characters. So placing them in to a cbo is not really an option (No word wrapping option).
I have a VERY detailed e-mail with screen shots and the like if you'd like to take a look?
__________________ Afterism (n) - A concise, clever statement you don\'t think of until too late.
To err is human, but to really foul things up you need a computer.
Linear Mode
