Search results

I tried but it dosn't work. This is what I am doing: Results: Left(Nz([QuestionAnswer],0),InStr(Nz([QuestionAnswer],0),';')-1) Points: Right(Nz([QuestionAnswer],0),Len(Nz([QuestionAnswer],0))-InStr(Nz([QuestionAnswer],0),';')-1) Any suggestions Many thanks, Debbie

many thanks for your reply. It works perfectly. The only problem is if original field is blank I get error message in new field (the rest is populated correctly). Is there a solution for this? Many thanks, Debbie

I have a field in access database called result (coming from webform) and the content is something like: 'not much; 2' or 'frequently; 5'. How can I split numeric and text value into two separate columns in query? I will greatly appreciate any help. Debbie

Hello experts, I am trying to figure out how to send data from my webform into two access tables (tables have a relationship, linked by idname). This is my code and I can't figure out how to pass idname into my table2. <% ' Declaring variables Dim name, age, dateDB, QuestionOne...

Hello I have problems writing data from my webform to two tables. I am quiet sure that my insert into syntax is not correct. How to insert data into access database into 2 relational tables? This is my code: <% ' Declaring variables Dim name, age, dateDB, QuestionOne, data_source, con...

Many thanks, It works on current event

Keith, It is still not working. Is there a way to have autonumber on main form filled in on open? Deb

Hello, Thank you for your reply. I just tested it and it doesn't work. How can I ensure that someone first enter last name (to assign autonumber) before it moves to subform? Deb

Dear all, I would like my outnumber field to be populated on open event. This is because I have a subform on my main form and if someone starts entering data in sub form first then after that entering data on main form, after saving this record data on my sub form won’t be saved because the...

Works perfectly... Many thanks again. Deb

Hello, I can't it would be so confusing. I have to position it somewhere near the image control. This is a code I am using (on current on my subform) and I know I have to fix this line to count number of images related to each patient. Currently it count every entered image...

Hello, I have two forms: Main form [called frmPatient] (with patient data) and subform [called frmImages] (with images) Some patient might have 2 or more images. I would like to have record navigation bar on this subform to show how many images each patient have (example to show 1 of 3 and to...

Many thanks, it works... Deb

Dear Access Forum, I have 4 tabs and I would like after moving to new record to set focus on my first tab. Now what happen is if I am using my second tab and move to the next record the focus is still on the second tab of my new record? Any suggestions? Many thanks, Deb

Many thanks for all your help. But this last line didn't solve the problem. I still can't see an image until I move to the next or previous record???? Deb

Hello again, I commented out this line Forms![frmProperties].Form.Requery from on click event to add image and now is working but is not adding image to the image frame until I move to the next record? Any comment on this and also my previous question on tab focus. Very grateful for all your...

Hello, here is the code on click event to add image: Private Sub cmdAddImage_Click() On Error GoTo cmdAddImage_Err Dim strFilter As String Dim lngflags As Long Dim varFileName As Variant strFilter = "All Files (*.*)" & vbNullChar & "*.*" _ & vbNullChar & "All...

They are. I even tried putting everyting on one form and still keep sending me back to the first record after uploading image. Here is my module. It might be something wrong with it: Option Compare Database Option Explicit '. ' ADDITIONAL NOTES: ' ' This module only provides the Open/Save...

Hello, I tried, but nothing has changed?? This is driving my crazy. Also I have 4 tab buttons and I would like after moving to new record to set focus on my first tab. Now what happen is if I am using my second tab and move to the next record the focus is still on the second tab of my new...

Hello, Here is my function: Function setImagePath() Dim strImagePath As String On Error GoTo PictureNotAvailable strImagePath = Me.memProperyPhotoLink Me.memProperyPhotoLink.Locked = True Me.memProperyPhotoLink.Enabled = False Me.ImageFrame.Picture = strImagePath...