'lo all,
I'd like to use a form to get user input on BeforeDate and AfterDate for a query with criteria
<[BeforeDate] AND >[AfterDate]
I must be missing the wood for the trees- how hard can it be?
Thanks for pointing out the glaringly bleedin' obvious,
Alex
I have a parameter query using a form to collect the data. I put LIKE and wildcard enclosing the parameter to bypass the criteria if the data box is empty. It works well. I have another parameter of date type that uses between two dates. How can I bypass the criteria if I leave the data boxes blank?
View 8 Replies View RelatedI have a golf society database. I would like to be able to send, via e-mail, a 'Form' to each of the members of the society so that that they could fill in the data in the form then e-mail it back to me and then import it into the database.
Has anyone got any good suggestions on how I should do this please ?
Cheers
Frank
I am using and modifying (very little) the template "Issues and Tasks" to have my team of 35 people submit any feedback that they may have on a particular campaign.
No one has Access except for me....I would like to use the "Data Collect | Create Email" Feature so that whenever they have any issues they can just fill that out (Save the email in a special folder to be used multiple times). The problem I am encountering is that the "Create Email" button is greyed out and I am not sure why....also, I would like to know if this is the most efficient way of doing this.
This is a template under 'sample templates' : "Tasks". it has a button called " Collect data via e-mail". I couldn't test is because when i hit the button it says "microsoft out look could not be started, make sure outlook is installed and properly set up.( the send and receive dialog box in outlook shows is marked and read as complete, but the green bar showing progress is still lit up + calendar contacts,etc. wont sync in mobile device center).
View 2 Replies View RelatedI have a database that keeps track of employees absences and tardies but after a certain amount of time is the data valid. I want to be able to type into my text box a date and have the query collect all infromation a year back. I know how to do it if I was just using the current date but how do I pull the information from a date a user can input?
In the date field I have the following:
=[form]![selectdate]![date]< 365
I've even tried [form]![select]![date] - 365
Can someone help me out? :)
I have a database which is populated, but users have to review and amend the data. I was going to ask users to sign in to do this, however my boss wants the data collected via email.
I have looked at using the email wizard, but it produces a rather messy looking email form regardless of if I choose HTML or InfoPath. Is there any way to adapt the email to make it better, or maybe another way of emailing users (through VBA)?
Method 'Collect' of object'_Recordset' failed is the error I am getting when I try to set a record field to a form text field that has the system date set to it.
Specifically.
yrst is the recordset
I set a number of recordset fields to values on a form with no problem.
Included on the form is a field "txtNewUpdtDt". The control source is =Date()
The statement that is failing is yrst!SysUpdtDt = Me.txtNewUpdtDt
This had been working until today. I googled the error message and found a lot of hits, but none that specifically addressed my situation.
Anyone have any idea what's going on?
Thanks,
B
I need to handle a code to collect a list of files at specified path to be inserted into one table fields:
file name, extension, date, size...etc
In Access 2007 and 2010 there was a "Collect Data" group under "External Data" where I could click "Create E-mail" that would build an email form for an outbound email in Outlook based on a table. I would then send the email out, then collect the data back into the table from Outlook when the recipient of the email responded with a filled out form. I don't see how to do that with Access 2013. I do see the "Email" button, but that's for something else. I see no 'Collect Data' in Access 2013 like the picture below shows from Access 2007.
View 6 Replies View RelatedI have a form I am using to either select an Equipment ID or pull all records if no id is selected. My code in the query looks like the following:
([Forms]![frmWOCommentRpt]![cboEquipID]) Or Like "**"
When I run this, however, it only does the Or part. If I select an equipment ID on the form, it doesn't just pull that. I'm sure this is a simple fix, but I can't see it. Any ideas?
Hi,
I have a form that has 4 different search options (all of them are independent of each other).
I'd like to use 1 query to pull the results without having a write 4 different queries for each criteria in the form.
Any ideas r welcome. Thanks.
I have a macro that runs 2 queries, they both have criteria that needs to be passed over. how can i do this? I currently have it prompt but how do i get it to pull from the form the macro trigger is in? I also have a report that runs from a query in that macro also. i dont' want the user to have to enter anything since the critereia is in the form.
thanx
I created a form for adding new data to an existing database and it worked just fine.
Today the form has decided to add time to the date field and this clashes with the table it import to.
Why/how it's changed the date format and how to change it back?
I would like to create a payroll record that collect some information from another table. In other words:
-I have an employee.
-I have a payroll table.
-I would like to get some of the values from the employee table written to the payroll table when a new record is entered.
The form would look some thing like this:
Three boxes:
Employee: [ ] (table query to find name) # of students [ ] #of class minutes [ ] (value list with 3 choices)
When the SAVE button is pressed a record would be written to the payroll table with:
The payroll table would look like this:
payrolid#, employee#, employee, # of students, # of class minutes, rate, date
The employee#, employee and the rate would come from the employee table.The # of students, # of class minutes and date would come from the payroll form.
Hi
Not sure if this is in the right forum. :confused:
But here goes, my question is;
Is it possible to update the criteria by using a form?
What we are looking to accomplish, is a report that prints out labels in relation to the customers that are chosen in the query. What we want the user to be able to enter multiple Company ID's on this form, which are then picked up by the query and the companies name and address printed out via the report.
The printing out of the report from the form we have done.
The below SQL gets it's criteria from a form but if the form has no Date1 and Date2 values I would like it to return all records.
I could not tinker it into submission. :confused:
Any pointers would be great.
SELECT [Central Western Region Database].[Date of Term], [Central Western Region Database].[Agent Number], [Central Western Region Database].[First Name], [Central Western Region Database].[Last Name], [Central Western Region Database].[District Name]
FROM [Central Western Region Database]
WHERE ((([Central Western Region Database].[Date of Term]) Between [Forms]![Compliance Lair Reporting]![Date1] And [Forms]![Compliance Lair Reporting]![Date2]) AND (([Central Western Region Database].Status)="inactive") AND (([Central Western Region Database].[Employee Type])="agent"))
ORDER BY [Central Western Region Database].[Date of Term];
I can't figure out what I am doing wrong... I want the query criteria to be defined by a combo box in the form. The user will select the criteria on the combo box, then click a button to run the query, however the query keeps coming up blank.
[Forms]![UserReview]![Staff] is what I have entered in the criteria for the field in the query. If I simply type in "casbds1" as the criteria, which is one of the choices in the combo box, it returns with the data I want, but I just can't get it to work with the combo box. Any ideas what I am doing wrong?
Hello,
I am working on a database which has many queries that count different statistics of clients (race,gender,ect) during specific date ranges. I would like to set up a form that you could go in and enter a date range into a text box and it would update the criteria (date range) for each of the queries. How would this be possible? I have looked at some past threads similar to this but they didn't help.
Any help will be greatly appreciated.
Hi,
I want the user to be able to pick from a list the criteria that they can put in when prompted by a query.
At the moment, when you run the query, I have it set up so it prompts for the criteria: [Enter Section:] - so the user has to type in the section.
I want them to be able to pick the section from a drop down list.
I remember vaguely having to set up a form to do this....???
Thanks!
Maria:o
Hi All
Ok I have a simple problem. I want to entry value of a field as criteria of a query. Ie. I have a field on a form which is EmplyeeCategores. It's simple to use this as a a filter in a query by simply putting Forms![frmMailer2]![EmployeeCategories] in the criteria of the EmployeeCategories column in the query if there was only 1 criteria.
What I mean is, if the value of the field in form was A1 for example, it'll work and the query will bring up all emplyees who are categorised as A1. But I want users to be able to put multiple codes in the form, such as A1 or A2 or C4, and the query to bring up all the employees that fit into all 3 of these categories,
I hope this makes sense. Any help will be much appreciated.
Many thanks
Oz
Hi
This is simple im sure but i am a thicky
How do you allow a user to enter a value in a form; have access set that inputted value to a criteria in a query? Then ill have a button to run the query which i can do
thanks
thicky ste
Hello all,
I have a form that feeds a query with information, in my query I have this:
[Company] Like [Forms]![QBF_Form]![Sales] & "*" Or [Forms]![QBF_Form]![Sales] Is Null
When I fill in a value in the field e.g. "data*"the query brings up all information with the word "data" in it.
However, when I fill in something like "data* or vent*" I don't get any query results.
How do I change the query expression above so I can search for multiple criteria in one field using "or"?
Thanks a lot for your help!
Hey all this is my first post so thanks in advance for any help you can give me.
I am trying to use multiple checkboxes on a form to try and make a select query, when the box is checked the data is queried when unchecked it is not, sounds simple enough, here is my problem.
I set the query criteria with an expression like this:
[Forms]![frmMainLookup]![Check Box Alarm Number]="-1"
As long as the checkbos is checked everything seems to work fine.
If I uncheck the checkbox then none of the data is shows up.
I still get the columns to show up just no data.
I am sure there is something simple I am missing but the Force is not with me today.
Thanks again for any help.
How do I use the current value in a control on a form as the value for a criteria in a select query and for the update value in an update query? I must be messing up the syntax somewhere. I have written a macro to run the query. The button is located on the form so I would like to be able to click on it when the values I want to use for criteria are showing on the form.
I currently have the criteria is entered as
[Forms]![xtestupdateqry]![Licensee]
where [xtestupdateqry] is name of the form and [Licensee] is the name of the control I want to draw the current value from. When I run the macro I get a message saying I am about to update 0 fields. I must have my criteria wrong???
I am the first to admit I struggle with looping through records.
I am trying to loop through a table and collect external income data and write it to a new table.
My issue may be the way the table is laid out. ???
The attached pictures show the tables. The tblExtInc is where the data are. I am trying to create a table that looks like tblExtIncYr that shows each year and separate entries by item.
How would I loop through tblExtInc and grab ex:$2000 every year for upto 100 years but only get the $1000 for year 6,7,8 only?