How to take a screenshot
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
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
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?
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.
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
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
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
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.
I attached a screenshot to show you what I am talking about