How to take a screenshot

Is there a way to take a screenshot with vba? (Ideally of just the active form). I want to send it as an email attachment.

Sponsored Links:

Related Topics

How to drive the table shown in the screenshot from a given table?
How to drive the table shown in the screenshot from a given table?
Please, have a look on the screenshot in which you find the given data and the required table. Is there a way in access to obtain the required table (shown in the screenshot) AUTOMATICALLY


Insert object to command button
learning on the side of my desk, not too sure if this is the correct board but -

Where necessary, I use Powerpoint to paste screen shots, and name the presentation file to correspond to the record id.

What I need is two buttons a link / insert button and a view screenshot button.

Essentially, I need to be able to press the insert button and it will bring up the insert hyperlink dialogue, upon selecting the file to be linked, I need the hyperlink to be stored in the corresponding hyperlink field on the table with the second "view screenshot" button associated to this same field so pressing this button will load powerpoint and the subsequent screenshot.

Can this be done, if so please can someone give me a hand


Query filter search
I have a form used to search through customer records. 'F_Booking Customer Search' (See screenshot) and the query behind it 'Q_Booking Customer Search' (also see screenshot) which filters down customer details based on the more information the user enters into the search fields. When the form first opens it should show all customer records.

The query is refreshed on every key stroke entered into any of the search boxes, as with the screenshot I've tried to show this . . . 'sh' has been typed in so far and returned all records in the surname column beginning with 'sh', then if the user were to type something into the forename search box that would then further filter the information.

This works except it only includes fields that have any data in. So if I have a customer that has all fields with data in except say 'Forename' then it won't show that record at all.

I tried to over come this with this in the query : =IIf(IsNull([Forms]![F_Booking Customer Search].[TxtForename])," ",(Like "*" & [Forms]![F_Booking Customer Search].[TxtForename] & "*"))
but sadly this just didn't return any records at all.

I'm having a mental block and can't work out what to do next?


VBA code to update tables through check box?
I have this form in my database.

I need to figure out how to write the code for a button at the bottom of the checkboxes so that when clicked.

1) the check boxes that are selected will update in the master table, delete out of the audit table, and remain the same in the replica table

2) the check boxes that are not selected will still have the current field data and will not make a change to the tblMaster but will revert tblMasterReplica back to what it was prior to the change

- I have a form to change view the records out of the tblMaster that is locked from editing. This is used by the other non-Admin users.

- I have another form that can be used to submit a change request to one of the records (looks like the display form except it is not locked).

This information is then moved into tblMasterReplica (does not show in the view form). It is also displayed in the audit table to show who made the change, what time it was made, & whatit was changed from and changed too (new record is on top of the other in table).

- The audit form is what is displayed on the "Updated" column in the screenshot and the tblMaster is what is displayed in the "Current" column of the screenshot.

- The screenshot is only one tab from the form, I used the tab control because there are about 65 fields for each record.


Appending multiple rows into one (Shopping Cart data)
I'm importing orders into Access 2002, the csv file is from eBay. I've stumbled into a problem with orders with 2 or more different products for each sale.

I've attached a picture so it's easier to understand my problem.
As you can see, rows 3-5 and 20-25 contain multiple products.
Once this file is imported into access, each row gets its own record, what I want is for orders like this to be appended to just one record in access

EG, I have fields Product Name 1, Qty1, Product Name 2, Qty2, Product Name 3, Qty3, etc in my database, so .

row 4 "Item Title" & "Quantity" in the screenshot would be appended to "Product Name 1" & "Qty1" in my database on the same record.
row 5 "Item Title" & "Quantity" in the screenshot would be appended to "Product Name 2" & "Qty2" in my database on the same record.

And so on.
The only unique identifier is the first column in the screenshot "Sales Record", rows 3 to 5 and 20 to 25 have the same Sales Record


sum iif error
I Try to put in a control source from a report the expresion

=Sum(Iif([Id_Tip]=6,[Supr],0))

but doesn't work
I receive the message
[IMG]file:///C:/DOCUME%7E1/User/LOCALS%7E1/Temp/moz-screenshot-1.png[/IMG]The expression you entered contain a invalid syntax

Id_tip and Supr are numeric field in the record source of the report (query)

Any ideea? Seems to be a simple error
[IMG]file:///C:/DOCUME%7E1/User/LOCALS%7E1/Temp/moz-screenshot.png[/IMG]


Sending reports
I have created a button on one of my forms to send a report to an email recipient. It has worked quite well in the past but something has changed and it wont work anymore. There is an attachment of a screenshot of the error. Im running access 2003 and xp-pro


Query Creation
I am a relative noob with queries, so this will probably be a simple fix:

In my database (which I attached a screenshot of below), I want to take any records which are of the purchased status in the Status_printer table and create a query so that they shouw up in the purchases table. Does anyone have any suggestions on how I can do this


Button macro's.
I want to make a button that adds a new record when I click it, But not just on the very last record, I want the new record to be spaced with a record in between.

I have no experience with the programming language and I am very new to Microsoft Access.

If you have trouble understanding what I mean I could upload my database / screenshot to help you.


Attachments with file name
After attaching a file into Microsoft access it just shows me a logo of the attachments in Sent Files and Feedback Files but how do I get the file name to appear next to them as well? Is there a code that needs to be written to do so?
I attached a screenshot to show you what I am talking about


Attachments with file name
After attaching a file into Microsoft access it just shows me a logo of the attachments in Sent Files and Feedback Files but how do I get the file name to appear next to them as well? Isthere a code that needs to be written to do so? I attached a screenshot to show you what I am talking about...


Access 97 to 2010: "The current user account doesn't have permission to convert
I've got an Access database that my workplace uses to track basic information about visitors. The database was likely built in Access 95 and is being regularly used in Access 97.

but I hit a roadblock early in: Apparently there are security settings on the '97 database that prevent anyone from opening it in Access 2010.

I receive the following message:

"The current user account doesn't have permission to convert or enable this database."

like "join the workgroup that defines the user accounts used to access the database", have "exclusive permissions" to open and run the database, etc.

I never got into security much with Access '97. I read that it was pretty flawed. In any case, I'm not sure what I can do in Access 97 to open this system up to Access 2010 users. Ofcourse, but I can't do that from Access 97.

I've already found [LINK], but it only applies to Access 2002/2003 databases.

I can open the database in Access 97. In the "User and Group Permissions" dialog box there are two groups ("Admins" and "Users") and one user ("Admin").

I've attached a screenshot of the "User and Group Permissions" dialog box in Access 97 and a screenshot of the error in Access 2010.


Counts in reports
I am very new to access but have managed to create a table and a form in access 2010.

Now, I would like to create a report that counts the number or records entered for a particular date. Please see the attached screenshot for my table.


Date not Sorting Correctly (screenshot attached)
I cannot seem to figure this one out. The date is not sorting correctly on this query, see below:


Date not Sorting Correctly (screenshot attached)
I cannot seem to figure this one out. The date is not sorting correctly on this query, see below:


Invoice in Report.
I am trying to make an invoice report on Access and I've come across a problem. When I have two of the same invoice numbers that includes the same customer but different parts, it generates two invoices when viewing it in report.

Is there any way to have one invoice and the parts simply underneath each other? I am probably not explaining it right but here is a screenshot.


Normalisation and Relationships problem
I'm very new to Access databases and I'm trying to set up a system for a DVD rental shop. At the moment I have my tables set up as in the attached screenshot, but I've been told that this is not normalised and won't work properly.

Apparently I need to add another table. I'm also not sure what type of relationships I should have.


Making report flow horizontally
I have a simple database where basically exist A group of values and B group of values, and more than one B value can be assigned to a single A value. When I create a report, I see that B values for each A value grow downwards. The question: is it possible to make them grow horizontally, so that it would look like

rather than like in my screenshot


A question about Checkbox Queries.
I have a table for volunteers with the days they are available on checked. I want to create a query that would allow the user to enter the day and the query will give the names and contact information of volunteers that are available in that particular day. I attached a screenshot of my table. Just add the www because the system didn't allow me to post a link
I hope you could help me. Thanks

mediafire.com/imageview.php?quickkey=m512690to3u95n0


Showing a 'New' Button
I know there is a way to show a conditional 'New' field button or something similar to that in the screenshot on the next available table record.
Code:

=IIf(IsNull([LinkerID]),"(Add)","Remove")

I have tried to copy the method behind this from another of my tables which works but it is not working this time around. It looks to me like the next available record is not being displayed in my datasheet.