Search results

Is this better than a PDF file for the code? Private Sub SearchFor_Change() 'Create a string (text) variable Dim vSearchString As String 'Populate the string variable with the text entered in the Text Box SearchFor vSearchString = SearchFor.Text 'Pass the value contained in the...

Thanks! I think I'm narrowing in on the problem. I've opened the Existing Client Search Page form, typed in the problematic lower case "i" and get a time run error message, as the attached file shows. (I whited out the address field to protect client confidentiality.) I don't get this message...

Unfortunately, I'm not very skilled with Access. I developed the db with help from a programmer who used visual basic and SQL for many functions; I focused on formatting and other property adjustments. Below is a screenshot of the form that is affected and a shot of the code that I think may...

To my knowledge there are no timer events built into the db.

Thanks for your response. When I enter a third character, it is placed correctly in the third position, but the second typed character remains in the first position, with the "i" having been bumped to second position. E.g, If I enter "ipr" the search box displays "pir"; if I type "Ipr" this is...

This may not be appropriate for this forum, but I'll give it a shot. I am the administrator for an MS Access 2016 database for our local food pantry. It's been working well for the past 6 years, except for one (minor) quirk: When a string of characters is entered into the search box to find a...

Hi Paul, Thanks for your quick and helpful reply. It worked like a charm. Happy New Year (you've already made mine start off happy), Cameron

A database at our Food Pantry needs to be updated yearly on Jan. 1 by eliminating all data in two fields: "ID Check Date" (date field) and "Signature Obtained" (check box). There are hundreds of records. Is there a way to remove the data from the two fields (columns) while retaining the fields...

I'm rather new to Access, so forgive my inexperience. I've just created a database for a food pantry to keep track of data on clients, their families and food deliveries. We need to produce monthly reports of activity as a requirement of our grant. I've designed the report and it works great...

Thanks, Big John. Your code fix works great. As suggested, I'll get smarter on Normalization. My source of Access knowledge 'til now has been Access 2007 for Dummies, a group to which I clearly belong. It is curious that the Dummies book does not include normalizing in its contents or index...

Hi John, Here is the zipped file (I hope). Also, would it be asking too much for you to help me figure out why when I fill out the New Client Data Entry form and save and close it, it does not add the new record to the first two tables? Thanks so much for your help. Cameron

John, I can send you the db (about 1MB) via Dropbox, but I need to have email or facebook contact info. Or, as an email attachment. Thanks for your help. Cameron

John, Thanks so much for leading me to the code that allows list box searches. The code works well, but I still can't get the found name in the SearchResults box to open the person's form on a double-click. In fact, the double-click produces no response. I've used the exact names provided in...

Please help me with a problem I'm having constructing a database for a local food pantry. As an Access 2007 beginner, I can't figure out how to link names of clients in a list box to the chosen Client Data Entry Form. My list box is in its own form, with its contents derived from the first...

Hi- I new to the forum and new to Access, so please forgive any transgression or lack of experience. I am constructing a db in Access 2007 for a local food pantry and am having a problem constructing a query that will return those records of clients who have picked up food in the last 30 days...