Search results

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...

Like I said I have no experience with data sources I dont know where the data source is and where to find the fields that are in it.

The field is on a form with all the other merged information (name, address, phone number etc) which all of those fields merge just fine but the Add_City field when I merge says it does not exist and is an invalid merge field in the data source. I took this database over from someone else who...

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...

The form is set up by rows, 1 row per individual that are just listed one row on top of the other (sort of like an excel spreadsheet) and contain name, address, phone etc, when I print the first 50 or so come out on the first page and the rest of the pages come out blank. I'm not sure if there...

All the records are of individuals that are already input by the users so there are no blank ones. I've never created a report before, would I be able to just copy paste the code from the Form to the Report?

The form has about 2000 records listed in it, and when I print even using the dialog and enter the page range it will only print what can fit on the first page of paper and then the rest just come out blank. I can't upload a screenshot because all the records listed contain confidential...

I guess the logical fix is to swith the form into a report...I'm fairly new to this so is this something as easy as copying the code from the form and pasting it in a new report or will I need to create a report from scratch?

Well nevermind on that working great. The first page prints fine but then the rest of the pages are just coming out blank.

Thank you! the print dialog seems to be the solution. and it was already set up as a form when I took over the database, not sure why it wasn't created as a report but it seems to be working great now that the dialog opens up.

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...

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...

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...

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...

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"...

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...

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...

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...

Found the problem, I was focusing on the Exit button when I needed to focus on field B. Thanks

Ok, so I got it to require Field B if there is data in Field A using if statements.* But now, if I do not have any information in either field, the close button becomes inactive.* Here is what my code is looking like. * Private Sub cmdClose_Click() *** If Me.CloseDt >= 0 Then ******* If...