Search results for query: *

Hi all. I have a document library that houses contracts. The library contains a column for contract #. I link them to a LIST of related contract information using a hyperlink column in the LIST. Each time a contract is added to the library, we filter on contract #, copy the URL, go to the...

Hi all. I have information about 2000+ vendors in the following format Vendor Name Address Type Vendor ABC 123 Washington Pl X, Y, Z, The Type can contain up to 25 total values. We recieved this from a dept that has keyed all the types into a singe cell...

I have several switchboards tied together and each has multiple buttons that trigger queries. Each of these queries requires user input in the facility column [Enter Facility Name]. I would like to create a combo box on the main switchboard that allows the user to select the facility. Then I...

I have a start date and end date for a contract and need to track the dates a rebate should be sent to us. Rebates can be quarterly, biannually or annually. As an example if we have a contract that starts on Jan 1 2007, ends in March 31, 2009 and has a quarterly rebate I would expect 9 rebates...

I have a database that contains a contract effective date, and end date and an associate review period, either 90, 180 or 365 days. I have (([enddate]-[effective date[/[perioddays] that tells me how many times to review over the life of the contract. Now I just need to know the expected dates...

I have an excel file that uses category codes to classify products. It lists the category, the manufacturer and then all products that fall within that category for that manufacturer. Each of the products is entered into the same cell, seperated by commas. A user would open excel, do a ctrl f...

I have and Access Database I use for Job Requests. There are two main tables. A requestor enters data in a form that ties to the 30 different fields in the first table. The requests often change midstream, so I have an update button tied to a macro which appends the old data prior to an...

I'm working on a database that allows users to click on a button and browse for files to attach files (usually excel) to a form that will later be used in specific projects. Once they click on the file I have the path to the file they chose saved in a text box on the form and the "Attachments"...

I use the send object function in a Macro to have users send the master files of individual databases (in excel format) to me so I can compile the data on a monthly basis. As the databases have grown, the files are getting a bit too big for email and I was wondering how I go about zipping them...

I have a database that contains company & product information. The database contains a form where users select Name/Date/Location/Company/and Product line. The subform allows them to select the item # of the specific product in another combo box and autopopulates the description. Currently...

I have a database where users enter a training video code and the description of the video is populated. When they have completed the training video they check the checkbox next to thier name. There are about 20 people that need to log thier training videos. I have added a print button so...

I have a query built that works very well in Pivot Chart view. Currently the user clicks a button on the switchboard which launches the query in Pivot Chart view. While useful to the user, these reports would be easier to use for reporting purposes (printing, emailing, further manipulation)if...

I have a table that groups data by city. What I would like to do is grab only the first 25 records per city. Is there are way to have autonumber start over when the city changes or have a count function that starts at one and changes with the city. That way I can query the autonumber or count...

I have an address dataset in access that I need to parse into seperate City, State and Zip fields. Here is a sample from the data. Sometimes there is a comma, other times just a space. There are various numbers of blank spaces after the address field. CityStateZip AUSTIN, TX 78702...

I have a table of Zip Codes. I would like to cross the zip against a master zip lookup table and pull City and State. Does anybody know where I can find a table with this information? Thanks. Derek

I have an address dataset in access that I need to parse into seperate City, State and Zip fields. Here is a sample from the data. Sometimes there is a comma, other times just a space. There are various numbers of blank spaces after the address field. Any ideas? Thanks. Derek...

I have 30 files each with 16 tabs marked 1-16. On each of the tabs, Cell Q6 contains a number I to compile and average. So I need to grab cell Q6 in all 30 files on tab1 and get a tab 1 average, then a tab2 avg, etc. Is there a good way to do this? I tried to do a macro, but the names of the...

I have a form where you can enter an invoice and then the associated products subform. The products are controlled by a combo box tied to a primary key field. The user begins by typing the product into the combo. If they start to type and their product isn't in the list, they need to hit a...

I have a database containing procedure data and the associated products used in each procedure. These tables are linked on an autonumber procID. The product info is further broken into a product and description table linked on item number to consolidate lengthy repetitive descriptions. I have...

I have a dataset in Excel with the follwing pattern where there is one primary number and several related numbers: Prim Secondary 13 10259 13 44589 21 66514 21 44577 21 22187 I would like this info displayed horizontally, seperated by a comma in the same cell like this: 13...