Search results

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...

Diagnoses is not being used anywhere, I just haven't deleted the field from the table yet. Code passes ID to referral form, and the referral form using the ID upon open from the open args. Unless I don't have a full understanding of subforms (which is more than likely), I don't want the...

Here's my current code. I'm getting tripped up in the amount of IF and ELSE clauses. I'm not clear on the order of operations. If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord If IsNewRecord = "Yes" Then AssessmentEndTime.Value = Time IsNewRecord = "No" DoCmd.RunCommand...

You're correct, it doesn't open to the same record, it creates a new record in another table based on the client's info in the original form. I'm doing this for reporting purposes. Yes, a client can have multiple referral records if they call multiple times. I'm not using multi-value fields...

Thanks, I checked out the link, but I'm still not clear how to use the Dirty property within a command button. The link you provided looks like it's using the Form dirty event. I want to assess the form's dirty property when the button is clicked and if it's dirty then X and if not, Y.

Thanks, I think this is what I'm looking for. I'm just not sure how to write that in a command button.