Search results

Hello, I have got things working, but wonder if there is a better way to do things. I have an access DB, with many lookup tables, all referrenced in a table of Contacts. For example ContactID FirstName LastName SalutationID (lookup from tblSalutations) IndustryID (lookup from tblIndustry)...

Hello, I have a sticky problem. Project deals with staff evaluations, and I have a system working, albeit in a frustrating / inefficient way. Problem: 10 staff members each have to fill out an evaluation (online) for the all other staff members. I have 2 tables currently. tblUsers UserID...

Hello, this should be easy for me to figure out, but I must be having lapse of Access IQ... I have a table with multiple memo fields (comments from people). I want to print all the comments for Question 1, then for Question 2, the for Question 3. So group for each field, across records... to...

HI, I have a report, that provides a list of products, quantities and prices. In the footer of the report, I sum the total costs. I need a line item to be added IF a certain product was ordered. So for example a person orders 2 pies -- $2.00 3 donuts -- $1.00 4 oranges -- $4.00 Sub Total --...

Hi Everyone, Have an interesting situation. Client gets a new database table every 4 months (quarterly information). I have built an 'sift through this info' form that lets the users go through this table, and pull out the information they want, and put it into their database. After each...

Hi Everyone, Have a form that is populated from 2 sources. 1. From client information table 2. From an email text string that is parsed for the appropriate fields (i.e. firstname, lastname etc). The form displays any existing client information if its in the database on one side, and has the...

Hi everyone, Here is the setup. People submit 'work requests' from the web, which gets sent to our admin person via an email. Currently they retype or copy - paste each field into the internal database. We would like to automate as much of this as possible (without putting the database on the...

Hi Everyone, Using Dreamweaver MX to create an ASP site. Its spitting out some SQL syntax, that looks right, but is not functioning. I need a SELECT statement that will search across multiple fields. Something like: SELECT * FROM qrySearchResults WHERE (ProjectTitle OR SubTitle OR...

Newbie question here. Client and I are in different cities. Whenever they want modifications to their database, I ask them to compact / repair it, email it to me (its ~ 3MB), and then I work on the new reports, tables, logic etc... then send it back. Leaves them without a DB for a couple days -...

Hi, Interesting question from client. I have a DB that generates 'service call numbers' via an +1 increment autonumber. They want their reports to show client service call number, but dont want to see any unused reg. numbers. (ie. the want to see 1,2,3,4 not 1,4,5 etc..) This happens when...

Hi, Working on an pre-existing database. Original structure has a field in a table called "Salutation" which is what they want to appear at the top of letters etc. It contains info like Mr. Berger Ms. Johnstone Executive Director Sarah I want to clean up this field, and have created a combo...

Hi, not sure the right terminology here, so I'll try my best to explain the situation. Database contains information on studies that scientists have completed (metadata). tblMetaData contains the relevant info like: MetaDataID (primary key, autonumber) Author Title etc.. with a field called...

We accidentally duplicated our database! Some people used the 'old' one, some the 'new' one. We want to find all those records that changed in our 'client information table'. HELP (we are on site right now, so any really quick help would be appreciated).

My combo box displays LastName | FirstName | ClientID (invisible). The result populates the rest of the form with the client information. When I select "Smith | xxxxx| it always populates with the first record containing Smith (i.e. Smith, Adam), despite me choosing Smith, Rob). I can...

3 linked tables. 1. tblClientInformation (linked one to many with tblWorkshopRegistrations via ClientID - primary key) 2. tblWorkshopListings - details of what workshops we offer (linked one to many with tblWorkshopRegistrations via WorkshopID - primary key) 3. Workshop Registrations (linked...

This is killing me! It should be so simple, but I am having no luck. I have a table (for example called "Snacks")with 6 records (always these 6). 1 popcorn 2 chocolate 3 soda pop 4 orange juice 5 water 6 hot dogs I do queries and reports on these records seperately. But now I want to create a...