Give User Ability To Select Different Time Frames On A Report
Aug 11, 2015
I want to give the user the ability to run a report but display records based on different user defined time frames. So when I run the report it allows (on the Enter Parameter Value prompt) user to enter 30, 45 60 etc (to represent days). The report then looks at all records with a start date in the next x days based on what user enters
For a separate report, I want to be able to run the same report but give user (based on drop down) ability to view all reports or only those from today's date only.
I have database that i am working on , i want to give a user a time limited accsess ( one week ) to the reports section for example !!
after a certain date he will require a password or the report button will be inactive ...
-at program start up , it will check for today's date if it is greater or equal to (lets say ) 24-9-2013 then it will change a field in an X table from "yes" to "no" ,
-after that the code will check table X for the yes no field , if yes then open Form A if no then open form B / or make report button inactive
how to do that in VB ... and is there is a better way to do it ? can it be done in the macro builder ?
How to proceed and what is the "accepted" version of events.I have created a report, a dynamic method statement actually, and want my user to be able select some data to appear in the report. Report is rptMS01, it is fed from a query and has some fields to automatically populate [Company], [Site], [Postcode] etc. All of the static text is in CanGrow textboxes to sidestep the report height limit. The report is opened by a button on a form which uses a macro to open only for the current site. All OK so far.
My boss would like a section/text box/subreport to select the personnel involved in each method statement and this to appear on the report. So, on clicking the button on the form which would usually open the report directly, some kind of intermediary selection form opens instead with a list of all personnel. User can then select which personnel to involve and on clicking OK this appears in the designated box on the report. A CanGrow/Shrink textbox would be ideal!
Do I need to include this in the current query which feeds the report? I know a listbox can have multiple selections but how would I reference this? How do I keep the other fields as well? Should I create a table with the personnel list?...
Selecting the "General" group as this involves SQL Server Stored Procedures (SP) and VBA code and Reports and and and...
Client has requested exception type reporting noting when a price in a Bill of Materials (BOM) changes.
I am thinking to solve this with the following steps:
1) EXEC SP to run "this week's" BOM reports, automated, figure out how to print to PDF or something 2) EXEC SP to run "this week vs last week" exception report. A giant nasty:
Code: SELECT cols.... FROM [xyz] LEFT JOIN [histxyz] ON [xyz].[partnumber] = [xyzhist].[partnumber] WHERE [xyz].[cola] <> [histxyz].[cola] OR [xyz].[colb] <> [histxyz].[colb] OR etc...
through each of the fieleds that are hooked up to change tracking. Run that SP once, then use that temp table to generate customized reports based on parts per product which had a change.
3) Update weekly state snapshot of all parts remembering this week's state... transfer data from [xyz] to [xyzhist], so TRUNCATE then INSERT commands.
Seems slow and monotonous, the snapshotting "shell game" aspect... perhaps I may wrap that all into a transfer SP and allow the data to stay right on the server as it moves tables.
I have a query that pulls up information on employees when they receive warning notices. I would like the query to give me some type of warning (report, email, etc.) when an employee has three or more notices.
I have a form with 7 List boxes linked to 7 Query's which in turn are linked to a table. Each list box if for a particular trade.
I am trying to select a person or persons from each List box and then have them sent to a report. I have Code to do one list box, but do not know how to link all boxes with code to a 'Open report' button.
The code I am using is as follows:-
Private Sub cmdOpenReport_Click() On Error GoTo Err_cmdOpenReport_Click Dim strWhere As String Dim ctl As Control Dim varItem As Variant 'make sure a selection has been made
Query SELECT s.contracttypename, sum(s.sumrtr*v.pct) AS [predicted $] FROM sumrtr AS s, varcurve1 AS v WHERE s.mdiff=v.monthodr and s.contracttypename=v.contracttypename GROUP BY s.contracttypename;
I have varcurve1 varcurve2 varcurve3.... I want to provide a mean (interface?) for user to choose varcurve1 varcurve2 varcurve3 to run above query.
for eample if user choose varcurve1 the query will run
SELECT s.contracttypename, sum(s.sumrtr*v.pct) AS [predicted $] FROM sumrtr AS s, varcurve1 AS v WHERE s.mdiff=v.monthodr and s.contracttypename=v.contracttypename GROUP BY s.contracttypename;
if user choose varcurve2 the query will run
SELECT s.contracttypename, sum(s.sumrtr*v.pct) AS [predicted $] FROM sumrtr AS s, varcurve2 AS v WHERE s.mdiff=v.monthodr and s.contracttypename=v.contracttypename GROUP BY s.contracttypename;
Well, I apologise now, because this will probably be badly explained, but anyway, I was wondering if there is a way to create a button in a form, which would act like a frame (or inner.HTML, etc). So for example ::
Button 1 | Button 2 | Button 3
And when you click "Button 1", it comes up with a certain section, and makes the others disappear, which could for example be a section of text, and a button to open another form, etc.
You get me? Sorry if you don't. I've always been quite bad at explaining this kind of stuff. If you don't, I'll gladly explain myself again.
We have a shift log that includes both personnel actions during any given day as well as operational actions. (We recently switched from a word document to an Access Database to allow multiple users to input events while another has the logbook open already (which you couldn't do with Word))
At the beginning of each day, my manager reviews the previous days log and forwards up pertinent data (some personnel, some operational) to our higher authorities. Is there a way to allow him to select which records he'd like to include on that higher-authorities report straight from the local-level report?
I'm not a fan of allowing him a "Save As" feature because that kind of defeats the data integrity purpose of an events log where he could save as an RTF and then edit any of the log entries without any checks or balances.
I want to be able to have multiple parameter queries, but the user needs to have the option of entering a parameter or not limiting the output at all. How do I let the user choose "all", or what do they type in so that nothing is excluded?
I would like to run a simple select query, where the CRITERIA is based on the user choice. I have a form with a combo box, with a few choices, and a button that will trigger a macro with one query for now. I can store the choice in to a variable e.g. "town", using Microsoft VB code. How can I transfer the variable to the CRITERIA field in the query, so whenever I chose a specific "town", my query will select the records for that specific town. I want to use one query, and I don't want to have to "hard type the criteria in to the cells' query", but I would like to use a variable that can change and will be read it from the user choice through combo box.
I've made a form where the user can fill in a field ID... and than by clicking on a button another form will be opened with the data of that person (with that ID that's filled in). But if the user fill in an ID that is not currently in the database, there will be also shown another form, but than with no data.. Now I want that if the ID is not known, to display a message or something (like "this ID is not known, try again") and not to open the form..
I've used the following code under the button:
Private Sub openenFormulier_Click() On Error GoTo Err_openenFormulier_Click
Dim stDocName As String Dim stLinkCriteria As String
I have Access2003 and a problem creating a simple method of constructing a union query.
I am using a commercial paradox databse that has a habit of creating a new table every time a certain action is performed. There is currently a set of 160 tables with identical fields. The database allows me to view data in these tables individually. I would like to pull the information together, from between 20 and 30 specific tables at any one time, and view the data in one table.
I have linked the tables in a an access database and would go about viewing the data by creating a union query containing each of the tables of interest. Then appending the info in these tables to a new table.
Unfortunately manually adjusting the SQL expression is a bit cumbersome to say the least I am wondering if it possible to select the tables of interest from a List Box on a simple form and have those selected inserted into the union query ?
Alternatively, the table names are actually a field within a different table. Another field within this table actually determines whether they will be of interest. So ideally I could query that table to tell me which tables need to appear in the union query. Again I would like the union query generated automatically as a result of that query.
I am confident, perhaps without good reason , that this must be possible ....
First quetion how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever. i am trying to build somthing like asp with two frames and a record set and i dont know how.
the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.
First quetion how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever. i am trying to build somthing like asp with two frames and a record set and i dont know how.
the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.
I am in the process of trying to build a template in forms for my boss to quickly enter information and construct a PowerPoint presentation from this information.
Basically, I have a form that he can enter information, but it needs to look professional (not datasheet view). Is there a way that I can make a subform and frame it, so that I can copy the entire form (not just the data) and paste it onto powerpoint? I need the formatting to be consistent and appealing!
I know you could select a date by using the show date picker as for dates in property and a calendar pops up. But can you select a time too, separately or together with the date? Together as in one field where you choose a date with the calendar pop up and then also choose a time for that date.The result resides in one field. I doubt this is possible.
If not possible, then have two fields, one is to choose a date with the calendar picker, another with a time picker, both date and time now will be in separate fields, can this be done?
Okay, i need to know if there is a way so that more than one person can be in an access database at one time. Both need to be able to edit, add, delete, etc. within the database.
Hi I am a first time access user so i would like you to go easy on me. I work in an export firm where I have to maintain Order Dispatch schedules for different customers with different products. I becomes very difficult as at the moment I am using Excel andd have to maintain different files for each customer. I was hoping if a common base for the same can be created in access so that i am able to input all data pertaining to different customes in a single table and get reports of the same according to my need.
Is there a way to automaticaly close a database after it has been open for a period of time? I am having trouble with users leaving their database open after use. This causes a problem when they shut down their computers at the end of the day not knowing that the database is still open. What I want to do is to set it so that after mayby an hour of inactivity on the database, the database opens a warning message. The user can then click on the warning message to continue working on the database or the database would automatically closes. Any help would be greatly appreciated.
I have a form that allows the user to select a record in a combo box. When this selection is made I want a 2nd form to open and give the user a place to enter additional info about that item selected. I have the forms working correctly but now I would really like to add the 2nd form to the first form as a subform but when I try this I get the message"The expressing is typed incorrectly or is too complex to be evaluated..." There are no fields on the first form that link directly to the 2nd form - because the combo box in an unbound combo (the selection in the combo box is what the 2nd form opens base on) I tried to add this as a subform with no parent/child info and I get the message stated.
I was hoping to make the 2nd form not visible until the selection was made in the combo box then make it visible for the info to be entered. Would really like it to be on the same form not as a separate form opening.I believe I just found that the reason for the message. It seems not to be a subform problem but is because the selection in the combo box needs to be made BEFORE the form can open. So now the question is - how can I make this a subform and avoid this error when the main form first opens. I will test the visibility and see if not visible until the selection clears this up.
I have a combo box that needs to only show approved values for any current data input but also be able to show legacy values (that were approved at one time but are no longer approved).How can I only allow the user to select from current approved values but still be able to pull a legacy record and show the legacy value.
Table structure
tblRepairReason ID (Nnumber) Name (Text) ApprovedValue (Yes/No)
The recordsource of the combo box:
Code:
SELECT tblRepairReason.ID, tblRepairReason.Name, tblRepairReason.ApprovedValue FROM tblRepairReason WHERE (((tblRepairReason.ApprovedValue)=True));