Search results

Not sure if this is the right part of the forum to put this in. Basically, I have a list of 5 names that each get a lead in turn as it comes in... I want to be able to make something show up on my form that will show the next person in line essentially, or whose turn it is... and im stuck...lol

Sorry if this is in the wrong place, but here is what I am trying to do. I want a button on a form that when clicked, will prompt for an email address, and then send page 1 of the form to that email address as an attachment in an email. Not sure if this is possible, but any help would be greatly...

Is there a way to make access automatically shut down the computer? If so, how? Thanks!

Output Data From Form into a Table? I have a table that I am going to be storing employee info in. I want the user to be able to enter the information in a form, and then click a button to output it to the form where it is stored. I have 2 combo boxes and 3 text boxes that contain this...

In a form, I am pulling a number from a query. However, not everybody is in the query if they do not close a loan. Instead of 0 (zero) it returns #ERROR#. How would I make this reutrn zero instead? thanks

I would like buttons at the top of each field that when clicked, would alphabetically order the records based on the selected field (button). What would the code be to do this? Thanks!

I know how to do this if I want it set to be the same field each time, however sometimes the form needs to be ordered by 1 thing, and the next time by another. It all depends on what the user is looking for. I might be going about this all wrong, but its what I'm trying to do... Thanks alot!

In my query, I have a field called "Loaded" It is the date format DD/MM/YY. I would like to set it so that it only returns entries in the last week. What would the criteria be for this? Thanks alot!

Okay, here is what I have... 1. A main form that I use. It stores all the data on our borrowers. 2. A form for my processors that they can add new borrowers with among many other things. What I want to do is have some tabs on my processors form. I want them to be able to pick a borrower and...

I have a query that totals the number of calls received for each person. I then have a subform based off this query. Is it possible to have the lowest number be a differnt font or a different background color in the form? Thanks a ton!!

Ok, I made a form that will track incoming calls and where they come from. There are text boxes for the time, and combo box for the source. However, whenever I close the form and open it back up, all the data that was entered is gone. This seems so simple, but my mind has had it today. Thanks a...

Is there a way to make a macro so that when a report is open, it will automatically open to 8 1/2 X 14. The access 2k bug is killing me! Thanks a ton!

Is there a way to make it always open to legal paper. I have changed it in page setup, unchecked the autofix button or whatever it is. But access 2k bug is killing me. There has to be a way to make this work! Any help? A Macro maybe?

How can I do this. I have a label that I type information into. In the middle, I want to insert some information from a text box on a form. Is there a way to do this without having to put an actual text box in there with the label or something, because that is a big pain. Thanks a ton!

I've searched but I cant seem to find the right code I need. I have a table that stores a persons name, fax, and phone number. On my form I have a combo box that has the person's name. When I pick the person, I want the phone and fax text fields to automatically fill in. I've looked in the...

The forms and everything work perfect. The only problem I am running into now is that when I use a button on a form to open a report, the report opens, but does not let you see it? Simple solution I'm sure, but I don't know it... Thanks alot!

I hope I didn't break my DB... I was searching the forum and found someone's code that said you could hide the whole access window so that it looked just like a normal program. A zip file was posted called hide_accessv2000.zip. I downloaded this and did what they said to do, imported files...

Open form to specific record to edit... shouldn't be this hard...lol Okay, I have a form that contains information, including a field "Borrower" On another form is a combo box that stores all the Borrowers. Ive done this before with reports, but not with forms. I want to be able to go back into...

Is there a way that each person who logs in to the DB can each have a different start up form? Thanks

Report format not staying, I searched but please help... I have a report that is set to print on legal paper. It worked for awhile, but now whenever any user opens it up, it goes back to letter sized paper. I unchecked the auto correct thing, but still no avail? Any suggestions? Thanks a ton!