Search results

I created an example database in this thread that might get you started, although your solution will be a little different, because it will involve OnChange events for individual edit boxes of a form. And if the DataSource for the form isn't a database in the file, you have to store variables...

Search in Win 7 absolutely sucks for power users. MS should be ashamed of themselves for taking away needed functionality like that. While battling with this problem, I came across Agent Ransack. Problem solved, thanks to that program.

Here is a quick example, if you can open 2003 files in 2007. Do the blog entry using the blog form, *not* the table, because the table will accept any number for the user input--even numbers that aren't assigned to users! I could have made the user combo box display only the user name, but I...

Also, I recommend to store first name, middle name, and last name in individual fields, so you can sort them in any way you desire. If you want to display the full name of the people, create a query that contains the ID of the person, as well as a field something like this: PatientName...

Why don't you simply store the user's autonumber ID as a field in the blog entry? This allows you to look up their name, and, if you need to, change it later, without having to update bad text fields all over the place. It also keeps your database much smaller, and, believe it or not...

And now I feel even better! :) The amazing power of Mr. Smilie! Have a great weekend!

Thank you, Bob! That puts my mind at ease, as I really didn't look forward to recreating the front end. David

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

Thank you both! Have a great day!

Yes, that did it. A huge thanks! What does the '#' thingy tell Access to do, so I can understand it better? David

In the original database, the field is listed as 'Date/Time', with the 'Format' specified as 'Short Date'. The values show without a time ("i.e., 10/10/2009") Could the associated query be modifying this, and if so, how to modify it to compensate?

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

Off the top, one table for the rooms (which will consist of 6 records). One table for room bookings. One table for staff, and one table for subjects. The room bookings table will contain a field for: the IDs of the room booked room, the staff id, the subject id (although maybe not really...

First, it seems like 'Instructions' is a terrible name, but maybe I'm wrong. Is it really 'Projects?', or something of the like? Instructions to do what, exactly? As to your question, it is simple to do what you want. In your 'Instructions' table, use lookup fields to insert each of those...

This would be my first take on a solution to a similar, but much simpler problem. Others with more experience probably have better solutions. Open the VolumesForm, change some values, and press the button. Examine its OnClick event to see what is happening. This should help you understand...

Thanks! David

Thank you for the additional information. It helps make the code prettier, and that is always a worthy endeavor! I take it that "nz" comes from "Not Zero"? David

That's what I was missing. I wonder how many times that will bite me in the future. Thanks to both of you.

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

Thank you. Back to work for me...