Search results

  1. A

    Spruce Up Forms

    Thanks My e-mail address is andrew.shuter@virgin.net Regards
  2. A

    Spruce Up Forms

    Is there anything I can do to spruce up the appearance of my forms - for example different colour command buttons, shapes, backgrounds etc Regards Andy
  3. A

    Always wondered what these meant!

    I have alwayus wondered what the following thinsg mean in Access. They appear in the ADVANCED section of OPTIONS (in the TOOLS menu) 1. DDE Operations 2.Command line arguments 3. OLE /Timeout 4.Refresh Intervals 5. No Of uopdate retries 6. ODBC Refresh Many Thanks in anticipation!
  4. A

    SQL query

    Thanks - works great! w
  5. A

    SQL query

    No Sorry.... The command sits in the criteria box in a query
  6. A

    SQL query

    Would someone be kind enough to help me out with this one?? I'd like to show records between these dates and anything that contains a blank date >=[Forms]![listbox2]![Text15] And <=[Forms]![listbox2]![Text17] I have a similar operation that goes like this.... Like "*" &...
  7. A

    Speeding Up Over A network

    Just installed a database over a Network supported by a server, but the customer complains that it starts to run slow evry so often. The Network is a hard wired. 100mbps system running Windows Small Business The database is currenty 16.2 MB I have already implemented the following The...
  8. A

    Network Printer Question

    I have just installed a database on a Network supported by a server. The network has 3 printers. In order to select which printer to use, I am using the following command in Visual Basic... Dim prtDefault As Printer Set Application.Printer = Application.Printers(2) Set prtDefault =...
  9. A

    Remote Access

    No ... But I can install it anytime! //
  10. A

    Remote Access

    I 've written a database application that sits on a remote system and I would like to manipulate it from home. I have the IP address and password but wonder if anyone has any suggestions as to which application I would use to access the file?
  11. A

    Shortcut

    I hope I explain this right! I would like to know if it is possible in Access 2002 Pro to be able to list a series of records in a form and then be able to double click the actual record itself to take me into that particular record directly. I can list the records (by either using a list box...
  12. A

    Import data

    I'd like to import data from a .log file. The data is separated by quotation marks ("") but I can't seem to get Access to recognise it. Andy Suggestions?
  13. A

    Automated Faxing

    I've written an application for one of my clients and his IT guy has asked me to automate faxing by using the ZETAFAX application. This is a copy of the e-mail he has sent me but I don't have a clue what he is on about! ******************************************* Please find below the coding...
  14. A

    If Then Question

    Struggling! Cant seem to get the right syntaxt for the "BETWEEN" and "AND" bit!
  15. A

    If Then Question

    I can use If....Then....Else Ok I think, but I'd love to know how you put multiple criteria in a command For Example - This command sets the value of a field if a car is less than 365 days old If Me!VehicleDaysOld < 365 Then Rate = Forms!frmMaintenance!Text584 End...
  16. A

    APR - Interest Rate

    Can someone please help me with this one??? I need to work out the interest given the following inputs. LOAN AMOUNT TERM (MONTHS) APR I've done it OK in Excel, but it doesn't seem to want to work in a query! Any suggestions are much appreciated Andy
  17. A

    Dcount

    Thanks !! Thanks!!
  18. A

    Dcount

    Have got the following line in my CONTROL SOURCE which works great =DCount("[FinanceCompany]","qryReport","[FinanceCompany] = 'Lloyds'") What I would like to do is add another condition to the search parameters, but am unsure where the & (or And) bit goes. For example, I would like to...
  19. A

    Faxing Question

    I wonder if anyone can help me with this one. I would like to be able to fax someone a report by just pusing a command button. I'm running Win XP Pro, (with the fax console) and Office XP if that helps. (Can e-mail reports no problem by the way!) Many thanks in advance
  20. A

    If and THEN help please

    Thnaks Thanks chaps - works a treat!
Back
Top Bottom