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!

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

docmd.openquery "your query" Put that in the onclick property of a command button

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

I want a row of headings which each persons name. Then, under each person there will be like 10 rows. In each row, I want there to be 2 things (text box for date, combo box for source) There would these for each person though. There are 5 people, so the column headings would have each persons...

It's not bound to a record source. It is set to data entry, but I still want to be able to see it. The reason it isn't bound to a table is because each name has 2 fields that go with it (date, source) I couldn't think of a good way to make a table that would accomplish this the way I like. Also...

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