Search results

  1. L

    Backend

    Hi all Have a database on the backend. Front end has a password which are linked to this backend. Have disabled the shift key for the back end and all short cut keys. just wanted to know if adding a password to the back end would this prevent access from the fron end or would they get asked for...
  2. L

    If and then

    What I want to do is if a field in a query Payment_Method is say dd produce another field to produce the result direct debit and if its Q in Payment_Method produce Q in the New field. I have linked the query to a table and once this is up and running I will copy it to Excel. But all I want is...
  3. L

    Exporting a query to excel

    Hi all Need some help using Access 97 and what I want to do is on a form have a command button and using the on Click export all the records from the query called All Sales into a present excel sheet called Sales without any headers. Using The transferSpreadsheet Method, Where AM I GOING Wrong...
  4. L

    Missing entries

    Hi All Wonder if you can help What I have is Sales Database run in Access 97. I search on Sales in the Access Query But say we have 10 Sales reps and only 7 have sales the query will only show those seven. Is there anyway that the query can show the three that did not have any sales with the...
  5. L

    Table in backend

    Hi all Using Access 97. Have a table on the Backend containing data that is being updated most of the time. Want i want is to add some fields to this but because its on the back end it will not let me. Can you tell me in easy terms how i would get into the design in the back end in order to do...
  6. L

    Resricting the amount in a query

    Hi All What I need is to restict different queries to say 40 entries and the other 32 entries but if this cannot be done I can resrict them all to 40 .Just need to know how. I'm using MS access 97 In English say you run a query, that will pull all the records. What I want is to run a query in...
  7. L

    Queries

    Hi Just need some confirmation. Using a query to find amount of sales between two dates. The start of the week starts on Monday and needs to include the sales for that day and finishes on Saturday and include that day. Sunday there are no sales. Is the below correct Between...
  8. L

    Backend Security

    Back ends... Have a bit of a prob. Have built a database using MS access 97 have a front end and back end. But in the front end there are tables which are linked to a back end which is a separate database for example called BE which only contains the tables. Have tried using the security...
  9. L

    Id and amount of records

    Just a quick one.... Have a Sales Id which is unique , but can I reset this... Also how many records can we add in a table many thanks
  10. L

    0 value

    in a report if expr is 0 it does not work out correctly at the moment i'm using a sum =Sum([Expr2])+([Expr3]) how would I get a result even if one of them is a zero
  11. L

    Combo Boxes

    Hello My prob relates to a combo box. I have a form that is linked to a query with which the query consist of employee and then a sales table one to many. Right the users firstly goes to the combo box click on a user or adds the user id which is distinct tabs away and this populates 3 other...
  12. L

    Locking

    have a access database using access 97 have 30 users but sometimes some users are being locked out by other users displaying who it is........ When they save they are just moved to the next record It seems to work Ok until more people seem to use. Currently they input sales through a front...
  13. L

    Error 94

    Install the database on anetwork but one user gets an Error 94 she seems to be only user getting it How can I cure this?
  14. L

    Avg in Reports

    At the moment I have a report that works out a calculation if if there is a 0 as below =IIf([Ele Weekly]=0,0,([SumOfEle Verbal])/[Ele Weekly]) But I also run a aVG on this but if the above statement is 0 it comes with an error.. What I use is this below.... =Avg([SumOfEle Verbal])/[Ele...
  15. L

    Dates

    Using this Between DateValue(Date()-(Weekday(Date(),"vbWednesday")+6)) And DateValue(Date()-Weekday(Date(),"vbWednesday")) in order to get sales from certain dates Using Access 97 and the field is called Date have changed this field to another name and also chechked that Date/ Time is being...
  16. L

    Make the mouse turn so its busy

    Want I want to do is when the form is loading up I want the Mouse to turn to Busy.........
Back
Top Bottom