Search results

Hi CJ, I read that replication is one of the most complex features of Access. Do you think it's doable for a novice like myself? I couldn't really find a step-by-step guide for it. I don't think I quite understand how to split the db into front end and back end. Can you elaborate please? I...

Hi CJ, Hope you're doing well! We're finally starting to work with the db and there's going to be several people inputting data on the same copy of the program but on their own time and computers. If we would like to combine the data into one db, is there a way to do this? Thanks, Jim

Hi CJ, I changed the ID to text because some of the numbers start with a zero and Access wont let me do that as a number, but maybe there's a way. Re the DOA field, yes, sorry, I took out the DOA code for your copy only because my PI didn't want the completed db to be made public. Can I send...

Hi CJ, Thank you, changing the dataentry property to No did the trick. Re the navigation form, if I understand correctly, I will need to create a new form an add those several fields and somehow relate it to my other form? Could you provide an example please? Thx, Jim

Hi CJ, Yes, the table seems to already be a recordsource to the form but when I open the form a completely new blank form appears with no records to scroll to or from. The only time I can scroll through to another record on the form is when I enter more than one record on the form without...

Hi CJ, I'm back for more questions. I just can't seem to get enough of you! :) My question is on saving data in the form. Whenever I close the form after updating the fields and submitting the records, the data gets saved into the table but when I open the form again, the data is gone from...

Awesome. Thanks again! Jim

Hi CJ, Is this correct? For m = 5 To 5 SetControl Me("Test1Result" & k), Me.Test1Result1, (Nz(Me.Test1, "")) = "Stress ECG" SetControl Me("Test1Result" & k & "a"), Me.Test1Result1, (Nz(Me.Test1, "")) = "Stress ECG" SetControl Me("Test1Result" & k & "b")...

Hi CJ, Hope you're doing well! Really appreciate all the help you've so far. I'm still testing and making changes to the program but I've run into another problem I'm not sure how to fix. I've added this line of code to the SetVisible Sub: For k = 2 To 5 SetControl...

Hi CJ, Thanks! I know I've been taking way too much of your time lately so I'll try to refrain from asking too many questions. Regarding the conditional statement, I think I will use your suggestion for the if then statement. It seems to make more sense to me and it is working. Only problem...

Hi CJ, I would like the DOA field to be automatically selected a value when all other fields have been entered. So, the user should not be able to choose the DOA value but I think its field and value selected should be visible before the form is submitted. Hope this makes sense. Thx, Jim

Hi CJ, I'm unsure how to write my if statements into a select case statement. For example: if A=x and B=y then C=z How would I write this into a select case because doesn't the case handle only one variable (testexpression) at a time? Select [ Case ] testexpression [ Case...

Hi CJ, Hope you're doing well. I think I fixed the date issue. Looks like deleting the control and adding it back again did the trick! I was wondering how to add the conditional statement to the me.determination_of_appropriate.rowsource statement. You had completed a select case statement...

Hi CJ, I tried opening the db on a different computer but still encountered the same issue. I also tried doing the same with the last copy of the db you attached, but with no luck. It seems to work fine for the abstractenddate, and dateofabstract fields but not for the other dates like...

Hmm.. I closed Access and reopened it. The validation text is now popping up again. But the date field wont pass even if the condition is satisfied. I hope it's not my computer!

Yes, validation text. Hmm.. I checked the tags, SetVisible properties, and the validation text are all there. The conditions are also in the validation rule. I first entered the abstractstartdate and abstractenddate, then the [date of abstract] before plugging in for PCI_Date1. What else...

Oops. I meant the Validation Rule, not rowsource. It doesn't have a rowsource because it's a date value not a value list! I made some changes to the program and now it's not even giving me the error message. It's stuck on that date field. But I think before I made the changes it was giving...

Hi CJ, Thanks. I thought the .rowsource values can only be the values for the field. Didn't realize I can put the conditional statement in there! An an aside, I think I'm having problems w/ the dates again. Not sure why, but I have the conditions (>=[abstractstartdate] AND...

Hi CJ, Thank you, I've added your code. But I'm still unsure where to put the conditional statement. Should it be after the NextCtrl in form beforeupdate property? Regarding your comment: Do I add Determination_of_Appropriateness=null after every field that is part of the condition statement?

Hi CJ, I have one more field [determination of appropriation] that I need to populate. Currently it's a drop down list but I would like for it to be "set" one of three values according to what kind of values are selected in various fields on various tabs. I'm thinking of doing this with the...