Recent content by srideout2525

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