Hi
I've got an activity logging system in which users add their daily activity. As an information check, I would like to generate a report which identifies days where the user has omitted to enter activity for given dates.
Is there an inbuilt function that Access has or can anyone point me in the direction of some code?
All help greatly appreciated.
I have a field on a form (exception) that is also a column in a query. I would like to create a report an only show those records that had an exception in it. I am not sure what criteria in the query to use, but it would seem creating a report off of this query would work.
View 1 Replies View RelatedI have a data base of over 40,000 accounts. When I run my quires I am able to find accounts that may have errors and have them reviewed. Is there a way to exclude those accounts when the query is run again? Something like a table of exceptions to the query? I am unable to remove the data from the data base and with more then 40,000 accounts it would take a very long time to manually do it. Thanks.
View 1 Replies View RelatedError Type:
Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'Open'
/bingohopasp/post.asp, line 428
I am getting this error when trying to insert a record into a recordset. It also locks up access and the only way to free it up again is to reset IIS. The insert works with some data, but not others...I have two examples.
Successful Data:
"
The rules below have been constructed to ensure every member of the Bingo Hop Web Portal has a pleasant and enjoyable experience while here. Please read them and avoid breaking any, as failure to do so may result with your account being suspended or banned permanently.[RETURN][RETURN]
"
Unsuccessful Data:
"
The rules below have been constructed to ensure every member of the Bingo Hop Web Portal has a pleasant and enjoyable experience while here. Please read them and avoid breaking any, as failure to do so may result with your account being suspended or banned permanently.[RETURN][RETURN]
1. Do not insult, make personal attacks or be rude to any members or staff of Bingo Hop.[RETURN]
2. Do not post private information about yourself or other members of Bingo Hop, such as home/e-mail addresses, telephone numbers, credit card details, etc,...[RETURN]
3. Do not post meaningless posts, one word posts or anything that may be considered as spam.[RETURN]
4. Do make random/multiple posts in order to raise your post count.[RETURN]
5. Do not register multiple accounts with Bingo Hop.[RETURN]
6. Do not post racist, sexist or demeaning messages to the forum.[RETURN][RETURN]
We reserve the right to remove offensive posts without notice.[RETURN][RETURN]
While these rules cover most common situations, they cannot anticipate everything. As a result, we reserve the right to take any actions we deem necessary to ensure these forums are not abused in any way.[RETURN][RETURN][RETURN]
Sincerely[RETURN][RETURN]Bingo Hop Admin
"
Here is the asp code:
Set Conn = Server.CreateObject("ADODB.connection")
Conn.Open(ConnStr)
Set MyRS = Server.CreateObject("ADODB.Recordset")
strSQL = "Execute ADD_THREAD '" & Hold_ForumID & "','" & strTitleContent & "','" & strUserID & "','" & Now() & "','" & strThreadStatus & "','0'"
MyRS.Open strSQL, ConnStr, 3
' Retrieve last ThreadID inserted.
strSQL = "Execute GET_LAST_THREADID '" & Hold_ForumID & "','" & strUserID & "'"
MyRS.Open strSQL, ConnStr, 3
strThreadID = MyRS("ThreadID")
MyRS.Close
strSQL = "Execute ADD_POST '" & Hold_ForumID & "','" & strThreadID & "','" & strUserID & "','" & Now() & "','" & strPostContent & "','" & strPostIcon & "'"
MyRS.Open strSQL, ConnStr, 3 Line that fails.
Any help would be greatly appreciated.
Steve
I would like to know what the best way to input a duplicate record is with the exception of 1 field that is used to correspond with the proper parent of the record?
Here is an example of the problem, We receive a letter with pertinent information that corresponds to 30 of our facilities. I would need to enter this 30 times so that when the users of this information run their reports for their facility I can ensure that the letter would be referenced.
I am having an issue where a small percentage of my records do not follow my related Tables.
ex: 3 tables
tblEmployee
-intEmployeeID
-intWorkCenterID
tblWorkcenter
-intWorkCenterID
tblManager
-intManagerID
-intEmployeeID
-intWorkCenterID
where:
tblemployee.intworkcenterID -- tblworkcenter.intWorkcenterID -- tblManager.intWorkCenterID
Basically I have my general employee information in the tblemployee table, the workcenter information in the tblworkcenter, and the manager of the Workcenter in the tblManager. This is correct for 99% of the employee population. however, there are a few employees whose manager isn't the 'general' manager for the employees assigned workcenter.
How I can adjust an individual employees manager, while maintaining my structure? or would i have to go back and add the managers ID to a field in the tblEmployee Table?
I have a queries that do all the calculations and dumps the output to Query X for all different types of customers. At the moment I am required to generate a report for each of the customers and send it to them, manually.
End Goal:Initiate a Macro (at a given time at a given frequency) that would run a process to generate different reports for all different types of customers using a standard report template. I am also trying to avoid having to create a report for each customer (as the customer base grows, the report count will grow) so looking at something that would look into Query X and generate # of reports depending on number of customers.
Hi there, I have made a custom form to open up when I start a query which then enters the information I enter in the form, into the query. The query then produces the results in a report.
My problem is, I wanted it to display all the records when I leave a field blank. BUT when I enter a "Location/Contract", it brings up the records I want with that location/contract but it also brings up some records that don't have an entry there. Am I making sense?
If not, here is some screenshots:
I enter "Bridge Cross Rd"
And it brings up those without a location/contract...
Any Ideas?
The code for my report is:
Code:Option Compare DatabasePrivate shadeNextRow As BooleanConst shadedColor = 13356495' Const shadedColor = 15726583 ' alternative shade colors' Const shadedColor = 14078404' Const shadedColor = 13356495' Const shadedColor = 14281974Const normalColor = 16777215Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) On Error GoTo Detail_Format_Error' Choose a color based on the shadeNextRow value If shadeNextRow = True Then Me.Section(acDetail).BackColor = shadedColor Else Me.Section(acDetail).BackColor = normalColor End If' Switch the color for the next row shadeNextRow = Not shadeNextRow Detail_Format_Exit: Exit SubDetail_Format_Error: MsgBox "Error " & Err.Number & ": " & Err.Description Resume Detail_Format_ExitEnd SubPrivate Sub Detail_Print(Cancel As Integer, PrintCount As Integer) If PrintCount = 1 Then txtPageSum = txtPageSum + Cost End IfEnd SubPrivate Sub PageHeaderSection_Print(Cancel As Integer, _ PrintCount As Integer) txtPageSum = 0End SubPrivate Sub Report_Close() DoCmd.Close acForm, "Master"End SubPrivate Sub Report_NoData(Cancel As Integer) MsgBox "There are no records to report", _ vbExclamation, _ "No Records" Cancel = TrueEnd SubPrivate Sub Report_Open(Cancel As Integer)' Set public variable to true to indicate that the report' is in the Open event bInReportOpenEvent = True' Open Sales By Category Dialog DoCmd.OpenForm "Master", , , , , acDialog' Cancel Report if User Clicked the Cancel Button If IsLoaded("Master") = False Then Cancel = True' Set public variable to false to indicate that the' Open event is completed bInReportOpenEvent = FalseEnd Sub
And my Form:
Code:Private Sub cmdCancel_Click() DoCmd.Close End SubPrivate Sub Form_Open(Cancel As Integer) If Not bInReportOpenEvent Then ' If we're not called from the report MsgBox "For use with the Reports only", _ vbOKOnly Cancel = True End IfForm_Open_Exit: Exit SubEnd SubPrivate Sub OK_Click() Me.Visible = FalseEnd Sub
And for some reason this is what my Query looks like:
Any help?????
Is it possible to create a report based on a query which searches a table and counts the number of times a product has been ordered within a date range?
If so, can it be presented in a simple table showing each product and the number of times it was ordered along with the date range used?
Thanks!
I have a query that is filtering records from a table, I have used the Totals row in the query to Group By and provide Count of totals. The datasheet view of the query has the total row and is working fine. I would like to display the total row on a report, using the query as the record source.
It does not seem to be available, so I put a text box in the footer of the report with the Control Source set to: =Sum([CountOfPermit_Type]), but that only returns an error.
I have a report when i send units back to the customer, the report generates an ID in a list box (a query picks the last ID used and adds 1)
after the report prints i use an update query to mark the units as "shipped" with the dates in the main table. i need the update query to use the value from the list box to update the value in the table.
I have searched and searched for a thread before posting this, there are some discussions on related issues, but I could not find a solution. This is my problem:
I have a table with Incident_Type (a total of 6 selections from a combo-box), Incident_date, Incident_SubArea(25 selections from a combo-box), a check box for IsStaff_reported and all these are recorded by Incident_ID.
I have created a monthly report based on a parameter query that prompts for start and end dates using a custom form for incidents.
Now I need parameter (again start and end dates) cross-tab queries for number of incidents (i.e. count of Incident_ID) that are 1. IsStaff_reported, and 2. Not IsStaff_reported. to show up in a single report.
I dont know if that is too much to ask for or is there a simple way to accomplish this. Any help is appreciated.
I have a for form with a button to run a report. The report runs a query. The query reads data on the form to feed the report. The data that is from the table works fine but data from a text box on the form will not. It prompts for EXPR1.
In my query I have the following:
EXPR1: [Cnum]
[Forms]![FRM-Customer]![Cnum]
where FRM-Customer is the form with the button to run the report and Cnum in the text box data that I want to pass to the report. Every time I run it it prompts Cnum?
I have a report based on a query.There is a field in my personnel table and the query: [Field] with values from my lookup table and has three choices:
1-Inspections
2-Administrative
3-Safety..
I have a report and would like to filter based on [Field].I can filter by putting [Field]=Inspection on the Filter On Load, then typing 1 into the parameter box. And it works.I cannot however choose more than one of the three choices and I have to type the number in. Fine for me but it won't be for other users.it is used for more than one report. I would also like to avoid having seperate queries for all these reports.In other words, I would like to filter the report, not the query.
I want to be able to run a report based off my "Allot_Q" query. I have a button to perform the report but would like the button to update the query and run my report based on my selection text boxes. Right now I have one button the runs the query based on the selection and then another button to run the report. My boss wants one button to pull the report based on the selection.
View 1 Replies View RelatedWhen I make a search using a search form, I get a table with the results that match.Can I make a link from this table to a report to display the details of the matching product?One of the reasons I need to do this is because one search may bring up more than one product.
View 1 Replies View RelatedI am having trouble getting data to appear on my Report. The report is based of a Query, qryLabel. When I run qryLabel the correct data is displayed but when I try to use this data on the Report, I get an #Error or #Type. Here are the methods I have tried so far to get the data on my Report:
DLookUp
=DLookUp("[StoneLength]","Stones","[StoneName] = Forms![Product]![ProductID]")
Using The Query
=[qryLabel]![StoneLength]
Using the Table
=[Stones].[StoneLength]
Code:
Private Sub Command37_Click()
Dim db As DAO.Database
Dim rsItems As DAO.Recordset
Dim SQL As String
Dim currentItemNumber As Long
[code]....
adding record set in report and displaying a report..i want every record to pass thru recodset and create a report for every record separately
I am relatively new to writing databases in access, I did some a long time ago, but cant remember what on earth I used to do.
I have created a database with all the information I need it and have a query set up that gives different results depending on the information the user has entered
The user decides what the query will display though a form.
I want access to generate a report with the information in it that the query chucks out.
However the information the query gives changes every time depending on the user input.
I have a report already made but is it possible to import only one record from a query?
View 1 Replies View Relatedthere is a query and report "01 qry Main" and from the main FORM I like to print out into txt file actual record, my code is:
Private Sub Command24_Click()
On Error GoTo Err_Command24_Click
Dim stDocName As String
stDocName = "01 qry Main"
DoCmd.OutputTo acOutputReport, "01 qry Main", acFormatTXT, "D:10 DbaseCTQ stuffsaveReportFormat.txt", False
code]...
there should be an option "ID = " & Me.ID.Value or something like this to print out only actual record.
I have a table that gets updated by a query(For Invoices).When I query that Invoice table for the last record, I do not get the last one written. It stops at number 12. I am using the Totals option with Invoice number field and setting to "Last".is there another way I can get the last record to query correctly. I am trying to populate an invoice report.
View 6 Replies View RelatedI have a report which lists spend by customer. It is based on a query which requests the customer number I want the report for.
How can I get the query/report to offer a drop down list of the customer numbers available, so that I don't have to manually enter the number each time from memory!
Thanks in advance!
Regards
Peter
Hello All,
How can I create reports in Access based on dynamic queries? I did a lot of search on this but couldn't find anything reasonable.
Any help to get me started will be extremely appreciated.
Thanks
Using a table with employees, I created another with equipment that uses a lookup to assign each piece of equipment to an employee (more than 1 piece of equipment can be assigned to each employee)
I want to be able to select records using a form, either by checkbox or listbox of which employees to include in the report that shows what equipment each is assigned. The problem I am having is creating the form/code to create the and/or query to generate the report.
I have a report that takes numbers from a query
as an example
To be migrated - 50
Migrated - 30
Excluded 10
were each number comes from a query field..Can I add say Migrated and Excluded within the report and possibly other calculations that I may wish to include.