Search results

I have a table filed with rates. I want to have all the rates reduced buy 15 dollars. How can i easily implement this change?

First off I'll express my frustration, because dispite the many times I asked this question and been told it couldnt work, I had it working on three of the office computers. That is, when i click a button on a form, I got a preview of a report to display in front of the form, then I could print...

How can i get the switchboard to open automatically, Instead of clicking Access then clicking the form.

I'm still have speed issues. Here's a split database question. (maybe Im doing this wrong) I split the database. The front and backend reside on the server. All I did was add a short cut to frmMainSwitchBoard on everyone connected to the server. Is this a good way of doing things? If not...

I'm having complaints about my database. People are telling me that when they try to open up a form it takes forever. Why would things take so long to load? Is there a way to speed it up? Any suggestions?

I have a query where I would like to display the records where payment is greater than 0. In other words, where there is a payment made. I didnt mess with the sql, only the design view. any help

I'm trying to make a query where I sum the rates in an order and sum the additional costs in an order. Unfortunately when there are no additional costs in the order the query leaves that order out. so for example Order 1 has rate 200, 300 and costs 40 and 50 so i group by order# and sum the...

I've been messing with FrontPage and code and this and that to try to simple retrieve data from a database in a web browser. I'm having zero luck. Is there a sample somewhere I could follow? I would be simpy happy to SEE a field from a database in Internet Explorer. Ok I'm not proficent in ASP...

I created a databse on Pro and then tried opening on another computer using 2000. Works fine...well sort of. When I view a report from a form it doesn;t appear above/in fornt of the form !?! I 'm sure there was/is a property that says POP UP in the report. Does it not exist in 2000?

basically i have a report( an invoice) for a client. is there a way to email the report so i can skip printing and faxing it :( I've tried but it simply sends a messed up html page. any help?

1. I have a list box on my form that I wish to use to select clients names, and have all their info show on the rest of the form. I can't seem to get it to work, it always prompts when I try opening the form. It's like it's looking for a value to open the form. Any Help? 2. On my form I have a...

I have a combo box filled with customer addresses in a subform of the custmer form. When I select the addresses in the combo box i want to have only the current customers addresses to appear. Currrently I have ALL the addresses appearing. I feel like it should be a where claus in the query but...

how can i format a phone number value in a list box? i have a listing of information and one piece of the information set is a phone number. i would like it to displayed formatted. Much like an input mask...!\(999") "000\-0000;;_ and suggestions?

I have a form which holds clients and theirinformation. I can scroll through by clicking the next button, but that is very tedious when the record count is high. As well, I have a find button, but the users have ben complaining about that as well. Sooooooooo.... I was hoping to have list box...

I have a report that i would like to exapnd the marginns on, so i can take advantage of more space on the paper when i print. Currenetly i have a large border or white space, which if I could utilize it would prevnt spillover to paper two. any suggestions??

This is what I've tried, but i only want to send the invoice that is related to one order...not every invoice in the database. I thought I could use this: stLinkCriteria = "[tblOrder.OrderID]=" & Me![OrderID] but there doesn;t seem to be link criteria option with SendObject...

I have an option group on my form. I have two check boxes, yes and no. Everything appears to be linked, I used the wizard. But when I load the form and begin to fill in fields I am unable to check eiether box. Anyone know why this happens and how I could possibly fix it. As soon as I click the...

I have a form with a sub form. On the main form I was hoping to have a list box, of the main forms 'suppliers' and when clicked all their info should show in the text boxes on the main form, and their first rate should show in the sub form. I've tried a few things, but no luck yet....any...

My report is based on a query. Two fields, for example are, FName and LName or a Client. Instead of displaying them intwo text boxes, (because the spacing makes it look like a nightmare), I'd like to concatenate them together. I have had no trouble doing this it the values are pulled from a...

On my report I am pulling values from radio buttons: 1, 2, 3 and 4. How can I assign the numbers values and have them appear on the report: for example: 1 = Terminal to Terminal 2 = Door to Terminal 3 = Terminal to Door 4 = Door to Door Do I need another table? to pull these values from...