Search results

The file sizes vary pending upon who took the picture with what camera. Most are about 1.5 megabytes. I was hoping there is some code I can use on custom navigations for next/previous record that would stop you from going to the next record until the current record loads all pictures. All...

I have a database that displays images. If I do not wait for them all to paint (Show up) and click on the next record, I do not really get an error but what I do get is the Status Bar stuck in the screen and it always stays on top of everything. I attached a JPG image of what I am talking about...

Try something like this: Like IIf([Forms]![form name]![Policy#] Is Null,"*",[Forms]![form name]![Policy#]) This should make it if nothing is selected, to return all values.

I live in California... Just north of San Diego. I moved 45 Minutes up North from Down Town and still, 14 years ago paid 118k for my house. I sold it for over 350k 4 years ago and paid 450k for my new house and it is well worth over 750k. I went from doing Computer Consulting (Not doing Access...

The way it works now is great. I just wanted to ensure that I am doing things right and not making a ton of extra work on myself. Each querry does have an expression based off if something is checked or if a data range is in place. I never thought to use Dcount() as an option but I am still not...

I have a table with the following fields: Record_No <--- This is an autonumber field Est_COE --Date Field Type DATE_DOCR DATE_Followup Progress I then have used multiple querries that just count records based off of Status: Example of one of the querry's: SELECT Count(borrower.Record_Number)...

I found this one. Take a look at it... I have not implemented it yet, but it is by far the best one I have located. http://www.lebans.com/monthcalendar.htm :cool: Good Luck.!

If you wish to add attachments add the following line as many times as you need for as many attachments as you need. Also, on the CDO.DLL, I did not have to do this but here is what Microsoft has to say on registering the DLL... (From a command prompt "regsvr32 c:\winnt\system32\cdo.dll")...

Here is a peice of code that will allow you to email not using outlook or anyother mail application. You will need to reference the CDO.DLL. Public Function Email_CDO_Test() Const cdoSendUsingPickup = 1 'Send message using the local SMTP service pickup directory. Const cdoSendUsingPort = 2...

Sorry if this one has been answered but I had no clue how to even search... I have a querry that I would like to reference a form to gather the criteria... (EASY - I can do that with No Problems) but what I have is 1 FIELD in my database which has only 5 options that can be entered by the user...

Once AGAIN... i need some advice I had made a form and set timer interval to 60000 (once a Minute). I then added my code for module and now my system is doggie slow. It is a P4 3.2 with 1GIG Ram running Server2000... all i use it for is my personal TELNET server to my application. Did I go and...

that solved the Null issue That does allow the Carbon Copy field to be null and still sent out the email. That was great. I am glad to see people who help... you are by far an excellent resource of the Forums. Thanks a million... when I am done, my database will allow me to set a date and...

I did it - works great except for 1 thing If my querry has a null record for [add_email_to] then it give me an error. Is it possible that if it is null, then not CC anyone and to continue without an error. I know in the Query, I can add an email using the iff statement, but I would rather not...

I attempted to get this done myself and I do not really understand looping and checking record sets to ensure there is a value. SO, I am asking the guru's to take a look at this project and see I am even worthy of being helped. I tried using a loop sendobject email out but it is not working. It...

I have a followup table that has 6 fields in it. [MEMO], [CLIENT], [DATE_TO_FOLLOWUP], [TIME_TO_FOLLOWUP], [EMAIL_WHO],[FOLLOWUP_COMPLETE]. I want a Form using the On Timer function to look at a query that runs every minute to check if there is anything to followup with by looking at the...