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

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

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

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

Hello, I want to use a tab form where the user can click add, search, and edit records all from 3 tabs. The problem is I only want to be able to add data on one form, edit data on another, and just read only on the search. This seems to cause a dilemma, how can I specifiy them to add, edit...

Hello, What I want to do is create a query that will show you ONLY records between the dates that you selected. I want to create the query based on what the user enters on the form. (Enter Begin Date: Enter End Date:) I also want to create command buttons labeled "Today,This Week, This...

Im trying to count the number of records in a table in a certain field that match a certain criteria. I've tried to figure out how to use Dcount with some success, but only in counting total records. Here are two examples. The first one didnt work...

Hello, I recently started using the Chart feature in access. Everytime the form with the graph loads up windows installer pops up and asks me to install. Since i let it install like 3 times, i click cancel and it still works fine. Anyone else have a problem like this? How can i prevent it...

Hello, I created a form to search and then edit the records. It was working.. i made a few visual changes to the form and suddenly it wont update! I cant seem to figure out what I did... if someone could look at it would be most appreciated. How the form works is the you select a last name on...

Hey guys, I have a questions for all you experts out there. I need to create a record counter. I have found documentation on how to create a simple record counter, but of course it needs to be a little more complicated than that. I need to beable to count the records that contain a certain...

Hey all, I had a question about input masks. The boss wanted all the fields to automatically capitalize names and last name. Did that, was happy for awhile. What we didnt realize is that there are names like DiGianno or McDonald that still need caps in certain spots. The original input...

Hello, Does anyone have a list of all the US States in a Table? I want to use it for entering information. Noticed that some employees cant spell, so I want to have a drop down list with all the states so that my database can stay a little bit more uniform. Thanks for any help you guys may...

Hello, I was hoping one of you experts could help me out with a small problem I am having. I use a listbox to sort data from a table. Only problem is that the heading for each row uses the name of that column. For example, one row may be titled "LN". I would want that row to be headed...