Search results

Thank you Gotit. Just finished it as I received your post. It's been awhile since I've opened Access :(

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?

I cannot find the Report Properties POP UP or Modal? Where are they??

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 have the same problem....can anyone help?

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

Is the db run over a network? YES - the database is split with the tables on the server. Do you run complex queries? Not really. For some sections there are a few queries that have four to six tables involved...but it's slow all over. How many users? Upto 4 - 6. BUT mostly one at a time...

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?

Sorry all, i was adding too much. Simply >0 works. I'll come back when I have something a little more difficult

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

Ok so i talked myself through it. Actually someone in my office helped out. It was a LEFT JOIN that worked. I was using an INNER JOIN. So I basically learned the difference in JOINS.

Ok, no I'm not talking to myself...but, it appears as though it has to do with the inner join..and relates to what i first said.

Actually I think I'm wrong. I did the simplest of queries, return ONLY the order number, but not all my orders return?!?!?!? HELP..I'm confused

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

Not working. I based the query on Quote and Address tables. The AddressID from tblAddress, I put [Forms]![sfrmRoute]![cboAddressID1] in the criteria. But I don't get anything show up in the combo box. :(