Search results

Oh wow, that is massively helpful. That does explain exactly what is happening. Sometimes I really wonder why somethings are set up the way they are in Access. XD For some reason that property was floating around in my head the other day when I looked at this, was wondering if it could be...

Thanks, I managed to fix it, but it's rather ineloquent. XD I'm not sure how to put this in meaningful terminology, but it appears that the Detail_Format() event performs all the code and then checks to see if it has run onto a new page. That's logical enough. When it happens to run over it...

Well this bit of information has definitely been helpful. I'm looking at the wrong cause of the problem because of that, but as you say, that's working as intended. The code seems to handle it fine. I guess my issue is something funny with the variable I'm using to hold the previous time, to...

Thanks for the reply. I'll give your format stuff a try tonight. I can tell you the actual time in question doesn't seem to matter. It's doing this only to the first record of a new page only. If you delete that record, the next one in line gets the same treatment, and then the code resumes...

Solved: Perplexing, becuase nothing was wrong with it. Even without the time data, the functions still work as intended. So no date problem after all. Doing tests with static values showed accurate results. The bug has something to do with the code logic keeping the previous time, and it...

Cool thanks.

That is strange, because I sent it from the one I'm working on, and I had it included from your earlier post. Maybe something awkward going on with the reference manager behind the scenes.

Thanks so much. ^_^ Going to give that resource a look.

Yeah it's acting strange again if I remove it. I readded it, and opened and closed, but I guess it isn't recognizing it still and the error is still happening. Maybe I have to fiddle around with loaded and closing stuff to get it whatever it is to see the reference. Weird. :banghead:

Wait a second, do you have to close and reopen the project for it to recognize when you add a new reference, or something to that effect? It's compiling now. I think the collection reference you told me to add is what it was. Because now that I reopened it from when I sent it to you, it is...

That's strange, the compile error I'm getting is when I go to the VB editor and Debug > Compile (Project Name) in the menu. That's when it tells me I have an undefined type. Do you know which function?

Sent you a ZShare link, hopefully that works. ;) Thanks for taking a look.

Sure I'll message it to you in a minute. It's just something I'm working for just keeping track of some stuff. I'd rather have it digital than write in a notebook. X)

Might it be an issue with RecordSet or what CurrentDB returns?

Aside from Collection and the three I made DataField, DataInterface, DataRecord Which just hold various pieces of information about records and performs methods on them. All the code works, just the not compiling now. Searching through all the project for "= new" doesn't return anything than...

It wasn't added. I just added it, but it continues with the same message. I'll dig through again and see if there aren't any other unreferenced objects.

The only outside objects I've used are Collections. The rest of the stuff is strings, integers, longs, etc. The standard stuff. Do you think I need some reference to the Collection class?

I'm getting the "User defined type not defined" error when I try to compile my VBA code in debug. The issue here though is that it doesn't point to anything. -_- I think I've narrowed it down to a class module I created, but I can't think of why this would throw this complaint. The code...

I have a not so standard report I'm creating that takes records that indicate a time range. I'd like to have these drawn out in graphs, but there aren't ready made solutions. I would like to achieve something like this: That's just a quick mockup I did with labels. So I was wondering if...

That shouldn't be the goal though. Discussions are about hacking down each others BS. It's how we audit one another, and improve our perspectives. Generally it's good for everybody involved. But yeah, if things becomes merely an ideological contest, then it's more about people wanting to...