Microsoft Access 2007

Access Tab Control Problem

I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code "[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]" and it would open the form I wanted.  I have however changed the form to put my subforms into tabs. Now...

data copy - paste from the same table not showing in a subform

I have an Access 2007 application for recording employee skills and competencies in a medium business. We have recently duplicated the application with a view to recording other employee skills of each employee. Normally, I would add each employees details via a form and an embedded subform,...

Dymo Printer programmatically with VB.NET

For a project i need to get the print out in Dymo LabelWriter Duo Printer. I am facing the problem in 1. How can i make a file with extension as *.lwl or *.d1l 2. How can i pass values to the file i had made above. I am using VB.Net , VS 2005 as IDE and MS Access 2007 as backend. Any fast help is...

Access 2007: VB code to make a button press link to a specific record in another form

The database is for a set of components. One of my forms shows details about each component on a separate record (the property "Default View" is Single Form). The other form is a list of all components by component number displayed all together (the property "Default View" is Continuous Forms)....

Microsoft Access 2007 starting errors, tries to setup on each staring

I have install Microsoft Office Pro. on a computer. Everything opens up fine except for Access. When i click on access to open it wants to install not open.

Microsoft Access 2007 - Code for connecting two related forms, bringing up same record?

:sigh: My database suddenly requires me to have my forms appear as read-only's (since my employees are too stupid to NOT going flailing around, typing madly for no reason). However, we still need to be able to edit the information. I've created a second form, mirroring the original, to be my...

Access 2007 - How to include option group on report

Hello, I'm new to Access so please consider this when forming your response. This has been driving me crazy and I've looked high and low on the 'net for a solution. I look forward to your response. I have a form with an option group. I've wish to have this display on my report. Take for instance...

Monthly Average in Access 2007

Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible - my VB sucks Thanks Riaan

Sum of Donations for current year

I have a query that sums donations and groups them by year. When I print receipts, it gives me two receipts -- one for year-to-date donations for 2009, and another that includes 2008 and 2009 donations. How do I get just the one receipt to print?

Microsoft Access 2007 Data Input & Report

I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 ...

Microsoft Access 2007 Query/Report Calculated Fields

I have a table with customer estimates and sales. I need a report to reflect the closure rate by total number of jobs within a given section (in this example subdivided by lead source). Each job can have multiple records. I need to get the % based on grouping estimates for specific jobs. (7...

VBA to print to specific printer with print button

In Access 2007 how do I use VBA code in my print button to print to a "specific printer" for my report.

Microsoft Access 2007: Using an IF statement

I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do...

Hotel database (Rooms availability) using Access 2007

Hi there... I'm working on hotel database (Access 2007) I have a table named Rooms There are 3 fields in it Room ID, Room type, availavility how can I make Access shows the vacant rooms which are not related to any guest?

E-mail Notification

Can Access 2007 notifiy me by e-mail when someone has added or made a change to my data file?