|Microsoft Access Forum||Relationships by Trent: Thank you for your reply Richard. I am going to purchase and review your recommendations below. I have attached a condensed version of my three tables and the one of the relationships I am trying to establish. I oversee the volunteers in Crown Point, IN at our clinic. There are two types of volunteers in our Volunteer Transportation Network Program: more...|
|Major System Upgrade||Major System Upgrade by Steve S: What happens to the new system you've devised, in one of those Florida Hurricanes? |
|Microsoft Access 204||Hi Most amazing course I havce ever seen Quest by john Edwards: Hi, Most amazing course I havce ever seen. Question Access 2003 Ingtermediate 204. Setting up letters. 1-5. Our business uses emails almost exclusivly. Can this be adapted to send the notes section into an outlook email program |
|Access 2010 Beginner 8||Access 2010 Beginner 8 by Steven S: Is there a way to set up a form so that the opening record is not record #1? I'd like it to open to a new record or a placeholder/dummy record. I'm afraid my end users will accidentally edit patient #1.|
|Access 2010 vs 2013 Lesson Versions||Access 2010 vs 2013 Lesson Versions by Keith P: For many years I have wanted to learn Access. I put it off because it seemed formidable. You have made it quite simple and in less than three days I have finished through Beginner 6 and looking forward to the expert level. Thanks!|
|Microsoft Access Forum||converting a birthdate by Bob Lilly: Hi All
In Access I have a problem converting a birthdate of 06/23/1931 to be shown as 82.7
I have placed this in a blank field Age: (Date()-[DOB]/365.25 and it returns the flowing 82.7104722792608. Is there a way that I can add to or modify the statement so that the results will be shown as 82.7?
As an example, in Excel, if I place more...|
|Access 2010 Beginner 1||Comment by Horace LONEY: Hi Richard
Let me start out by saying how much I really enjoy your excellent presentations, you are an awesome instructor truly amazing.
I've developed 4 different packages for customers to choose from; with each package have its own unique content. Do I need to create 4 different tables describing each content or can this be accomplished by having one table; I would also like more...|
|Microsoft Access Expert 10||Comment by SHIVJI PATEL: At 18.15 there is Refresh Record and Refresh. What is difference between them ?? BY mistake have used only refresh in new action for button command and it's working fine.|
|Access 2010 Expert 1||Very Useful by Ravi C: This is really very useful for me.
|Microsoft Access Forum||Microsoft Access Forum by Deon Riley: Hi Jyotsana,
If I understand your question - you want the ability to open several external access databases individually from a single switchboard form using individual command buttons.
I've got something similar running and am using this code, which works just fine.
Private Sub CarParkBtn_Click()
Dim appAccess As more...|
|General Discussion Forum||Excel Annoyance by Stan: I thought I followed up on this:
I had "lost" a particular file recently; and while searching for it, accidentally discovered a different pathway to my Excel Startup file. There were those annoying ghost workbooks! I deleted them. Problem solved.|
|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...|
|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.|
|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...|
|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...|
|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.|
|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!|
|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?
|Microsoft Access 202||Comment by john Edwards: Ops sorry richard. My query was in Access 202, video 2 time 2.48|
|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