Search results

ComboboxA displays products comboboxB displays subproducts fo comboboxA - this works fine, but I have a frmResults that opens when comboboxB is selected and it doesn't open to the correct one. frmResults rowsource is the combobox rowsource: if I select comboboxA the form opens to the wrong...

thanks, I will look it over. Pretty clever BTW

I'm stuck & I suspect it's something stupid but...I have a db w/duration field, which will never be greater than 1 hour, so I want to set it as date/time, but i want it to accept time only values: i.e 35:40 w/seconds - I tried date/time and picked the short time format, which I thought would do...

I'm not sure this is the correct/best approach, would appreciate help/ideas. I have 2 tables - winetypes and randomwine. Randomwine has autonumberid, as a link to an external picture of wine (.jpg) and a catagoryid. The idea is a user select a style of wine from combobox on form and that...

UPDATE Initial INNER JOIN tblRepresentation ON Initial.RepresentationID = tblRepresentation.RepresentationID SET Initial.RepresentationID = 10000 WHERE (((Initial.Salesperson)="ISNULL")); The representationid field is numeric field, Long Integer, salesperson is text

I have been going back in a db to the beginning of time and restructuring...I have a field sales person if its null I need to assign a value of 100 to another field representativeid, I have been using the update query to accomplish the update until now. I've tried is null and "" to get this...

I must be brain dead today, but I can't figure this out. I have a field on a report called PotSales; in the report footer I have the following formula =Sum([PotSales]), which works if there are PotSales, if there isn't it generates #Error, how the heck do I force it to result in 0? Help

the on key, isn't that on the form? not like "* *" is that in the table properties, or on the form? Thank you

I have a table w/field set as text that I don't want users to enter a "space" into, how would I stop this? I suspect " " in the field validation field? Does this sould correct? What does everyone else use?

boblarson I know it works w/access, since I've already had to do it, I was wondering how to do it w/Outlook only. Thanks

Solution Actually I figured it out; I have to create the distribution list in word, using the properties from outlook (spelling of the name, etc) then I have to paste it into outlook. What a crock huh?

After reading tons of posting about this subject, for simplicity sake I need the code to run on startup, to change the security settings to low, so users don't get the message "Some files can harm your computer". any way I founds this: which I put on the load of the switchboard; using 97 still...

I'm using 97, and have inherited a broken db, what do Otheres use to see the flow of forms/query/table reports? There are tons of queries, forms, reports, etc. any help, ideas suggestions would be greatly apprciated

The boss wants his name to appear in all distribution lists first, from everything I've read the list is alpha either descending or ascenting....problem is his last name is Bob Looserr so it appears in the middle of the list.

About 1000 records between the 5 tables, or going back to 1998. I suspect boblarson is correct about the redesign.....but first I wanted to exhaust the band aid approach

this is the sql, for one plant table, which works, but I can't add anymore tables in SELECT Supplier.[Supplier ID], Supplier.[Company Name], tblChesterfield.[Reject Number] FROM tblChesterfield INNER JOIN Supplier ON tblChesterfield.[Supplier ID] = Supplier.[Supplier ID] WHERE...

Without designing the entire database, is there a way to get a report with the supplierid from each table into one query/report? I guess that's what happens if its not designed correctly from the beginning jdraw - what you wrote is that your normalizaion technique? I have another project and I...

I have 5 plants (when this was orginally created there was 1) I need to develop a report showing defect by suppliers. A user would select a supplier from a combo box, and using a query would show each reject number by supplier. I can get query to work, for only 1 plant as soon as I select...

Thanks. Question though, I thought I would invoke this so it would apply to all fields on the form, which I don't think is the case? What event should I use to invoke it, afterupdate I suspect? Thanks

The report uses the query. So calendar picks up the beginning & ending date, there is a preview report command button which calls the report; The report calls the query. It's the strangest thing, sometimes the pie chart (which I need) displays the correct info and sometimes it doesn't. Ive also...