Search results

Thanks!

Thanks! Got it working! It had been a while ago...

I know I've done this before, but can't quickly find the solution. How do I get the proper date out of a TextBox that has been formatted for dates? When using the following, the date simply shows up as "12:00:01 AM" rather than the "1/30/2024" text in the box. Dim enteredDate As String...

Thank you The_Doc_Man! Extremely informative!

My main concern was whether the 2GB limit was filled up by blank memory on each record containing a text field, or if it was optimized to just use the memory required for the actual text lengths. Thankfully, it seems to be the latter of these, unless you know conflicting information.

Thanks!

Doing some Access work again, and wanted to make sure I understand how memory is used in text records, in order to design a DB as efficiently as possible. If I am wrong in the following, please correct me. If I'm not wrong, let me know and I'll continue on my journey. Thanks! In Access, each...

Thanks for the replies - I got it working with a Topics table, a Subtopics table, and a TopicsAndSubtopics table, which holds a list of the active combinations, against which the information is recorded. It doesn't require a subtopic selection, so if that field is null the information shows as...

Thanks. I will think about this more. Maybe it will be most flexible to record information against the ID of the Topic/Subtopic combination table.

This is hopefully a quick question for those more knowledgeable than me. Say I am creating an information DB with 'Topics' and 'Subtopics'. A straightforward approach is one which has a Topics table, and another Subtopics table, with the subtopics being linked to the topics by their ID. Can...

[Solved it. See end.] I am putting together an information DB for keeping track of notes from books and periodicals. It consists of a 'SourcesTable,' a 'PeriodicalsTable,' and an 'AuthorsTable.' I am trying to get the sort for a combobox to correctly alphabetize. I created a 'SourcesQuery' to...

Sorry, I was wrong when I said it was based off a query. The report is simply designed to access and use the table. I don't believe it is easily possible to use update queries for the purposes the code was designed to. Perhaps I'm wrong on that count also. As an example, just this snippet...

This is almost a copy of a post I made from several months ago, with a little additional info, so sorry for the semi-duplication in a new subforum. The issue is that I have a button that executes VBA code to pull together data and then report it, but the report doesn't always update to the...

Yes, the two second delay I added lets the report totally refresh (at least in the one test I had time for). Thanks!

I never said I didn't put in some breakpoints. Thanks for the help! If you, or anyone else, sees anything that would cause records to disappear, my ears are open!

I will incorporate the approach used here, which uses both in what appears to be a non-CPU-intensive loop. Thanks, David

Thank you, I will give that a try (using sleep, instead of DoEvents). David

I have a button that executes VBA code to pull together data and then report it. The db is split, with the back end being on the network. Right now only myself and one other person use this system. I have a couple issues I'm looking for insight on. The report initially shows up blank, with...

Or by having the section in the Word document formatted so that 'returns' create properly justified new lines, and only spitting out new lines (Chr (13)) for each 'line' that exists in the address fields. This entails only having one bookmark, something like "ReturnAddress," rather than a...

Oops. I was being a bit dyslexic, because the 'OldValue' is not reflected correctly for unbound items, so it was worthless for my project, and I simply applied that 'worthless' across the board. But for the OP, they shouldn't care about the OldValue, so you are correct and it can be used...