Search results

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

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

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

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

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

I have a back end hosted on my machine for now, and a separate front end on all four office machines. When I go to link (or relink) the tables on the front end in Access 2003, in the linked table manager file popup where it is asking for the new file to link to, the window is blank, even though...

The problem I'm having is that dates aren't comparing as I expect them to. In the 'After Update' event of a text box (formatted as a short date) named 'DateBox', I'm trying to update a combo box's 'RowSource' so the user only sees the appropriate information per the other information on the...

I really want to just compare two strings and see if they are the same. Of course, the first thought is to write if str1 <> str2 then doStuffBut that won't work, because Access doesn't work that way. So I tried this: Dim temp As Variant temp = StrComp(freqBoxValue...

I'm looking at the ten commandments listed, and the second one says to never let users directly edit the tables. Should it be revised to state that you should never let the users access the tables with totally bound forms (if that is the right jargon to use)? The reason I'm asking is to know...

I'm trying to record visits to patients, and there will be five or so visit types. Right now I have a table of these visit types, and it works, but it is difficult to use. For instance, in code, to take action based upon a visit type requires the following, because I refuse to use the ID as a...