Search results

How "ProjectID=" & "Forms!frmProjects!ProjectID" creates a valid 'where' clause is a bit over my head, but I completely agree that the fact that the error is intermittent and never occurs on my home network is VERY strange.

Good idea. I'll try it out. Thanks

Thanks for all of the input! I tried all of your suggestions. All of them generally were improvements. The ultimate culprit ended up being the " " around the form reference. Changing this: "Forms!frmProjects!ProjectID"to this: [Forms]![frmProjects]![ProjectID]Did the trick. Thanks again...

Colin, To check for MISSING references, where would I look for this? In design view where you would see the control source of a control?

Colin, All users have Office 365, which I believe updates itself. You bring up a good point regarding 32/64 bit. I developed the database with Access 2016 32 bit. I don't know what the users have on their machines. I need to check this.

pbaldy, Thanks for the reply, I tried recalculating just the control also, I should have mentioned that. At the end of the Nz function, I used "" instead of 0 because I didn't want to have a bunch of 0's on the form when there is no data. But I'll try 0 and see if that helps. I'll also...

I have a a form with many calculated controls on it. The form works perfectly. I recently split the database into front and back ends and installed it on a client's network. The front end is installed on each user's pc and the back end is on the server. However, when the users open the...

I have a report that looks perfect when opened with acViewPreview. I have added a button to the report so that the user can print directly from the report. I have also added a 'Close' button right below it. I have set the 'Display When' property of both buttons to 'Screen Only' so they won't...

Thanks JHB. I agree, the domain aggregate functions work, so why not keep them? I finally got it to work. Here is the new After Update code for frmExpensesSubCF: Dim AccID As Long Dim ExpID As Long With Forms!frmProjectsNew!frmIncomeSub.Form AccID = .AccrualID.Value ExpID...

Ahhh I see. You replaced it with: If Me.Dirty Then Me.Dirty=falseGood idea. The advantage with this approach is that it only saves the record if the value has actually changed, right? Thanks

JHB, What you did makes perfect sense. I would never have thought of that. I just noticed that you changed the On Current event of the main form. Again, this makes sense. I've been unsuccessfully experimenting with your code to see if I can get txtProjectExpenses and txtProjectNet (on main...

While I'm working on this, could anyone tell me if it is bad practice to use domain aggregate fields as I have on the main form? I always thought you shouldn't store values if you can calculate them but maybe I'm wrong on this

JHB, Thanks for looking at the database. I have just edited this post. Please disregard what I said previously! I see the funtion CalTheTotal() that you added. I also notice that you are storing the total in the underlying table. This works very well. I am going to see if I can apply this...

JHB, In the process of making the database "postable", I cleared out all the irrelevant database objects and deleted all the data. Then, when I was making some sample records, the append functionality worked fine for the first 2 records. After that, every time I tried to append the records...

MarkK and Ridders, I certainly understand your points. They are definitely valid and there probably is a better way to present this. Both of you obviously have far more experience with this than I do. No argument there. For the time being, I just want to get this one to function smoothly...

Thanks Ridders, these are good suggestions. Yes, changing the output to date seems to have done the trick. Wow. That's what I get for carelessly plugging in functions without checking them first. Yes, the function you mentioned is way too complicated. I'll clean that up also. There is no...

Apparently not! This is what I was wanting to know. See my attached screenshot. It says 'between' on mine. I have actually tried this on 2 different PC's and get the same results. I changed my system settings so that short date is M/d/yyyy as you have and I still get the same results...

Mark, I can understand how it could appear this way. However, this is exactly what the user wants. My initial version was more like you suggested but the user actually wants to see all of this data just like this. It gives him an overview of everything he wants to see at once and he can see...

I have been pulling my hair out over an issue where a form and report are not giving me correct info when determining if one date field is between 2 other date fields. :banghead: I thought my database had become corrupted but I can actually duplicate the behavior in another database. I have...

JHB, I'll clean it up and get it 'postable' as soon as possible. It's a bit of a mess right now. I was hoping someone might be able to point me in a direction, but I realize you probably need to actually see what's going on in the background to help with a solution. Thanks.