Printing Current Date
When I print queries (and maybe forms) I would like to have the date printed on the sheet so I know when I printed it out. How should I do this??
Thanks
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Printing Current Records
Hi Guys (again), Hope you can help and I'll explain this as well as I can but I've put it in general as it's a culmination of things. I have written a call monitoring database for a call centre (all good so far), but they want historical searches (again all good). I've written the relevant queries for these so that the searches can be done for Adviser, Manager and also by a date range. However, they now want to be able to print out the current search from the screen. The way I have done it is this. I have written the report be adding in a subreport and putting in the relevant historical search form, and then written a macro that is assigned to a button on the historical search form to print the current record. The problem that I am having is that when they click on the button to give them the history they fill in the relevant advisor or manager name and the date range which gives them the info in form format but, when they click on the button to print the current 'screen' if you like, it asks for the information again. I know this is because the actual report is written from the same query but is there anyway that it will just print what's displayed on the screen? I don't do VBA so if it has to be done that way could you please display it as it should be inserted. I do hope that that has made sense and that someone can at least help me, cos you're all wonderful and I've had some really excellent help in the past from this site. Thanks in advance. Donna x :confused: (as always)
View Replies !
View Related
Printing Current Record
This could go in forms or reports, I think but: I have a database which I am developing over time as I see ways of improving it and as I learn bits of vba. My current problem relates to invoicing (that I have probably created for myself!): I currently have two invoice report layouts because of different invoicing addresses. I now want to add a cmd button to my invoice entry form that will firstly preview, then print the current record. I found elsewhere in the forum a way of previewing just the current record by way of specifying in the underlying qry the ClientID so that it selects the record displayed on the form. I have this line of code which then previews the invoice: DoCmd.OpenReport "rptInvoicePrivateClients", acViewPreview This does not take account, though of the different invoice layouts. I think strictly speaking I should only have one invoice report, but what I want to say is this: If the client is a private client, then preview rptInvoicePrivate, Else preview rptInvoiceLocumWork I have tried entering this code that does not work If SolicitorID = "1" Then DoCmd.OpenReport "rptInvoicePrivateClients", acViewPreview Else DoCmd.OpenReport "rptInvoiceLocumWork", acViewPreview End If It comes back with a message that SolicitorID is not defined, but I have included Option Explicit. Any help please
View Replies !
View Related
Printing Only One (current) Record In A Report
Hi Everyone, I'm probably going about this the wrong way all together, but what I'm trying to do is print a single record from a form in a report. Basically after the client fills in the form they can print their "results report" using the click box (command button) in the bottom corner of the form. When the client clicks on the button it prints all the records ("result reports") of all the clients...no good of course. Here's the code for the button: Private Sub PrintSingleChamber_Click() On Error GoTo Err_PrintSingleChamber_Click Dim stDocName As String stDocName = "SingleChamberPrintOut" DoCmd.OpenReport stDocName, acNormal Exit_PrintSingleChamber_Click: Exit Sub Err_PrintSingleChamber_Click: MsgBox Err.Description Resume Exit_PrintSingleChamber_Click End Sub Can someone point me in the right direction? :confused: Thanks again, Mark
View Replies !
View Related
Printing The Current Record Which Has A Subform
Hello, I have done a search on this forum and found all the postings relating to printing only the current record for a report. I have a command button and have followed what these posts say. The report prints the current record but leaves out the data from the subform. The database is a recipe organizer. The main form is called Recipes and the subform contains the ingredients for each recipe. This subform is called Ingredients. I set up a command button with the following code: Private Sub Print_Recipe_Click() On Error GoTo Err_Print_Recipe_Click Dim stDocName As String stDocName = "Family Recipes" DoCmd.OpenReport stDocName, acNormal, , "[RecipeID] = " & Forms!RECIPES![RecipeID] Exit_Print_Recipe_Click: Exit Sub Err_Print_Recipe_Click: MsgBox Err.Description Resume Exit_Print_Recipe_Click End Sub Since the RecipeID is used in both forms and the report, I thought it would be the best field to use since it linked all the information together. So what do I need to do so that the subform data prints out on the report? Thanks GeekyGirl
View Replies !
View Related
Printing Current Record On Form And Subform
I currently am trying to print the current record that I have selected on my form and the subform that I have on the same page. If I try to print selected record it will only print out the main form correctly and will print out the first record on the sub form. I have tried to make a reprot of the current form and it only will do the main form and nothing from the sub form. I am willing to try whatever method would work in getting this to work. Thanks
View Replies !
View Related
Printing A Report Based On The Current (new) Record
Hi All, Having a problem with a report, I have a form that i use to enter a new record to my database, what I want to do is put a button at the bottom of the form to print the record (via a report) If I base this on a record that already exists, it works fine. However, If I have just entered the record the query the report runs off doesn't see the new record. To print that record I have to exit the completed record, then go back in to it and print. My aim is to remove this additional part of the process, I'm sure it's something really simple, but can anyone help? Many Thanks Paul
View Replies !
View Related
Current Date Querys
Hello, I have about 1500 records in a table. We use a form to search through the records to find info on certain accounts. We now want to only search through accounts that are current, so I made a query to see only current accounts. I switched the search form from going off data right from the table to the new current date query. Now when you load the form it says "running query" and the application stops responding. The query seems to load up quick in raw format.. how come the application freezes when searching using the query instead?? thanks, Matt
View Replies !
View Related
Most Current Date Query
Hi there, I am trying to put a query on my form which selects the most recent date of a members attendance from an attendance table and displays it in a text box, the code I am using is: Private Sub Text41_BeforeUpdate(Cancel As Integer) SELECT MAX(Attendance.AttendDate) as "LastAttended" FROM Attendance WHERE Attendance.membershipNo = Forms!Customer.sbfAttendance.Form.membershipNo End Sub Customer is my main form and Attendance is my subform. I think the mistake is that I dont have a field called last attended (you are not supposed to store data like this are you) and I need it to display in my text box (text41) on the main form Thanks in advance, Jon
View Replies !
View Related
30 Days From Current Date
Hey guys, I'm trying to pull data that has a due date within 30 days from the current date. I'm trying to use WHERE x <= Now() + 30 but I'm getting incorrect records. Can someone please help me out? Thanks.
View Replies !
View Related
Current Date In SQL Query
Maybe a simple question, but i do not know how to put the current date in the WHERE clause of a SQL query. The query i have so far: select [table1].*, [table2].* from [table1], [table2] where [table1].[field] = [table2].[field] and [table1].[enddate] is null After this there has to be something like and [table1].[begindate] < [Date] (where [date] is the expression) I know that with Date() or Now() the expression can be made, but i do not know how, please advise.. Thanks in advance
View Replies !
View Related
Date - Current Month
Hi, I hoping someone can assist me here, I've looked through the forum for other date related threads raised, but none seem to assist me with what I need to achieve. I have created a query with an appropriate date field, and I am can't seem to work out how to write the correct formulae to get the query to only show data with a date range for the current month only. I don't want the user to be prompted to enter any information, I want the query to automatically always, when in the current month only show data for the current month. Any assistance would be most appreciated. John
View Replies !
View Related
Insert Current Date!?!?!
Help! Im trying to get a text box on a form to always automatically insert the current date. This seems like it would be so easy to me but apparently im stooopid. Thanks to anyone that can help. ( I already have the field in the table, and its in the query)
View Replies !
View Related
Insert Current Date!?!?!
Help! Im trying to get a text box on a form to always automatically insert the current date. This seems like it would be so easy to me but apparently im stooopid. Thanks to anyone that can help. ( I already have the field in the table, and its in the query)
View Replies !
View Related
Sorting By The Most Current Date.
Hey all, I have what is probably a simple question. I want to sort my date field in a query by the most recent date. When I use ascending or descending it looks at the Month/day/year to sort it. I need it to look at year/day/month. Any help would be awesome.
View Replies !
View Related
Use Current Date To Change A Value In Records
I have a db that is a checkbook register. I use a field in each transaction record to tell whether the transaction is current or is a future transaction (if it is in the future then it doesn't yet affect my balance). For instance, if the item is not scheduled to be paid for two weeks (I schedule payments with online banking), I check the "future item" box, then that record for that item isn't included in the report that tells me my current balance. How can I automatically take away that check mark on records when the date in that record becomes todays date (or before today)? Because at that point it is no longer a "future" transaction but is current. I could do this manually but it seems like there should be a way to do it automatically.
View Replies !
View Related
Current Month / Date Problem
I have the following code that should populate the current month date range in the startdate and endDate fields of a form. I do the same thing for the current year and that works great. Can someone tell me what is wrong with the code for the month button. It displays 1/9/07 - 2/8/07. If the current month is September, it should give date ranges from 9/01/07 - 9/30/07. Private Sub cmdmonth_Click() 'Sets the Date From and Date To text boxes 'to show complete month (from start to end of current month) Me!StartDate = CDate("01/" & Month(Date) & "/" & YEAR(Date)) Me!EndDate = DateAdd("d", -1, DateAdd("mm", 1, Me!StartDate)) End Sub The code below works great for the year. It displays 1/1/2007 - 12/31/07 Private Sub cmdyear_Click() 'Sets the Date From and Date To text boxes 'to show complete current year Me!StartDate = CDate("01/01/" & YEAR(Date)) Me!EndDate = DateAdd("d", -1, DateAdd("yyyy", 1, Me!StartDate)) End Sub
View Replies !
View Related
Current Date/Time Field
I have a form with date/time field. I have the default value at =Now(). My problem is I would like for this particular field to stay with the current date/time all the time. I mean if I created a form last week with the date/time of 3/14/2005 12:54:34 PM and go back to the same form to edit something this week I would like for that particular date/time to be the current date/time and not the date/time from the week and time the original form was created. Thanks for any help!
View Replies !
View Related
Only Allow Date Entry For Current Month
Hello, I am a little familiar with Access but having a problem figuring out how to alert a user that the date entered on a form is not the current month. I was hoping to have a warning msgbox pop up alerting the user. I am trying to prevent incorrect date entry. Thank you very much
View Replies !
View Related
Using A Button To Add A Year To The Current Date.
Hello, i have an expiry date for my members and each year they need to renew it, so i would like to have a button that when clicked adds 1 year to the date. I currently have this query =DateAdd("yyyy",1,[Commenced Training]) as there membership will expire one year from their joining date. this is currently shown for hte text box expiry date. however i cannot work out how to make another one for the button so that when the button is pressed it adds another year and stores its. the image shows my example thanks
View Replies !
View Related
|
TRACKER
