Search results

I need to issue a report (even if there are no records) so I can't use the OnNo Data method. I have a report with headings created I just need a textbox to display "There are no open issues". I've tried IIf([Problem]="not null","No Open Issues") Any idea'?

I'm sure I'm close, but this isn't working. I have a table tblDEmailList which stores the [plant] and the [dEmailAddress]. When a rejeect is issued at the Fenton plant, an email need to go to the sister plants not to the plant who recieved one, to check thier product line for the same...

I'm not sure this can be done,but here goes it, I have 5 [plants] A, B, C, D & E. If one plant recieved [A] plant reject [Reject] then I need a response from plants B, C, D & E. If plant [B] receives a reject then I need a response from plant A, C, D and E. How would I show what other plants...

I thought it worked, but I bailed out of one database and got in another and the toolbars were gone again. What do you mean by new standard ? How do I set this for all database? Am I suppose to add these lines of code into every data? Reinstallation is starting to sound good

How would / could you use that code not globaly, for one database?

Thank you, it worked. Sorry I must have missed, the part where it says it's global. Too many people ignore my warning at the top of that posting...

Which code? There are 6 or so to pick from. Not sure how "put it in a standard module and call it from the immediate window to turn things back on. Please explain

I already tried that. I'm missing the toolbar now. I was able to right click and get the menu bar back.

Help! I'm not sure how I did this, but NO matter what database I go into i can see any toolbar or menu bar. Yes I tried the shift key. How do I turn it all back on? When I right click I can get the database startup properties, everything has the check, yet I can't see any toolbars or menu bars...

I have a form, which is based on a table. Usually I have forms open to new or last records, but in this case I need it to open sorted by reportnumber. I read up on the orderby property, which I tried on open without any luck. Any ideas, other than basing by forms on queries....

Can this be done? I have a survey, which the scores are 100 through 10, and if n/a applies it assigns a 0 value. I wish I would have thought of this earlier, now I want to perform an average with out the 0 value. For example on the report footer it reads, =Avg([Helpfulness]). I used option...

Pat, I tried both methods and I received both times "You tried to assign the null value to a variant that isn't a variant data type. RespondentID is an autonumber and TblSurveyID is a number.

I have 2 tables Respondent & question, for a survey. THe relationship is one to many. I'm having users login on Form Login. After login the actual survey form opens and I hide the login form. Problem is only the login information is writing to the table. I need the RespondentID to store a value...

I'm working on a survey database, I'm having the users select the opton button to rate (1 - 10). Then as an after thought, I thought I would add a button that says N/A or doesn't apply. Course option buttons store numbers. ANy idea's on how to accomplish this? What ever value gets stored I...

I actually have 2 problems, help would be greatly appreciated. I have a Login form which has a username and listbox with the field primary_secondary. Both these fields are required. When the user selects submit, it open another form survey. The Login form is hided. When survey is "submited", how...

I'm sure this is a stupid question, but here goes it. I'm working on a survey database. I want the end user to be able to be able to select a checkbox, if they use that service. Down the line I want to do some charting on the answers to the number of checkboxes selected. Is there anyway to...

How did you do it? I've tried many things, Lines won't export so I used a label w/underline, but that's the only work around I've been successful with

I'm trying to compare a date fields (Date Quotes), to DueDate, however I need if duedate is today or late it needs to be red, of if it's within 3 days green. THis is what I have, and it's not working right, I'm using 97 Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If...

I have a query which calculates Lagtime: which is the difference between the audit date and the current date. Lagtime: DateDiff("d",[Auditdate],[Date]) and the criteria is >30 this works fine and shows the reports that are over 30 days overdue. Now I need: There are 2 fields (both are y/no)...

Thanks a million. It worked. I can probably use this code for other projects which I have hard coded. Thanks again, your my hero