Search results

The functional difference between class & id tags has always been the difference between id are used once per page, class used many times. But as far as I know that is technically incorrect, there is nothing to stop you from using id tags on a page repeatedly, though I have not tried, so I am...

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

If I could just askk one more question on this subject: Could you dissect the syntax of this statement: DateAdd("d", -(Format(Date, "d") - 1), Date) I assume that the first "d" declares that the enclosed () statement will alter the day, and that (Format(Date, "d") - 1) is the Function that...

Is there a way to make a button that would send the HTML in the e,ail's message and NOT as an attachment? All users will be using Outlook 2000+ Thank you

Right on KernalK, that is a really big help. I know it's ridiculous I haven't wrapped my head around this at this point, but I think I have it down now. Thanks to both of ya again!!!

Thanks 'KernelK', I am looking in the help file now. Husky, thank you, I knew it would be simple like that, I was using extra () to wrap the calculation and kept getting errors. You're always point on, 100% of the time! Your suggestion also sparked peabrained idea (:) , that's the best I can...

I am using the following code right now to initiate the search and set the default StartDate / EndDate, which my query uses as criiteria for the search: I would like to modify that code to calculate the above listed ranges for searching. Thank you!

I would like to be able to modify the criteria for a query using an option group of radio buttons. Basically run a query based on: Current date Current week to date Current Month to date the past 7 days (todays date - 7 days would be the start date) the past 31 days (todays date - 31 days...

Is there seriously not just a simple list of these and similiar functions to be found? It seems like it would be a handy resource for those trying to learn. I'm amazed.

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

Hello, I decided to dig up a really old post! Question, this is the code given here: (This is all just a very generic example off top my head that would be helpful for several applications in my db) Now, say I had a field that has a lookup table with three possibilities, now say I made a...

Thanks Doc, I just ran into that problem and had a "oh no" moment. I did find the answer before your reply (thank you though!!!), but the syntax used an exclamation instead of period [table]![field] instead of [table].[field] is there a difference? And if they are the same thing, are there...

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!

One more thing... What if in my query, there are fields with the same name out of different tables, like tblOrders.CompanyName and tblCustomers.CompanyName. How would I refer to each of those seperate fields in the VBA? Do I simply add in "tblOrders." before the field name and after the query...

Thank you Bodisathva, Getting this into my db is proving to be entirely too difficult at this point, hopefully I'll be able to see some working results soon before I start pulling out hair! Thanks for the help!

Thanks, I noticed you added an underscore after the third ampersand in the statement, why? (I'm just curious). Also, can you wrap single quotes around double quotes instead of using 2 sets of double quotes? (Another change I noticed). Is the difference simply semantics, or should you always go...

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