Search results

  1. S

    Problem with form opening by double click

    I have a form called 'MainOpen' which is basically just a list of all the records in the database. I have it set up so when you double click the name field of the list a new form will open with more detailed info about that specific record. For some reason when you double click the name the new...
  2. S

    How to edit data source?

    I am trying to add a merge field to the data source but dont know how to actually do it. We have letters that are sent from Word and the data is merged from Access however there is an additional field that needs to be added. When I go through the merge process in word all the other fields merge...
  3. S

    Form only printing first page

    I have been given the job of maintaining and fixing a database that was created by someone else and there is a Reports page that is actually a Form and the other users will be printing this in database view not from design view. There is a "Print" button set up that is working perfectly fine...
  4. S

    VBA report printing issue

    I have a report that the users will be printing from database view not design view, I have a print button set up that is working perfectly fine except it will only print the 1st page of the report and its multiple pages. Any help would be great. Here is the code I have on the button; Private...
  5. S

    Printing report in landscape & legal size

    Hello, I'm having a problem with printing a report. I set the report to print in landscape but all the columns arent fitting on the page so I changed the page setup from design view to legal size paper but for some reason the last column is not printing even on legal size. I would be fine even...
  6. S

    Question Opening database

    When I click the icon on my desktop to open the database 2 windows open up. One is the database and the 2nd is the Microsoft Access "main page" I guess (not sure what it's called) kind of looks like the design page but with no dialog boxes or anything, nothing on the "main page" is clickable or...
  7. S

    Form Properties - Order By Issue

    I have several forms, all of which have a lot of data entries in them. Every one of the forms is to be ordered by Name...and I have all but one that works. No I compared all properties between all forms, but I have one form that will not order by anything that I enter in the "Order By"...
  8. S

    Docmd.applyfilter help

    Have a database when a record is entered 1 of 2 letter types is selected. Either "LNR" or "AC". Trying to make it so when the "AC" checkbox is selected for mail merge only the records with that certain Letter type are selected to merge. Tried this code on the checkbox but is not working...
  9. S

    I Need Immidiate Help!

    Please Help! I was attempting to create a .mde file, and it said I needed to eliminate of the amount of modules...so I went to a few of my forms and on their properties I selected "No" for Has Module...which ended up deleting my code for the forms, where does Access store its previously saved...
  10. S

    Help with setting user permissions/restrictions on viewing records

    I am wanting make my database so whichever user is logged in that they will only be able to view the records they have entered and not other users records. Not sure of this would need a code or just some setting somewhere but everything I've tried so far has had no luck. Any help would be great...
  11. S

    how to make a field required once data is entered into a seperate field

    Field A Field B I am trying to make it so that when data is entered into field A then field B becomes required, if no data is entered into A then B is not required. Any help would be appreciated. I am using 2003.
Back
Top Bottom