Search results

  1. A

    slow to administer

    HI can any one tell me if this is a known issue. We have a access DB which has linked tables. when ever we try to administer the database front end the network response is very slow. this seems to speed up if everyone comes out of the databases. Is there a problem with administering tables...
  2. A

    Link data to Word Doc

    HI, I am sure this is simple question for your clever people. I simply want to copy my customers details from my customers form and into a word doc so i can send them a letter quickly. The data i wish to export is just customer name and address Etc.. How can i do this. I have a basic...
  3. A

    Filter form for report

    HI clever pepole I am working in a filter form to filter the results of a report. I have managed to get this working for one field but i want to filter on at least two. can anyone help me with this code to add the second field. This is the code i have used so far: Private Sub Command8_Click()...
  4. A

    Format text in reports

    HI I have a simple report with a text box simalar to this, = "You owe me" & " " & "[ammount owed] & "please pay it" The trouble is the curentcy field is not formating correctly. I have chacked the formating of the query and this is OK. Is there a way to format the field wihtin the test box...
  5. A

    stopwatch or timer

    I would like to add and timer to a form thats starts a timer at the click of a button and stops at the click of another button. like a stop watch, any idea's please. thanks
  6. A

    Report Calculation

    Dear Clever people, Having managed to resolve my lasy problem with your as always expert advice i find myself again with a problem beyond my limited knowledge. I have a report which hold the fileds [invoice ammount] and [over due] (Y/N) the [overdue field] has the sourcecriteria that if...
  7. A

    if statement

    Hi all. Try this one for size, i have a report which holds the fields [invoice date] and [due date] [due date] = [invoice date]+30 I also have a check box [overdue] which i want to have the criteria that: If [due date] >date() then [overdue]= true or If [Invoice date] + 30 = or > date()...
  8. A

    database for sale

    Thanks for all of you wo have replied. There is one thing i think i should have made clearer. i own the comany that i work for and for who i have developed the database for. One of my customers wanted a similar sort of database so ive shown him ours and he wants me to wirte one for him. I have...
  9. A

    selling a database

    Hi I have approached by a company that would like me to prduce a database sulution for them based on one i have written for our company. i have warned that this is not as straight forward as writting it and selling it to them in terms of ownership Etc. Can anyone point me in the direction of...
  10. A

    create a appointment in outlook

    Dear all. Can anyone please send me some sample code of how i can make a form output its date content to make an outlook appointment. please send to Graham@atbltd.co.uk Thanks
  11. A

    copy data form form to form.

    Here's the challange, i would like to copy records from a popup form showing my stock list and using an event on double click copy the data to a populate a record on my invoice form. (Ie. select stock form list and add it to invoice) Can anyone point oin the right direction of what i should be...
  12. A

    Currentcy Calculation

    Is it possible for me to round up a calculated curency field in a query to the nearest 49p or 99p. Example £2.57 becomes £2.99. Thanks.
  13. A

    Help with two forms

    I have a form which shows me my chosen customers details and a subform listing all jobs performed for the customer. You select the job in question from the list and this opens a 2nd for giving details of the job. This works well until i want to add a new job. as soon as the 2nd form moves to a...
  14. A

    VBA HELP PLEASE FOR A LEARNER

    I AM CURRENTLY TRYING TO REPLACE ALL MY MACRO'S BY USING VB BUT AM STUCK ON GETTING A DCLICK EVENT TO OPEN ANOTHER FORM ON THE SAME RECORD. CAN SOME ONE POINT ME IN THE RIGHT DIRECTION IN WHICH TO LOOK. SHOULD I BE LOOKING AT THE WHERECONDITION WITHIN THE DOCMD.OPENFORM FORMULAR? ANY REPLIES...
Top Bottom