Recent content by barbados2010

I have a rental database and I print several contacts for leases etc. what I want to do is have a unique reference number or something inserted to the report every time that it's printed. What I am trying to achieve is to keep track of which tenant corresponds to the report (Lease) printed by...

I did that actually but when I do the shift+F2 I get an error " Identifier under cursor is not recognized" and I couldn't find any duplicates of the module either...

I had to create a new FE of a DB I was working on and in the new FE I have been re ceiving an error for a function that was previously working and I can't figure out why. On a couple of the forms there is a command button to send an email; the user is prompted if they would like to use a...

Long story short, my DB was working fine until I exported a new form from another DB (same DB, just another file) into my current DB and replaced it. Now when I click a record to open it I receive the error "Object doesn't support this property or method" how can i fix this?? the vba opens...

I did compact it and ZIP it but it is still too large..

Yes, it just has a few records for each section of the database; all dummy names and such....

Sorry, I can't upload it as an attachment here because the ZIP is 3 MB....

I'm a few steps away from completing my DB but I am having issue after issue and its driving me completely nuts and I am really at a loss of what I should do next. The issues I am having are with generating reports and having them filtered properly per record.... They just do not work properly...

No blank pages, all pages with data. Everything is within the page size and margins. Even when I go into design view and preview the report in print preview it will also have more than one page to preview (duplicate of the first page) when there should just be one.

I have several different reports that the user can print in my DB.. The problem is that when some of them print, instead of being one page only; they print 2 pages sometimes 3 pages of the report that should be only one page.... How can I correct this so that the report prints only one page?

One of my reports has a record source which gets data from a checkbox that was checked on a form. There is 2 check boxes and either one is checked to indicate the desired info. Since access only allows a number of 1 or 2 I want to use iif(optionvalue=1,"F","N") to show an "F" on the report...

What I am trying to accomplish is create a report in access that uses a particular customers data to create a report using their info to populate some fields where their name and address would go. I am a newbie to VBA so I was wondering how best to go about creating this action. Should I just...

I've got a database thats causing me a big headache and I can't figure out how to fix the issue. I'm pretty sure its in the code but I don't know because i'm not much of an expert in that area so hoping someone here can help me with this. I attached the db if someone wants to have a look into...

I need to add extra buttons to the code I already have for my ribbon. Do I need to change more than the code in UsysRibbonsor do I have to make changes to BasRibbonCallbacks also? I need to create maybe 3 extra buttons. Current code below (I had to alter the microsoft address to be able to post...

What would the process be if doing it with VBA?