Search results

If anyone can give me a hand it would be appreciated. This code was working prior to my upgrade to Access 2003. Now, my email ends up containing all the RTF as plain text with code along with the narative as opposed to a nicely formated RTF email. The code exports a form to an RTF file and...

Good day all. I had a small database that worked perfectly fine. My organization just 'upgraded' from Windows 2000 to XP and from Office 2000 to Office 2003. One of the functions was to generate a report and send the information to a set of email recipients at the click of a buton. The...

Is there a way on a form, to have the filed default to today’s date when a person enters that field. A confirmation asks if you want to keep that days date, and if they select no it clears the space? I want a form to default with that days date. However, I don’t want it to stay at that date...

I have a form that needs to be locked up tight so I created a record counter instead of using the one that is built into Access. In order for this to work there is code for the on current action for the form. This works without error. However, I stripped all of the 'test'data out of the...

I have a buton that does a number of things including sending an email. However, if, for whatever reason, a file wasn't deleted on a previous action I get an error message. I tried to fix that but then if there is no file I get an error message that there is no file found. Is there a way to...

I have information on a form that I want put into an email. However, I can't do the way that I usually do it because a good number of people are carrying blackberries and some of the ones with older phones can't view attachmnets. Therefore, I want to be able to bring the information directly...

Hello all once again. I have used the below method sto send email before but now I need to send information from a report (or the form for that matter) directly to the message body of an email as opposed to attaching the information. The email needs to be read on some people's blackberries...

I have a very large excel spreadsheet (60,000 lines). There are four columns. The First column is poplated and then lists a number of files in the three remaining colums. What I need to do is copy and paste the first colum so that it matches up with every line in the three remaining colums...

Is there any way that I can import a text file and split the data into three columns without having to go through 65000 lines of text. It is basically a print off of a directory structure. I have a very large text file that lists the files in folders for each of hundreds of users. I need to...

I have a list of students that have to take a course. If they fail the course they get a second attempt. The course is taken at one of two locations. If they fail the first attempt they get a check under fail and then they are scheduled for a second attempt, not always at the same location...

If someone could help me wrap my head around this I would greatly appreciate it. Even though it is not widgets I am dealing with, the idea is still the same. I need to keep track of widgets and who they are issued to. The widgets come in lots. I want to have a table that keeps track of the...

I will give this thing one more try. Fresher minds prevail on Monday's. I have several charts that work off of a query. The several charts all compare various variables to year. I have wasted an enormous amount of time simply trying to filter my charts by year. A single field in my table that...

I solved one problem only to hit another. I have several charts that work off of a query. The several charts all compare various variables to year. I created the charts and they all work great. However, the user now wants to be able to select or compare various years as opposed to seeing them...

Year only -How hard can this be!!! I want a field in a table that is a date but that is the year only. I only want this because I want to be able to filter my charts to show one or a span of years for comparison. I have criteria in a query that states between [forms].[charts].[begin] and...

If one of the "coding masters" in this forum could assist me, I would be very appreciative. I have wasted an extrodinary amount of time trying to do something that should be exceedingly simple. I want to chart out some very simple data. Employess have pagers and get called out to work. My...

This is probably very simple and I am wasting time on it so I thought I would ask for a quick fix. I have a form "Standby" that minimizes when a buton is pressed to open a second form "Filter." This works great. I want the "standby" form to restore to it's original size when I close the...

Hello to all. I have been at this for 6 hours and have read countless entires in this forum. I have come close......but not close enough. I am trying to calculate the difference between two times. I can't use a combination of date and time because if I do, those who use the database won't...

I have two records in a table/query. Time1 and time2. I want to calculate the difference between the time2 of the first record and the time1 of the next record. Can this be done on a line in a query? If not can it be done in a form and sent back to a table? Biggest question....if so how...

I don't want to waste time trying to accomplish the impossible so I will ask the experts (the end users). I have a form based on two linked queries. A main form and a subform. The main form is based on a list of clients with tombstone data and the subform is a list of couses taken. Works...

I have a glitch in my database that I have worked around for months. I would like to rectify it now. My lookup for names works great except for those rare names with apostrophes like O'neil or O'brian. Although I can select the name in the box, the lookup won't work. I have to select the...