Fri 3/7
8:41 | Microsoft Access 303 | Is it possible to include a sring variable in the by James Gray: Is it possible to include a sring variable in the caption property? I would like to open a form that shows items specific to the current user and would like the caption to read "My Form Name for:" [specificuser]. I have tried to put the varial into that field without success.... more... |
Fri 3/7
5:15 | General Discussion Forum | save single outlook msg to access table by mkelly: I need to save a single outlook email to ms access in a table. I have a todo list that I need to be able to view the original document when updating the task. |
Fri 3/7
3:37 | Microsoft Access Forum | DLOOKUP problem by Syed Ehtesham S: Your Code is
VendorID: DLookUp("VendorID"," VendorProductT"," ProductID=" & [ProductID] & " AND UnitCost=" & [MinOfUnitCost])
You use VendorID: Where u r supposed to use VendorID= (Equal sign) one thing more don't use & in your syntax use
ProductID= PID Where PID is the name of text box in your form as critaria.
don't use similar names as more... |
Thu 3/6
23:25 | Microsoft Access Forum | Search Text Box with Options by Aaron H: I would probably create a query for the search and have it pull the field name from a dropbox election.
Otherwise I created a search for multiple fields at once by concatenating the fields I wanted to search in my query. ie
[FirstName] & " " & [LastName] & " " & [CompanyName] & " " & [Email]
With a criteria:
Like "*" & more... |
Thu 3/6
10:01 | Microsoft Access Forum | search forms by nicolas: I used the like statement on a search form query to return all values when search box is left blank. The problem is that I have individually numbered sites and when I want that field, when left blank to return all values from all sites, but when I type in a site number it's returning all sites that have that number in it. |
Thu 3/6
9:33 | Access 2010 Beginner 3 | Comment by Jennifer Nikolsky: Hi, I am in Access three, I cant seem to delete a row because I have entered fields for default that include automatically on mailing list and NY as default state and 5% discount rate. I have Access 7. Thanks! |
Thu 3/6
8:05 | Microsoft Access Expert 18 | Mass Email From Access by Keith Williamson: Hi Richard
You have mentioned this topic on a number of occasions and it is something which I desperately need. Are you likely to be completing it any time soon?
Kind Regards
keith |
Wed 3/5
19:59 | Microsoft Access 202 | Comment by john Edwards: Ops sorry richard. My query was in Access 202, video 2 time 2.48 |
Wed 3/5
19:58 | Microsoft Access 202 | Comment by john Edwards: Had a look at the answer from Judith. 2.48 You say it comes from the CustomerF form. I tried clicking on the header and properties but it does not show. So I am doing something wrong. Can you give me the routine to open the Forms!customers!customerID
|
Wed 3/5
19:44 | Microsoft Access 202 | Comment by john Edwards: Hi Richard Magic stuff. I am at 3.25 on the Access 202, video 2. You don't show how to open up the Forms!CustomerF!CustomerID. It just appears. Can you tell me how to do it please. |
Wed 3/5
16:34 | Microsoft Access Forum | Microsoft Access Forum by Joe S: I have to count overlapping days from several timelines. Any ideas? |
Wed 3/5
8:30 | Microsoft Access Forum | Microsoft Access Forum by Jyotsana J: Hi Richard
My company wants me to create a ms Access main screen on which 15 databases can be placed and that could be the one stop shop to access all databases. I know we can do open form operation after throughing a button their. But i was thinking is their any way out if we can have open database operation by through button on more... |
Wed 3/5
7:25 | Microsoft Access Forum | access calculations by nicolas s: what lesson plan covers calculations in access? I'm interested in presenting stuff like average, standard deviation, totals, differences,etc.can it be a button or hyperlink text? can I filter sort or query my data and then have a quick operation to do a calculation on it? something like show me the average standard deviation abundance for all more... |
Wed 3/5
7:16 | Microsoft Access Forum | form operations hyperlinked text by nicolas s: what lesson plan would show me how to do a form of operation with hyperlinked text on my menu form instead of creating a button? |
Wed 3/5
0:14 | Microsoft Access Forum | Search Text Box with Options by MJ: Hi
I am creating search text box and I want my user to click an option in the option box that will allow them to choose the field that the search is to be done. is this possible. Thanks for your help |
Tue 3/4
13:22 | Microsoft Access Forum | 2 Combo Boxes by Robert: Hi Tom,
I m not sure if this is going to help but
If you ve followed the standard convention for setting up a parent/child
relationship between ActivityTermsT and ActivityDetailsT
TABLE: ActivityTermsT TABLE: ActivityDetailsT
ActivityDetailsTID AutoNumber
ActivityTermsTID AutoNumber ----------> ActivityTermsTID Number more... |
Tue 3/4
12:55 | Microsoft Access Forum | 2 Combo Boxes by Robert: Hi Tom,
I m not sure if this is going to help but
If you ve followed the standard convention for setting up a parent/child relationship between ActivityTermsT and ActivityDetailsT
ActivityTermsT ActivityDetailsT
ActivityTermsTID AutoNumber
ActivityDetailsTID AutoNumber
ActivityTermsText Text ActivityTermsTID Number
more... |
Tue 3/4
10:12 | Microsoft Access Forum | combo boxes on a search form by nicolas s: Can combo boxes be used on a search form? |
Tue 3/4
7:50 | Microsoft Access Forum | 2 Combo Boxes by Tom Houg: I have a Microsoft Access 2007 database I am working on. I have two tables (ActivityTermsT and ActivityDetailsT). I would like to set up 2 combo boxes, one with all the terms, and then the second combo box dropdown list of details will be dependent on what activity is chosen. I have created a form titled ActivityF. All information for the form is pulled more... |
Mon 3/3
22:00 | Microsoft Access Expert 9 | Comment by SHIVJI PATEL: I want to use system default for employee name. So when start Main menu select his name and he opens continues open forms. I gave default value of main menu employee name in that form. So gets data related to that employee only. But while query design if I put default value of main form in criteria than it does't filter. so in Query criteria for filter we have to put only name more... |
