Search results

  1. Dragonchaser

    Exporting blank form to XML

    Access Masters, I'm trying to export a form to XML/HTML for users to be able to fill in their field data without having access to the entire database. I want basically to generate a blank form record with all images, formatting, design, etc. in tact to be filled in by users, but when I try to...
  2. Dragonchaser

    Edit Cell & Print Loop

    Hey AP, Getting upset with this one as it's probably extremely simple, and I'm just missing something. :rolleyes: I'm made a Click box Assigned to a macro that simply needs to add 1 to the number in the cell (always an Integer>0), then print the sheet, add 1 then print sheet again. It should...
  3. Dragonchaser

    Records vanished from a Form?

    Hey AWF, I have no idea what I've done... :confused: When I goto my form I can no longer cycle through the records, but the records are still there in the table (the form's Record Source). I was double-checking field properties to make sure everything was ok and, oops, all the records are...
  4. Dragonchaser

    Access asks for Parameters when I preview my Report?

    Hey All, Quick one for you. I try to go to the print preview in a report and Access asks for Parameters for 20 or more different controls in the reports, like I was querying every field. So I have to press enter 20 or more just to preview. :confused: This only happened after I copied the fields...
  5. Dragonchaser

    Graphics in a form (show/hide)

    Hey AP.uk I've got Form with some drawings on it and I'd like it change depending on what the user has entered in certain fields on the same form. For Example: when the user selects a certain type of item in the "Item1" field, I'd like the graphic to change (or another one appear) in the form...
  6. Dragonchaser

    Printing only one (current) record in a report

    Hi Everyone, I'm probably going about this the wrong way all together, but what I'm trying to do is print a single record from a form in a report. Basically after the client fills in the form they can print their "results report" using the click box (command button) in the bottom corner of the...
  7. Dragonchaser

    Validation Rule Problem...

    Afternoon All, I've been having problems getting a field in a form to check the value in another field (in the same form) based my Validation Rule. Example: When the user enters "Item 1" into Field1 it checks to see if the value "Item 2" is entered into Field2, because if Field1 has "Item 1"...
  8. Dragonchaser

    Checking for 2 Nulls with IIf function

    Hey there, I've been trying various types of syntax to get this to work to no avail. I need to check if a field is Null (used IsNull) and check if another field Null as well before having the IIf function return a true and false value. I've tried this...
  9. Dragonchaser

    Return a Value from table when...

    Hi All, I would like have a control in a form return a value when 3 fields in the form match 3 different fields in a table. The value a want returned is the 4th field in the same record as the 3 matching criteria from the form. I've tried a long dlookup expression with no luck. It always...
Top Bottom