Recent content by brian0721

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!

Nevermind, I figured it out!!! Thanks a ton

I do and I do not see what you are saying. The way you said it, I interpret it to be that the user can scroll through the records on the form that they input the data to. This is not what I want. Ultimately a report will be generated that will produce all the information and total the amount for...

How would I go it? I'm not sure if it's code I have to use or what? But when I click the button, I want the data to be transfered to the table, or if you think its easier, then to a Query.

I meant to say output to the Table where it is stored. I have combo boxes on the form, so can I bound it to the table straight?

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...

Where would I put that?

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!

That sounds like it would work. What is the code that will sort? 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...