Search results

If I wanted this same idea work on a report would it? I have business prospects and estimated closing date and would like to have the same: 0-90 Days 91-180 Days Then have total the days left for those in a report...

Should enable image verification upon registration on Vbulletin forums here...

I am having difficulties with combo boxes for some reason and cant get it to work. I have spent the last couple of days trying to use examples found here and other places but still not successful. Have looked at the examples on font stuff and have downloaded various examples here on these...

I seem to running into issues. I have been trying to get this to work all day and several times...while attempting to change things and get it to work...it freezes on me. Access menus and actually everything becomes unuseable. Any know why this is happening as so I can not do it anymore. I...

Current: 5 New: 7 The button text I think is hard to read or not as smooth as I would like...

Hello, thank you. I found this in a sample and wondering if I am on the right track since I am not that good with this. Private Sub Classification_AfterUpdate() Me.lblResult.Visible = True Me.txtResult = "LOST OPPORTUNITY" ' Requeries the bottom combo (cboReason)...

Combo Box Help - Confused. Hello, Didnt know where to start or what direction to head in. I have a combo box on one of my forms. It works fine, but would am looking for an added feature. I am looking to get the following started: There are 5 items in the list of my combo box. If the user...

Sorry found a solution. Just got really nervous that I would have to start over again and my due date is coming up for work. I was just able to import into a new database and everything is back to normal. I must have somewhere disabled it or something...ok now i can stop sweating.

Hello, I hid everything upon startup and holding down shift key isn't working? What am I doing wrong? Do I hold it down after Logon or before...not sure why it all of a sudden stopped allowing me to bypass. Please Help. Thank you.

Thank you for the explanation. I am new and trying to see how the pieces fit together. I think now I have it set. I broke up the table manually into 11 tables. I had to break up Products because the chance of having supplying 2 of the same product. I think now it looks almost right, at...

Thanks for the Reply. I am new to rather new to Access and appreciate the help. Ok I did the table analyzer and it split my table into 4 tables. So basically if any information is going to be repeated in any column then it should have its own table correct? Is there really any bad way to...

Thanks for the reply. I guess I am a little confused still as I have tried several things with no luck. I have 4 columns in this table that I am looking for help with. I want to count the nonblank items in columns PROD1, PROD2, and PROD3. I only want them counted if the column CLASSIFICATION...

Hello, I am rather new to Access and looking for some help with my table. I have a report that I do, that I used to do in Excel and was wondering if it was setup right or if there was a better way of doing it. From looking around I noticed that people usually have mulitple tables and such...

Hello, I am trying to count column items that are not blank, how would I do that? Where the "?" are I would like for it to tally up the non blank cells in the columns. =Sum(IIf([CLASSIFICATION]="Preliminary" And [PROD1]="?" Or [PROD2]="?" Or [PROD3]="?",1,0)) Thanks.

Nevermind. I found something that worked. :) =Sum(IIf([CLASSIFICATION]="Preliminary" And [OFFICER1]="DB",[AMOUNT],0))

Thanks for the help. This did the job: =Sum(IIf([CLASSIFICATION]="Preliminary" And [OFFICER1]="DB",1,0)) Now another part to this report I am trying to put together. I used this to sum all of the preliminary classification amount totals: =Sum(IIf([CLASSIFICATION]="Preliminary",[AMOUNT],0))...

Hello, I am putting together a report that has a summary of some information. I am tryign to also include summarys for a certain field, counts if it equals more than one criteria. I have tried the following: =Count(IIf([CLASSIFICATION]="Preliminary",0) & ([OFFICER1]="DB",0)) How do I use...

Hello, I was wondering if this was possible. I would like to have a field on my form that states who last saved the entry. I have a table that has business prospects and people responsible for them. A certain entry my have 2 or 3 people responsible for the prospect. I wanted to record who...

Thanks for the Reply. Let me explain. Column A has initials of sales people. Column B has business prospect classifications. IE Representative(Column A) Business Classification(Column B) JB------------------------New Business JB------------------------Preliminary Contact...

Hello, I am new to Access and was trying to figure out a simple Count. What I want to do is Count Column A if Column B has "". I have looked around and am sure this is easy, can anyone point me in the right direction. I use this for another item but dont know what to add to make it work like...