Search results

Current record problem Many thanks for your reply. I checked the thread but my problem is different. I have a PhotoLink field that stores the path to the image. To add an image to the form I need to click on the "Add Image" button. This opens up the Browse Files dialog box and allows me...

I am building a small patient database. I have a field called imagepath that holds links to the images. This field is on my subform. So whenever I add new path/image in my form I am sent to my first record instead of staying on the current record. How this can be resolved? Many thanks, Debbie

Many thanks for your reply. I will try to do it. My next question is how to view these images in a report when few images are asssociated with one patient? Debbie

Hello, I have a small patient database and we would like to add a field to hold medical images related to each patient. For some patients we will have 2-3 images. What is the best way to do this? Many thanks, Debbie

Option Button Description table I would like to create a table containing description value of my option button group. This is my description table: tblLenkeDESC IDLenkeDesc LenkeDESC 1 Lenke 1 2 Lenke 2 3 Lenke 3 4 Lenke 4 5 Lenke 5 6 Lenke 6 And this is my table containing selected option...

Hello, I would like to populate a list on my form with dates from my date field, then by selecting a date I would like to be able to view report or query on the form. I would greatly appreciate your reply. Debbie

Please help with query/report. I have the following problem. One student evaluates course before and after. There is several questions related to this evaluation (all are same before and after) and for one question there is 5 possible answer (stored in option group) I would like to build a...

Here is the attachment. I had to compress it. Many thanks, Debbie

Here it is. Look at the subforms (SFrmCooperationAmongStudentBefore), last group, called TestField. Then test it in MainForm. I am working with student evaluation forms (before and after the course). I am also trying to figure out the following; One student evaluates course before and...

I have 2000 and 2003. Data is going to right place, just on the form doesn't show selection (it does in text field but not at the option group). Many thanks p.s. is there any other away to do this?

Actually it worked fine until I enter this code, when I remove it it wors fine again. Any suggestions?

I am using this event procedure on my form to convert option button numerical values into text. It works fine, text goes into the table, except on my form the option button don't look selected. Any suggestions please? Private Sub optSuccess_AfterUpdate() Select Case optSuccess Case 1...

Hello, I am not sure what cateogory to choose for this question but I would greatly appreciate your help. I have 5 buttons in my option group: 1. very often 2. often 3. occasionally 4. rarely 5. never I have to produce a report using description of each button in my report, not numeric value...

Hello, I am not sure what cateogory to choose for this question but I would greatly appreciate your help. I have 5 buttons in my option group: 1. very often 2. often 3. occasionally 4. rarely 5. never I have to produce a report using description of each button in my report, not numeric value...

Hello, Once I split up database into mde and mdb files is there a way to put them back togethere ? How can I turned linked table into table? I would greatly appreciate your reply. Debbie

Dear All, I have one very complex report based on a couple of crosstab queries. The column heading in my report has universities' names. Row columns are different cattegories. So, basically I need to have one more column in my report that summarize the data from the row, something like this...

Hello there, I am trying to create some report and I don't even know how to start. I have several tables. One contains universities' names and other 6 certain categories. Each of these 6 tables has at least 6 fields. So, my intention is to create a simple spreadsheet format. University...

Dear Jack and other, I was trying to implement your code but whatever I tried I always get this message "Invalid use of Null". I have a date field in each form. Instead of typing in the Year (I need only the year)I would like to have an option that date field is filled automatically by...

Hello, I am trying to do the following: by pressing the command button I would like to fill out the date field (only year). It is probably easy but please somobody help me. Deb

Thank you very much for your reply. In that case I would like to have some command botton on each form which would, on click, enter the year (only year) in date field. Can anyone suggest how can I do this. Thank you, Deb