Search results

  1. E

    export to xml advanced

    I'm trying to make an export of invoices to xml so I can import it in our financial software. Desired format of the output: - Invoice header - Invoice lines - Invoice Footer - Next invoice header - Invoice lines - Inovice footer - and so on It went pretty well untill I got stuck...
  2. E

    ending msgbox results in loop

    I've build an invoicingprogram for two kinds of invoices. One part generates invoicenumbers automatically. On the other part users will have to enter an invoicenumber manually (working on it to automize this too). But for the time being I have this workaround. The problem is caused by the...
  3. E

    DCount with string

    I'm trying to find out if a record exists. The data to be found will be entered by a InputBox and is numeric. If DCount("*", "tblFakturen", "Faktuurnr = " & sInputE & "") <> 0 Then gives typemismatch If DCount("*", "tblFakturen", "Faktuurnr = '" & sInputE & "'") <> 0 Then gives type...
  4. E

    invoicenumber format

    I've build a program for making invoices. The invoicenumbers come from an external program. To lower down the insertion of wrong invoicenumbers would like an inbuild controller on the invoicenumbers. The invoicenumber begins with the last two digits of the year followed by 71 and a sequence of...
  5. E

    Problem Update-FE-Utility

    I have implemented the Access_Front-End_AutoUpdating_Utility build by Bob Larson http://http://www.access-programmers.co.uk/forums/showthread.php?t=111132 into my own mdb. Even changed the code in the startform's LOAD a little so the program will only check for updates once a day. So far it...
  6. E

    DCount problem

    I'm building a db which holds vehicles and their driver. The form Vehicles has a subform which contains the drivers and the begindate and enddate. What I want is to secure this form so that no duplicate records can be made. If you enter a drivers name there must be a check that the driver is not...
  7. E

    strSQL with WHERE

    I want to select a department in the form and then the field Text1 must be filled with data from tblFaktRegHerinnering filtered on the chosen department. I tried to filter with WHERE but then I get the error "to few parameters: expected 1". Without WHERE I get all data from...
  8. E

    Cool Search Toool problem

    A while ago I found this Coos Search Tool db on the forum. I like the way it works very much. Trying to make it work for my own db fails. Please, can somebody help me out and make the damn thing work with my own table? Edo
  9. E

    create help file

    Found a db in this forum. I want to use this in my own db. http://www.access-programmers.co.uk/forums/showthread.php?t=95137 Now I want the module be changed so a form pops up instead of a messagebox. Who can help me out.
Back
Top Bottom