Search results for query: *

I found the answer to my own problem. Instead of referencing the input box directly in my SQL statement, I set up a string variable and assigned it to that. Dim stNoteBox as String stNoteBox = [InputtingTextBox] Then, I also applied the replace command to allow people to put a ' in their...

I have a global notes file in my system for the users to type any comments they want in any area, and the program saves as much linkage data as possible so that the notes can be available in other areas of the program. My question is this: Are thousands of memo field records too inefficient...

I have an unbound box that users can type in a note to save into the system. Then, they click on a button (Save Note to File) and a SQL statement runs in VB to save the note and other relevant data to a note table. Everything has been working great, except when the note is greater than 128...

If you are familiar with Outlook, you know it has categories on the appointment screen that you can select from a checklist. The example of what I want to recreate is the category selection for an appointment the same as Outlook. I can make the continuous-form subform look the same as Outlook...

Are you familiar with Outlook? The example of what I want to recreate is the category selection for an appointment. I can make the continuous-form subform look the same as Outlook, and if I open the form without making it a subform, each line shows properly (a checkbox with a category, all...

My goal is to have a list with each item having a selection checkbox for the user to select which items in the list they want to act upon (delete, email, add to a group, etc.) The list is created by joining several tables together to get the information I need. That part works fine. I get all...

The drawback to using a multi-select listbox is that it is designed for inputting. If you bring up the list later to adjust what is selected. One other comment about the subform with checkboxes: I can create the list linked with the check boxes and all the categories show up fine to select...

In outlook, when you go to a schedule item and use categories, you see a list of all current categories with a checkbox next to each one for the user to select applicable categories. After you finish selecting the ones you want, one the main form these categories are then listed one after...

I have a list of items on a form with checkboxes next to each item so the client can select individual records to act upon (delete, print, etc.) I want to add the ability for them to use the record selector to the left of each row to also select items. I have looked through all of access help...

My goal is to have a list with each item having a selection checkbox for the user to select which items in the list they want to act upon (delete, email, add to a group, etc.) The list is created by joining several tables together to get the information I need. That part works fine. I get all...

I have a database that contains some names that have ' in them, such as O'Conner, etc. The search method I have in place comes back with an error because of the ' in the name when they search. The error says "Syntax error (missing operator) in query expression '[EntClientName] Like...

I was wondering if you could post what changes you made when you re-wrote the code. I am wanting to do something very similar to what you have done, but could use your re-write. Thanks.

Many have received answers to print margin adjustment to simply go to the page setup, change the margin settings, select orientation, and then save the document. I need to be able to go further than this. (1) My program will be a MDE, so redoing the print layout programmatically will not work...

Thanks for your input! I have always desired to stay the most "Flexible" in design, and all-in-one table seems to fit that. In the current version of the program, they will only be able to allocate one entity type to a entity, but in the next revision, I will add a one2many table so one entity...

I am creating a system with a similar issue to what you mentioned and I though I would add my two cents worth. I have a system have used dates in many different areas, such as schedules, reminders, accounting, events, etc. My goal was to make a global history table that tracked when entries...

I have a relatively complex project of clients, suppliers, employees, manufacturers, contractors, etc. I have fully developed the client area of my program by having a table with only about 15 or 20 fields for each client. These fields are enough info to identify who they are, such as client...