Search results

I have used the following site search engines: Yahoo Search, Google Search, and even gave Zoom a try. The thing is, I am not happy with ANY of them and I know there has to be better tools out there. The problem is finding them! Doing a search for search / search engine / site search / search...

I am trying to pull my information together for printing and also sending attachments. I have a field whose type is set to memo. I have created 2 select queries, one pulls all of the information together except for the memo field, the other pulls the OrderID and the memo field. I then created a...

I was wondering if there is a comprehensive way to set Outlook appointments from a db? If not, that's what I figured. It's not like Outlook and Access are bundled together into some sort of suite of software where it would be handy for a set of tools that allow you to do such things...

Hey all, I have been looking everywhere on a search form and its related queries / tables for a missing value / error that causes this pop up: The report opens fine once that parameter error is cleared, and I cannot find what it is refering to at all. Does Access have any tools to help me...

Hello, I am running a append query from a button. In the query, I have set the OrderID criteria to: Whenever I try to run the query from the open form & subform, an Access 'Enter Parameter Value' window pops up. I would like to use this Criteria for many different features in my db...

I need 2 option buttons created individually, as an option group has proven utterly worthless to me for what I need. A simple Yes / No pair that toggle back and forth when clicked. I would use an option group, but you cannot define an On Click Event Procedure on an Option group button, and I...

How's it going all, ProperCase has been a great friend in my db, but I was wondering if there is a way to use ProperCase to clean up Memo Fields. I know this will cause problems with proper nouns and such, but has anyone devised code for this? Thanks!

I need help on this, from what the best concept is, to what I need to look into using: I store Quote data from phone calls into tblQuotes. There is a seperate table that holds much of the same information except that it is for actual orders called tblOrders. As far as function goes, I have...

In an Excel document with 33,000 lines, each cell has a space at the beginning of the text. I only want to remove this space at the beginning, does anyone know how to do this? Thank you!

Hello, I am trying to make a simple login system to store the user's name as a global variable for use throught the rest of the database (thanks KernalK). There will be a text box named 'txtLogin' and a button named 'cmdLogin'. I plan to use an OnClick event to call a procedure to set variable...

Hello, Hopefully no one is irritated by *another* send report by e-mail post, but everyone I see is for doing much more than what I need and I cannot get the code to work. I would post the send code I have, but it is so broken I think it would be useless for figuring this out. I have tried...

My database uses a common structure (from what I understand): tblCustomers tblOrders tblOrderDetails so, when an item is entered in, the following is recorded (the field names may not be right, but you 'll get the effect): tbOrders: TaxRate ShippingCost tblOrderDetails: Quantity ModelName...

What will cause the results of a query to be uneditable? One to many relationships? Sometimes they are editable, sometimes I get that fantastic *ding whenever I try to edit the results of a query... Thank you!

Hello, I am making a query using the following: tblCustomers tblOrders These tables are linked together using CustomerID PK to FK. Now the problem: When I run a query using a left join to tblCustomers & tblOrders I have no problems until I try to include any one of these 3 fields...

Hello, I'm trying to find a list of date / time controls that can be used in access aba. These will be for onclick event procedures on command buttons. = Now() is the only one that I can get to work at all in an Event Procedure! How can you calculate these things: - Current Date - Current...

Say I had a list of 20 employees, they can be the employee who entered a record, say that someone told me that their initials were not enough, and they want each employee to be a different color in their field on the subform datasheet. How do you do this? Conditional formatting only offers 3...

Hello, Considering the search function will not allow searching for 'yes' 'no' '0' or '-1' because they are too short, I have to ask here: 1st Question: If providing query criteria by form, how do I set a query to show all records if the search/criteria source is null? This relates directly to...

OK, here goes... I want to create a form that will have a list of equipment. Each piece of equipment will have a button next to it (or maybe I will make a combobox where the model is selected, and it changes the function of a single button), either way, when the button is clicked I would like...

If 2 tables have a field named 'EmployeeID' (for example), are you screwed when it comes to queries and vba, as far as selecting fields / specifying data goes? Thank you!

I am using the attached sample to build my search form on. I have a problem though. The sample searches multiple fields based on unbound entries on the form, but each only searches individual results from a query. Example: There may be an address saved to the customer table, and an address...