Search results

  1. M

    Update Records in another form!

    Hi Everyone, I designed couple of forms, one for applicant and one for Stats on that Applicant. Problem is Stats Form contains some fields which are same as on Applicant Details form. If user changes the details on Applicant Form they need to be changed on the Stats form. If it's a New...
  2. M

    Can't Select an Item from Combo Box...

    Hi All, I'm having problem with a Combo Box, It's in a help form where user can select a Category and thus it displays certain topics on that category. Problem is when ever I call the help form form Main Menu or any other screen, I'm can't select any item from drop down list. It does not...
  3. M

    Duplex Printing Option for Report

    Hi, Is it possible to set a Macro or by use of Code, user can print duplex report i.e. two sided. I have looked in help and found this PrtDevMode, which contains duplex as member. I couldn't figure out how to use so, when user click on print licence it prints two copies of it using duplex...
  4. M

    Margin Settings for Printing

    Hi, i used a Macro to print letters and a Licence. Sytem is used by multiusers but problem occurs that every now and than page margin settings i.e. Top, Bottom, Left and Right are been set back to default i.e. 25mm. Which results in letter and licence been printed on severl pages! Is there...
  5. M

    Blank Field

    Hi, I created this report i.e. Letter to cutomers. In address fields the Address Line 3 can be blank and I was just wondering if there is a way to shift fields up, I know this sound crazy but worth a try! i.e. 12 Roadway Anywhere (Blank Address Field) St Peter Port Guernsey If there...
  6. M

    Part of Feild

    Hi, In Query I'm trying to output Tenant No using using following criteria: Left ([Tenant_No],6) In order to output last 6 digits of Tenant No. But I'm getting no records at all. Any Suggestion ???
  7. M

    Goto Record

    Hi, I had this problem before but was resolved with help from a Member. I'm tryong to rin a macro whihc jumps to a new form with matching field. Problem is the source form is based on query, so Access is giving error for incorrect use of Brackets. I tried to rearrange but it didn't work. I...
  8. M

    Search Field

    Hi There, I used a text field to enter the text to be matched and used macro to match the record. say to search a name, user will type in NAME, and click on secrh by Name button. It works and serch the matching record but I cannot figure out how to edit it so user can scroll throuhg all the...
  9. M

    Goto Record Problem

    Hi there, Well, I got these link buttons on forms to jump from say Case Details to Tenant Details. I used Macros to close the current form and open the target form say Tenant Form. But what I tried was to move to the same Tenant Record which was last viewed in Case Details say Case Details...
  10. M

    Using command button to Hide or Show Object

    Need help on how to control an Object (Calendar) so, on click of a button user will be able to view and when click button again or deselect make it invisible.
Back
Top Bottom