Search results

  1. P

    help files whys it so hard to open one!

    Having a little problem i want to have a button on my main form that will hopen a HTMLhelp file (Chm) problem is only way i can find to do it is Aplication.FollowHyperLink "help.chm" which is all well and good if ya know what thouse two anoing boxes are and know to just press ok.. but as you...
  2. P

    database not working on other computers

    I’ve like pretty much finished my DB its working Sweet! on my computer... 2 other computers I have to demonstrate it on it wont work. says Date, Format and a few other functions don’t Exist! Im running the same version of Office 2003 on the other computers it just doesn’t make any since! When...
  3. P

    Weirdest Date Problem

    this is the weirdest problem ever! Im using the ActiveX controle Calander thingo :) to get a date and drop it into a Text box Private Sub btnSetTo_Click() Me.txtToDate.SetFocus Me.txtToDate = Me.calTo.Value Me.calTo.Visible = False Me.boxTo.Visible = False Me.labTo.Visible =...
  4. P

    CSV file from HELL

    Hopfully this is the right area for this i have a big problem i need to be able to make a CSV file from the information on a form which uses sub forms and all sorts and also mustbe layed out exactly the same as a csv file that a few major insurance companys use complecated hay! :) the only...
  5. P

    pass value to a query

    i need to have a button that will take a value and use it to open a form that takes user input from a query before its opened. in this case a box pops up asking for a refno. is there a way i can automaticly make it so it puts in a certan refno by pressing the button on the first form? thanks...
  6. P

    item no automaticly work out what number

    I need my product list to automatically increment the item no collum offcourse normally I could do this with auto number or something but that just increments over the Entire table not for just the few items related to the insurance job. I have attached a screen shot to explain what I mean a bit...
  7. P

    close form when record empty closes everything

    i just added to my forms that use Quires Private Sub Form_Open(Cancel As Integer) If Me.RecordsetClone.RecordCount = 0 Then MsgBox "ERROR: There are zero records in the data source!", vbInformation, "No Records Found" DoCmd.Close acForm, Me.Name End If Problem is this...
  8. P

    need a if stament on a report

    i need to have like a if statment on a report. If adjusters code = "NA" then dont display adjuster details and display insurer details.. else dont display insurer details and display adjuster details. but i keep geting the message that the text area needs focus. but i cant set focus on a...
  9. P

    Report not displaying all records on second page

    the report uses a sub report to display a list of items and prices it works fine untill you fill up the page it creates a second page with nothing on it if need be i can zip up the database for you to have a look at Thanks Heaps!
  10. P

    query Sum Calculation

    i need to work out the total of a colume in my query but when i use sum its just telling me the value in the last record in that colume if ya need anymore info just tell me thanks heaps!
  11. P

    data grid or something the same

    i need a way of entering lots of items into a form or viewing this list of items and editing them. much like how the DataGrid in VB.net works ive been siting here scratching my head wondering why there isnt just a grid in access for entering data using a form. list box Sort of dose what i want...
  12. P

    multiple items to a claim

    I have to redo the company I work for’s insurance program and they want it done in access. I’ve hit a big snag though. Not only are my Access skills very rusty. But also I have a very complicated task here! :) I would need a customer table an insurer table and an adjuster table. These tables...
Back
Top Bottom