Search results

Hey All, I have a question regarding referencing a form using dates between. Currently I have it setup as: Between [Start Date] And [End Date] on the query. I want to reference a form, which i figured would be like this Between [Forms]![frmSBReports]![txtStartDate] And...

You can tell im a bit unexperienced! How do I post an SQL String? Mateo

Hey Pat, I posted the file for you. (to big to post this file as an attachment) http://www.blacktietuxes.com/gr/GlobalRegistry.zip Thanks! Mateo

Hey Pat, Still having some trouble... I have my query setup like this: GRID Weekending Type Style Quantity (N/A) Group By Group By Group By SUM Its still not totaling correctly. Right now its going Type Style...

Pat, Thanks for your help! I honestly didnt mean to call you Phil. I think I was thinking of the Saturday Night Live comedian. Once again, thanks! Mateo

Hey Phil, Thanks for your nudge in the right direction. I've actully never created a totals query, kinda was forced into access as a neccessity so i've been learning as i go. How do you create a totals query? Is Select Type, Style, Weekending, Sum(Quantity) As SumQuantity a code of some...

Hello, I have a table setup as follows: Type, Style, Quantity, Weekending Type would consist of: Coat/Vest/Tie/Pants/Shirt/Shoes Style consists of probably about 100 different codes for each type Quantity: Quantity of each style ordered. Weekending: The weekend each order is due for I need to...

Heya All, I need some help. I need to beable to calculate percentage based on the number of records that store a certain value. Say a marketing lead is "Yellow Pages". I need to beablet to find all the instances of the yellow pages, and divide it by the total number of records to get a...

I tried using a query to view records using <Now or however it goes. It worked, but due to being a live database it seemed to take more time than what would be considered acceptable. Since im not an expert at Access, I dont know if its with in my knowledge to normalize a database. My company...

This is what im looking for also, is it possible? Mateo

figured it out! Figured it out myself. Thanks! In case some one else is trying to do this, just insert: (fieldname).SetFocus into the OnChange. Thanks. Mateo

Maybe im looking up the wrong term... I want to autoforward to the next blank... Say I click a drop down box, after i select, i want to be able to automatically jump to the next field. how do you do this? Thanks in advance for any assistance you may render! Mateo

Hey all, Maybe im just having a brain fart, but I cant get this method to work. There are two forms, the first records Two Names, The Bride and The groom along with their wedding date and where they registered. After all the data is entered on the first form, the first form is closed, and the...

Hey All, This may have been covered already, and if it was I appologize. Searched for it but couldnt find it. Any how, I have a large table of records (problem is its growing). It lists customers and dates. My table has way to many records, so i need to condense it a little bit. What i...

Heya, In your opinion, what is the best Microsoft Access 03 Reference book for learning? Mateo

Hello, I have a database that the table is located on a sharepoint website. This worked out well in the beginning but now that the database has thousands of records, it has slowed up a bit. What I want to do is at the load of the the database, it will automatically copy Sharepoint table to a...

I have three questions, both im sure are easy just overlooking something. 1) I have a search form where you type the search parameters into 3 fields, and then your click search. I want the fields to automatically clear after the search button is clicked (but enough time for the query to get...

That did it! Thanks so much for your help. Mateo

Hello, Im having trouble with Criteria for a query. I have my criteria like this: Like "*" & [Forms]![NewSearch]![txtSearch2] & "*" The only problem is, if im trying to search for a last name such as "Aber" the search results come up with not only Aber but also anything that contains Aber...

Hello, I have about 1500 records in a table. We use a form to search through the records to find info on certain accounts. We now want to only search through accounts that are current, so I made a query to see only current accounts. I switched the search form from going off data right from...