I've just started working with a new client. They have a database created by self-taught users. It's been in use for many years. It's used by one person in the...
I have to get a count of households that fall in the each poverty level and I am not sure of the logic: Here is the tblPovertyGuidelines: PersonInHousehold...
Hello everyone Suppose a table named tbl_med. The tbl_med table has six fields: [nom_lab], [nom_desc], [nom_apres], [data_vigencia], [cod_med], [vr_pmc]. I...
I am tryhing to calculate the average age I have this: SELECT tblApplicant.ApplicantID, tblApplicant.DOB FROM tblApplicant INNER JOIN tblApplication ON...
I am a database 'user' nowhere near a 'guru'. I keep a table for member details and another for the member history. They are linked by [MemberID] When a member...
We have a fiscal year which runs from 1st July to 30th June. I need to find dates that are within "This Fiscal Year". I had a similar need and the group...
I am trying to get the avg number of household member per application: The two fields that would be used is the applicationID and HouseholdID. Something like...
Hi all – I'm new to this group, and even newer to Access 2010. I'm leaving my comfortable world of Access 2000 to the wilds of 2010. I just got back from...
Hello, So I have a form that needs a Outlook reference to open and I usually work in Access 2010 and it works great. I tried to open it at home and I received...
There seems to be a gap between sub-reports that grows with the sub-report's border size. When it is set to hairline, the gap is not perceivable. But with...
I have a pretty good data entry screen. The only thing that it needs is to be in a specific field when adding a new record. Is that the Form Load event? What...
Here is what I already did but still failed with the run-time error message. Appreciate if you can point out where I might have made the mistakes. In my main...
Dear All, I am using this code to filter subfrom between two dates using text boxes on the main form, but it is not working, what I am doing wrong Private Sub...
I am trying to create a datasheet popup form. The datasheet is based on the tblWOMaterial: WOMaterialID MaterialID WorkorderID UnitCost Quantity Notes The...
Hello all, When I built this report for users, all was well. It was exactly what they wanted. Now there are some things that they are requesting that I am...
Hi all I have a system which I wrote about 10 years ago - it's a tabbed system so there are 5 multitab forms, including in each case a query form. The user can...
Hello everyone, I just discovered that my Auto number has duplicates. So I checked the design and it has Yes(Duplicates OK). First of all my ignorance was that...
Hi, I have a report based on a query which when run, prompts the user to enter the client id - so in the criteria of the query I have "[Enter Client No]". How...
Hi All,... How can we open our application in Full Screen on Computer?(Not the same with DoCmd.Maximize), i mean really full screen on computer without menu ...
John, upon further research I believe the answer is yes. I will adjust the code and give it a try. Is this the place I should also put the code to prevent the...
Hi All... I opened a form called F_Display with event on open (F_Display On Open) = DoCmd.Maximize. How can i open other form (let say F_Employee form) using...
Hello all, I found a sample database that allows me to hide the access window on open. I have been working on an application that I would like to use this in,...
Hi everyone... I am trying to play avi file on a form using Microsoft Animation Control, version 6.0 activeX control. i've tried to play 3 samples of AVI files...
Thanks to all of you for being here and walking with me! I'm pumped--just solved my own problem because of what I've been taught here! There have been many...
My client has a very specific request for a combination chart depicting investment data. The two data series are quite different in magnitude. I have posted...
Rocky Mountain Tech Trifecta in Denver this Saturday This Saturday is the Rocky Mountain Tech Trifecta, a free technical conference in Denver covering...
Hi All... :) Can we make Slide Show with several pics or photos in a folder and display them like Slide Show on a control on a form..? Any directions would be...
Hello everyone, I'm running into a major problem with Access 2007 when importing a text file into the software (.txt format). I have never had a problem with...
