Search results

You may want to check your email settings. I have been playing around with sendobject, and I know when I don't have an email account set up that it would take me to a wizard. When I exited the wizard, it would give me the same error. So check your email settings. As for the information...

Right now I am storing a pdf in a database by creating a link to the file. My problem is that my boss went to a presentation and looked stupid when none of these links worked since the files that were link were not there. He requested that I store the pdfs IN the database and not link them. I...

I set my database to compact on close orginally, but it was taking a lot time since it was being run off a network and users start to complain. So I was looking at trying to compact the database by checking the file size when a user clicked exit. I have the checking down, just need to figure...

granted, that is an event. But the event I want to check on is the "on_click" event. So when someone clicks a button it checks to see if someone is holding down a key. I don't want to check is someone hit a key, until they actually click the button. sorry for being ambigous. Any information...

1. The best place to find VBA/Access information is the library. This dicussion board also is a tremendous tool. I have learned alot from just reading other people's posts. And the WHERE statement you are talking about is more of an SQL statement, not a VB command. I know there is alittle...

If you are closing your form, another way to save is: DoCmd.Close , , acSaveYes Upon closing your form it saves the data you entered, therefore you don't need to have a button

I can not say that I have had too much experience in this area, but what I would try would be this... Try stroing all your pictures in a certain directory on your computer. Store the location path to the corresponding photo in the table. Then, when you open up a record, have your "photo"...

I have tried to search the message board for this problem but I am not finding any information. My problem is relatively simple. When a user click and button, I want it to exit the application. If the user is holding down a certain key (almost any key would work) I want it to open up an...

Thank you Mr. Morrison, Thank you so much for that information. That was exactly what I needed!! I had been looking all over and could not find anything that would solve my problem till now. Thank you very much, you are a life saver. Brian

I have two problems right now that I have no idea how to solve. My project works like this... You fill in required information on NewJob form. This form is a continous subform. And then you click in AddWorkOrder button on the subform. This opens up a new form to add a work order. On the...

Thank you for explaining the error. I know that it definitely fits under the first one. I do have the record open in another form at the same time I am trying to update it. That makes sense. I guess I was thinking I could update the record and then maybe update the form. I guess my new...

I thought it would normally be a multi user issue. The only copy of the program is on my local computer. I am sure that no one else is using it or is logged in since no one else has a copy. I figured that it considered "someone else changing data" when I checked the check box after returning...

Right now I have two forms. One if a job information form that is really a continous subform on the main form, and I also have a seperate work order form. One the job form, there is a button to click to bring up the work order form. Also on the job form, there is a check box that is checked...

Thank you very much for that idea. I never though about it. The only thing is that now I have a new problem. The subform with the check box is continous, and could have many copies contained within the form. I have been trying to play around with how to check just one of those subforms...

Sorry I was not as descriptive as I should have been. The check box is more for the program knowing there is a work order. The user should never be allowed to click on it, infact right now it is disabled. I just don't want to have a work order, then have a user click it off or vice cersa...

OK, I am looked through the message board so far and could not find anything that helped me. What I am looking to do, is to update a check box on a table. I have a form that gets data for a job. On this form, you can click a button to add a work order. Also on this form is a check box that...

I just lookded at this breifly, but I think what you can do is use the DAY, MONTH, and YEAR functions and some simple coding. Maybe something like "This " & DAY(your date) & "th day of " & functionMonth(MONTH(your date)) & ", " & YEAR(your date) The only hard part is writing functionMonth, but...

Thank you very much for the offer, but I got it taken care of. I searched again through some older posts and found something that helped. Just incase anyone has the same problem, the solution is not that bad. You need to add a text box in the form footer, and set that =Sum([field]) and it...

I had to do something like this before. The way that I did it was with a LIKE statement. It should be explained alittle in your help menu. It is used in an SQL statement and allows for "wildcards" or unknown symbols. For example, Dat* would bring up any records that started with "Dat". I...

In my project, I have a form which contains a repetitive subform. The subform is very simple, it contains a date and a quantity(number). My problem is, I need to try to find some way to sum the quantities of the subforms, and have it on the main form. The form is used in editing the...