Search results

300 RECORDS I should say.

I have a report that only counts a field if it is within a certain criteria, there are three to choose from. It counts just fine based on the criteria but when there is a page break the next field that is counted is +2 instead of + 1. Example, after page one the three counters look like this...

All of my users have a local copy of the FE. My copy that I work on is linked to another set of tables that don't really matter (i.e. I can change the tables without disrupting any valuable data). I can I need to do some more scrutinizing of the events. Are the spikes in network usage those...

Background: I was thrown into the database at my job because my brother left for another job and I seemed like a good choice to replace him. I don't know why, I have slim to none in terms of programming knowledge, (I am a psychology major for crying out loud), but I was willing to learn. I...

Thanks for the reply. I have been able to find some interesting things in this forum for progress bars. The speed issue has been killing me for about 6 months. I can not figure it out for the life of me. I have searched and searched and searched and done everything I can. One day I may fix...

Hi all, I have a main form that is fairly slow to open. The users of this database get rather perterbed at this slowness that I can do nothing about. So as a sort of bandaid on the problem, or sugar coating I would like to make a little "progress bar" as it were using an animated gif or flash...

I checked the references and they are all there. That was my first thought. Is there a way that the reference could be checked but it is not really being referenced? It is just baffleing. Thank you for your help.

I posted this in the general area also but I think it may pertain here as well. I have a database here at work. The backend resides on a server and all of the various frontends link to that server. I update changes to all computers using a .bat file which copies a master copy to all of the...

I have a database here at work. The backend resides on a server and all of the various frontends link to that server. I update changes to all computers using a .bat file which copies a master copy to all of the computers. I recently updated everyone and it seems just fine. The only catch is...

Quite frankly Kodo, That is a little beyond my scope of knowledge. I am sure it would work if I just knew what it meant. Thank you for your suggestions however. if you think you can clarify that would be great. Greg

It displays ok, (It does have some problems adding an attachment still) but it won't send. I don't know if this is what the code is really supposed to do but it is opening in Word as an email message. I would assume it would open outlook. Does it matter if I use Outlook or Outlook Express? I...

Yes I have. It seems ot fail on the .send operation. It tries to send it but when it gets to the next line it fails. I am assuming it is some sort of outlook problem but I don't know. Thank you for your help. Greg

It Almost Works I did a search through the forum and found this code that should work beautifully for me assuming it works. I have copied it word for word (Save for my own database objects) and when I run it I get the error "The Operation Failed" Anyone have any ideas why this may be? It's a...

I just re-read my post and I forgot some important information. I can print to PDF just fine my problem is I want to be able to send that PDF file as an attachment in an email. I seem to have ommitted that little piece. I know you can do send a specific report as .rtf and such but I am...

I have created a module that will print my report to PDF. I want to automatically send that PDF report from Access. (Haven't found anything on this in the archives yet). Using the SendObjec Command would be great if I could reference a file rather than a report. Any help or suggestions are...

I have the same question. How does one go about saving a report as a snapshot (Using a command button preferably), and then send it as an email (is it an attachment, does it fill in the main text area?) Thanks for any help. Greg

Thank you so much. It works perfectly.

This is really silly but how do I set "YourEmailAddress" to the Email Address Text box on my form? That little string really works. Thank You so much.

I am wondering if there is a way to have a hyperlink open the email program and have the email address be filled into the address box. I can make it open the program but I am wondering if there is any way to have the email address filled in automatically.

You use "back color" in the preferences window. You can click the expression builder button to the side and it gives you a color wheel of sorts to choose the colors and gives you the number to use for that color. Do it just like you did but use backcolor instead and the appropriate number for...