Ok I saw this posted up in the forum but it was not explained.
I have a Query which asks for a parameter before giving an output.
I have a report that uses this query to display the information.
Ok what I am trying to do is create a form that has a textbox and I enter the parameter's information in that textbox or textbox. How do I send the information to the query?
The reason for such a thing is people tend to not follow the set guidelines for putting stuff in a parameter box. So what I decided to do was set up a calendar form which a person has to physically choose the date from the calendar and this leaves no room for real error. My problem is I can get the calendar information to the textbox or textboxes but can't figure out how to code the button to send the textbox information to the query & parameters & report, etc...
Can someone please help me out of this situation? or point me to a starting point?
I want to develop (create) a database using MS Access 2007 or 2010 about Amazon.com.
My ideas are:
1. Create a form to lookup items in the actual amazon website, and then sort the results of the search. 2. View the results. If I select Add to Cart or Add to Wish List, send the item information to my Access database.
Private Sub jobdatebox_GotFocus() Dim dteFormDate As Date dteFormDate = CDate(InputBox("Enter the date:", "Date Entry")) Me.jobdatebox.SetFocus Me.jobdatebox.Text = dteFormDate
the above code pops up an alert and asks the user to enter a date. this value is then stored in the jobdatebox control (jobdate field)
the jobdate field is a Date/Time datatype and is the first item on my form so when the form opens this pop up appears instantly (which is fine)
they enter a date as the following: 6 6 and it displays as 06/06/2006
my user tabs through the fields, inserting a record.. when they reach the last field.. and tab again (to enter another record)
the pop up alert appears again..i dont want this.. i only want it to pop up the first time (when the form is opened) and then just keep that value in the jobdatebox for the remainder of the form's open session
i need something that does the following..
on new record creation jobdatebox.value = dteFormDate (the value entered previously)
OR
Private Sub jobdatebox_GotFocus() Dim dteFormDate As Date dteFormDate = CDate(InputBox("Enter the date:", "Date Entry")) Me.jobdatebox.SetFocus Me.jobdatebox.Text = dteFormDate for all records entered until form closes
OR
just before new record is created if jobdatebox = not null (has a date value inside already) then newrecord.jobdatebox = previous record jobdatebox.value
On my form I have a tape Textbox where I put tape numbers in that is on a other table inside my access file (for now I just type a tape number in), then save the info to other table also inside access file.
I want to know how can I make it that if I put a tape number in the textbox, it must look at the table for tapes, and if the tape number is not in the tape table, it must not let me use the wrong tape number that is not in the table for tapes.
hi, i have list box and the source coming form Query. i want when i click on one in list box want it will show [faults] field in textbox from query the field [faults] is a memo can someone help me __________________ David
I have a button that when I press it it goes to new screen where I can add new data in, and then save it.I have 10 texboxes in this form, how can I when press the button to add data let it on 3 texboxes show info eg. 4321MAG01- and when I am on the new form I can change or add to it. eg 4321MAG01-123
Basically, I have a database table that is maintained every week. It is about e-mail account licenses for Office 365.
Each column represents a week of license data for every mailbox account which is about 10 000 plus users with the date as the field headers( something like "License information as of 06122013").
Basically, I have created 52 queries based on the license type I require to be calculated & I have a form created to control it. However, right now it is all output only as I have yet to create any user parameter to specify on any of the queries about the date I want
As I am currently unsure how to specify all the queries to use one field date header which I want the user to specify via drop down list in order to calculate all the licenses on this specific date.
For example, if I want to see the license information for 06/11/2013, I would choose "License as of 06112013" & it would then run all the queries based on the header specified earlier & output that information on the form.
Right now the queries are all configured as the "Select" type.
I have searched the form and what I am trying my best to do right now is create a form with a textbox and a button. In the textbox I would just put in the parameter of a query and the query result or report would open up that is based on it. Can someone give me an example or point me in the right direction.
The reason im trying to do it this way is I would be able to customize the form to go with the rest of the database's layout....
I am wondering if it is possible to send a report as xls file and keep the format exactly as the report looks.When I try to send it now, it automatically changes back to the column names from the table, which I in the report have changed and want to keep in my excel output!
I'm having a very simple issue (I think) trying to pass a textbox value as parameter in a sql query.I have a multiline textbox and I use it to find several values in the database, so in this textbox all the values are pasted each per line and I have a small code to convert it to single line comma separated values.This is an example:The user enter the data:
[Text0] A1C556CC3C-TNNN C010070H13
The code convert this data to a single comma separated string and runs the query: ex: "A1C556CC3C-TNNN","C010070H13"
Code: test = """" & Replace([Forms]![Search]![Text0], Chr(13) & Chr(10), """,""") & """" [Forms]![Search]![Text0].Value = test DoCmd.OpenQuery "FindPartNo", acViewNormal, acReadOnly
In the SQL code I use the IN operator to find the exact value for each record:
FindPartNo sql query:
Code: SELECT Classifications.BU, Classifications.WisperPlantID, Classifications.PartNumber, Classifications.PartDesc, Classifications.US_CL_Code, Classifications.MX_CL_Code, Classifications.TARIC_CL_Code, Classifications.COEProject, Classifications.Supplier, Classifications.BrokerRequest, Classifications.CreatedBy FROM Classifications WHERE Classifications.PartNumber In ([Forms]![Search]![Text0]);
The problem here is, the query doesn't return results but if I modifiy the query and I put:
Code: WHERE Classifications.PartNumber In ("A1C556CC3C-TNNN","C010070H13");
... the query returns the correct results.I'm passing the value incorrect into the sql code?
I have an unbound form with an associated report. When the user hits the 'print' button on the form/screen, the report is launched in the background. In the On Load event of the report I populate the report fields from the forms field as so:
This works like a charm as long as I call the report in Print Preview mode (i.e. with acViewPreview). But if I send the report directly to the printer, none of the fields print.
I've read about using other report events to populate the fields (e.g., On Format and On Print) and also something about using TempVars to pass the data. But I haven't read anything that's clear and definitive about the full answer.
Gooday all, i have a table that consist of 3 columns, name, address and telephone number.
The table consists of about 20 records. What i would like to do is simply show one by one all the names from my table sequentially upon clicking a button on my form. I dont mind if its shown within a label or text box on my form. I would see something like
"Processing <persons name here>"
with a interval of 10 seconds between each name. Any ideas?
I am creating a database for a user that has a health & safety report form on paper that he would like replicated on screen on a form that he could fill in. Is there a way to do this? If not any ideas of which way to go from here would be much appeciated.
I'm a genealogy nut and not so great at computers. I've got a report on cemeteries that gets things like a cemetery number, peoples names and tombstone information from one table. Got that working pretty well. I've got it to print the cemetery number in the detail header (there are 300+ cemeteries each with 1-100s of people in each). I want to take that number and use it in a different table to get travel directions and GPS for each cemetery.
Im new to access and i have a problem!! I have a report that i need to be sent out monthly to 3 people. The problem is i dont know where to start. I have been looking through the forum, but nothing that i can get my head around, so there anyone out there who can help???????
I am trying to send an MS Access 'report' as an attachment to a mail recipient in rtf format without success. Everything seems to work fine except the 'send' button. Click away and nothing happens.... no error messages, no nothing. Any suggestions or tips on how to make this work?
I use this to send email msgs through gmail, found it on the net somewhere, adapted a bit and it works.
Code: Private Function fSendGmail() As Boolean 'Returns True if No Errors are Generated On Error GoTo Err_ErrorHandler fSendGmail = True Const conStrPrefix As String = "http://schemas.microsoft.com/cdo/configuration/" Const conCdoSendUsingPort As Integer = 2
[Code] ....
Err_ErrorHandler: If Err.Number <> 0 Then fSendGmail = False etc, etc End Function 'fSendGmail
I'd like to send report attached to this as pdf or rtf. How should I go about it. I know how to create pdf and save it.(DoCmd.OutputTo acOutputReport, "My Report", acFormatPDF, strPath, True) But where do I attach that here? Is it necessary to save the file first?
I use a macro that attaches a document automatically to an e-mail address ready to send this report is governed by a query of which the criteria is " loss order number " this is in a pdf format of which I need if possible
The problem I have is the same pdf file keeps attaching itself to the e-mail no matter which loss order number I select. The reason I think is because the report is called NCR so it is not changing from the previous one. What I think can solve it but not sure and don't know how to do is get the " loss order number " within the report name.
If I just send the report to a file direct it does work as I am prompted for a file name
Can the loss order number get into the file name within a macro/vba
I want to sent out my report as a pdf file with my macro.. I've been trying to use the VBA
Code: Option Compare Database
Sub Fix1() DoCmd.SendObject acSendReport, "MarketRiskControl_HighestDiffs_AsOfCurrentDate", "PDFFormat(*.pdf)", "my mail@mail", "cc", , "SD Counterparty Report as of Current Date", "Regards, Trading Risk Control", False End Sub
How to create a new folder through the MkDir function, but my problem is, I then need my report to go to the new folder I just created.
For example: the path is = "VAIOUsersDocumentsTownship" & Me.[Owner Name].Value
When I try to send the report there.. it only goes to "VAIOUsersDocumentsTownship" and not the new folder created titled with the owner name... the Me.[Owner Name].Value ends up getting set as the name of my report, in addition to the report name which is defined as the number.
My actual code is listed below:
Private Sub cmdFileReceipt_Click() Dim strMyPath As String If Me.cboMun.Value = "C-Town" Then strMyPath = "VAIOUsersDocumentsC-Town" & Me.[Owner Name].Value
I have a report in my DB that displays the results of several queries. How can I have the information displayed on my report entered into a table as a record when the report is generated?
I have a report in my DB that displays the results of several queries. How can I have the information displayed on my report entered into a table as a record when the report is generated?
I have a query from a colleague for their database.They have a report which lists a name and contact info - at the moment this is set in the report. However noone has the ability to edit the report outside of developer mode (hence why I'm being asked!). This information will change very infrequently but I'd like to set up something within the database so that they can change it as and when needed.
How would be best to do this? It will be the same contact person for every report until roles change. There is a tblNames which contains the necessary information (although phone no. and e-mail are yet to be populated).
I was thinking adding a field to tblNames as Yes/No to state who will be the contact (ensuring they know to only select one person at a time) and using a SELECT...WHERE line in the unbound textboxes - however this returned #Name? in all fields.