Recent content by cmray58

So Microsoft's workaround/solution is to perform these steps on the dozens of clients using the DB? Cool, cool. Lol

"In fact, you should only need to apply the Registry Hack to the server housing the back-end file. You do NOT need to apply the registry hack to each user’s PC. So basically, go onto the Server, open a Command Prompt and run the 3 lines provided in Microsoft’s article (above) and everything...

Thanks, that looks like it could be it. I'm a little confused about how to perform those steps when the backend file is stored on a server. I've asked our IT people to try it, since I presume they have access to the server machine itself.

What keeps causing this to occur? The solution seems to be just opening the backend file and it auto-repairs itself. But, how do I prevent this in the first place? I'm not sure what background info to provide, please ask away.

I'm trying to develop a query that provides a count of the number of records where a certain criteria is true for each field, individually. I.e., How many records where Field 1 = Yes How many records where Field 2 = Yes How many records where Field 3 = No etc... But, I don't want it to be...

GOT IT...I think. I had to remove the Before Update event, which was pulling the ClientID from the OpenArgs when it was a standalone form.

Right, agreed with both. Haven't removed those yet because again just trying to get the function right first. I haven't been clicking the Save and Close button on the referral form but instead using the Save action from the ribbon. I've tried a few different permutations and cannot get the...

Ah, yes. It was while entering a new record. Would I need to first have the new record in the main form save before entering in the subform? EDIT: I take that back. The new record is being saved, and I do see the relationship with referential integrity on. Not sure why it's not carrying the...

Thanks again. I'm attaching an updated copy of the DB. I've embedded the referral tracking form as a subform in CALS v2. They seem to be linked by ClientID. However, when you enter data in the referral subform, the data is saved in the referral table without recording the ClientID. Ignore the...

Hi June, I appreciate the continued support. Would you be able to summarize the steps you took to do both of the above? I'm not familiar with how to use the unbound method. This sounds like something that may work for me. I completely realize that this is by no means an ideal setup, but honestly...

Hello, revisiting this....I'm still unable to fix #ERROR

Thanks! I will take a look at this one and give it a shot. It will take me a little while to get to it, so don't think I've forgotten!

Hi everyone, I'm looking for a tutorial on how to build a search function/form. I have a main form that users input data into, but I'd like to build an easier way for them to search other than the embedded Access search field in the nav bar at the bottom. Essentially, I'd like the user to be...

Thanks...that is strange. It seems to be working now. Thank you for the help and patience.

Okay, backed up and took your advise. One step at a time, I arrived here: If Me.Dirty Then If MsgBox("Would you like to save and close the current assessment?", vbYesNo + vbQuestion) = vbYes Then If IsNewRecord = "Yes" Then AssessmentEndTime.Value = Time...