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

Thanks very much, interesting code. Im getting an error (complie error: Method or data member not found) on the .AddItem line... but I think I get the jist of it. I will post any changes to your code if I make them. Cheers, Matts

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

Email is Netscape Navigator 6.x series email. Ugh! Slim possibility I could get them to Outlook if I had a very convincing argument.

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

Efficiency of the LIKE operator Hi Pat, In my case, I think I have to use the LIKE, as the database contains a whack of memo and text fields, and I do have a line in there that surrounds the search term with % (wildcard). I think to make my searches much more efficient I should build in the...

Solution Solution found. The SQL is below (via VBScript of course). The problem was with the form using POST, for some reason in this case the Form.Variable was never being passed to this script, thus nothing was being done. Changed the form method to "GET" and viola, it worked. Ive added a...

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

FYI, MetaData files (in my case anyways) contains descriptions about the study, but not any data the study generates. Does not affect all of your very helpful suggestions. Im from a web background, and this is for an online searchable database, so this 'conceptual' help is indeed very valuable...

Thanks Randomblink, Yes, you have the structure correct. The third table is indeed the clincher! I would then add records to this table for each 'link' right? For example. stID - pbID 1 13 1 22 1 25 and vice versa 4 17 6 17 9 17 etc... Thats great idea! Relationships would be...

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

Damn - how did I overlook that! Yes, you were correct. I changed my bound column to the ClientID, and presto it works. Many thanks.