I have a form where I display the client's information and a series of checkboxes showing which services have been registered to them (ex. telephone, internet, cell phone (all info is held in separate tables with client id as the foreign key...).
For instance: I have a working query that pulls the client's id from the form to search the Cell Phone Table to see whether the client has a cell phone registered to them or not. How can I get that to translate into the checkbox on a form?
It seems so simple, yet the solution isn't presenting itself.
I have multiple fields in a table that are set up as Yes/No and display as checkboxes on a form. Now I need to create a text field on a report that showes all the Yes answers. The text field needs to figure out if it's a Yes answer, then display the field name, if there is more than one yes answer in the fields it is looking at, it should separate each with a "," . This is a large text field, that could show as many as 10 Yes answers.
What is the best way to go about doing this? I use Access 2010
Ok, nobody chew me out... I know there's over 500 posts regarding calendars on here because I've read just about every single one and haven't found any answers yet. All of the posts that vaguely resembled what I'm looking for had no replies.
Here's what I'm trying to do:
First I've got 4 tables, each has different data including a start date, start time, end date, end time and description. Each table pertains to a completely different subject. The tables are already populated (imported from excel).
I've got a form with a calendar control (Ms Cal 7) in it... and that's about has far as I have gotten.
I would like to be able to open the form and have the calendar show all events for the current date (i found how to make the calendar show the current date, it's just populating the text boxes that I'm having a problem with).
So, here's how I would like it to work...
When the form is opened, you can click on a specific date (or don't click anything and it shows the current date). Then the textboxes show the info for that date.
Example:
Calendar = 4/20/2005 (Calendar control here)
Textbox1 = select from table A where subject="codereds" and start date = calendar control date
Textbox2 = select from table B where subject ="codeblues" and start date = calendar control date
Textbox3 = select from table C where subject="codegreens" and start date = calendar control date
Ok, anybody got a clue on how I can do this because I've had no luck finding it anywhere.
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 would like to create a report that would really impress my supervisors, i just started at the company. I'm trying to create a call action plan, so i'm recording clients information on one table, and meetings we have had with each respective client on another table. Some clients will have multiple meetings, some few, and some none. I have a relationship set between them from the client's id number on the client table to the ClientID on the meetings table. one to many.
When I go to create the report, only the clients with meetings show up on the report, I would like client info to always show up on the report and meeting info to only show up under each respective client when it exists. I have worked out how to shrink and hide any text box without any info on it. It just seems like the existence of a meeting dictates where the client will show up at all in the report.
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
I created a navigation form on which I put a form call [frmAnimal Setup].
I then placed one combo box on the Navigation frm Header. I have bound it to its source and it actually queries the tbl and show the right info. However when I select one, it will not let me.
In addition, [frmanimal setup] will not allow me to select a breed although it does query the tbl and shows the right information.
I need help on this, from what the best concept is, to what I need to look into using:
I store Quote data from phone calls into tblQuotes. There is a seperate table that holds much of the same information except that it is for actual orders called tblOrders.
As far as function goes, I have each working much the way I need it to except for one thing... If a sales person is on the phone with a customer with a quote already in the system, right now they re-enter the data into the Order table. Most times, the order is what was quoted, but maybe with a few small changes (so I will wnt to keep a historical record of the quote). How could I copy the contents of the quote recordset into the recordset for an order, where all the sales rep does from there is edit the quote to the actual order?
Would I use VBA or an update query that is executed via VAB? Honestly, I am unsure how to do this at all, I hope someone has seen this before and has a good suggestion...
I try to make my second database in Access. I need to summary 5 numbers, and then minus the lowest and the highest of them. For example (1+2+3+4+5)-1-5=9
In excel it looks like this: =SUM(C2:G2)-MAX(C2:G2)-MIN(C2:G2)
In access (Expression builder) i made this code: [J1]+[J2]+[J3]+[J4]+[J5] - it's the summary of five marks, but how can i erase the highest and the lowest one?
I am looking for the best way to produce a form and/or report that will count how many appointments are scheduled by every tenth of an hour for every hour. Here is what I have for an expression in a query for 1:07 PM - 1:13 PM:
7-13Start: (IIf([Startminute]="7" And [StartHour]="13",1,0)+IIf([Startminute]="8" And [StartHour]="13",1,0)+IIf([Startminute]="9" And [StartHour]="13",1,0)+IIf([Startminute]="10" And [StartHour]="13",1,0)+IIf([Startminute]="11" And [StartHour]="13",1,0)+IIf([Startminute]="12" And [StartHour]="13",1,0))
This works but will take the 288 expressions to get what I need because the requirement is to show schedule start AND schedule end numbers. I am getting tunnel vision and would like to know if anyone has any better ideas.
I am working on a financial integration system that receives lists of financial journal transactions from several accounting packages.
I import and sumarise the transactions and end up with a transactions table like the one below. I now want to produce an Accounts summary (by period) table. I am trying to figure out how to do this just using SQL.
I do not want to use record by record VB because it is slow and I have a million+ records.
Can anybody help ?
Transactions Table (input)
Account Period Amount 1011100 1015 100
Account Summary (desired output)
Account Period Opening Movement Closing 101 10100100 10121000100 10131000100 10141000100 1015100100200
I'm trying to build a database that will calculate the price of meals. I have a table 'ingredients' that has the ingredients, measurements and prices. As prices can change regularly I assumed that inividual recipes should be queries that calculate the total cost on the fly. My problem is that I regularly need to print out a summary of costings that includes total costs for each recipe. From reading various posts I have formed the opinion that I REALLY shouldn't store calculated results in a table. Is there another way to get my summary? Or will I have to resort to being an access pariah?:(
From one of my tables, custinfo, i want to generate a summary of records. What I mean is I want to count the total number of records, count those who doesn't have address entries, count those who doesn't have credit records. So in presentation, I want to have this:
Field No Records With Records Total Address 10 256 266 CreditREc 5 261 266
I have the detail data in a query working fine in MSAccess 2000 sp3 and I'm trying to create a summary of the data. My query is as follows:
SELECT CUH.CULevel, CUH.AREA, TYPES.Asset, Count(TYPES.Asset) AS Counts FROM (TYPES LEFT JOIN Broker ON TYPES.[Owner/LastLogin] = Broker.LOGIN_ID) LEFT JOIN CUH ON Broker.COSTUNIT = CUH.COST_UNIT WHERE (((TYPES.Asset) In ("T30", "DESKTOP"))) GROUP BY CUH.CULevel, CUH.AREA, TYPES.Asset;
I am just starting to use Access and have set up many simple forms, datasheets, reports, summaries, etc. I have not worked with macros, etc. and need help for this project. I have set up a task table
F1 - DateOfCall - date - now() F2 - Client - text F3 - DateCompleted - date F4 - DueDate - date F5 - problemDescription - memo F6 - Resolution - memo
I need to run a query and/or report every week summarizing what has been done the past week. Would also like to view previous weeks. I need help. How do I go about doing this.
I use Access 2003 and have created a form with several subforms which I've placed onto a number of tabs. I'd like to have some of the most recently entered data from the subforms displayed on the main form.
For instance - if one of the subforms details the repairs to my car, in terms of date, items repaired, name of the mechanic and the cost, I'd like the most recent date of repair to be displayed on the main form. I know that I can see it be clicking the "Car Repairs" tab then scrolling down the information, but I'd like to have it displayed for easy viewing. I'm not sure if I'd need to have some VBA to do this or if it can be achieved by, for instance, creating a query to populate the appropriate textbox on the main form.
I have a situation where I use the output of a combobox in a query. When I run it everything is fine.Now I want to make a summary of 9 of these text fields in the query. However, when I do this only the bound columns show up in the summary field. I can't get a summary of the second columns of the combo in the query.
I have been using the following successfully with regular text fields:
How can I generate a report that contains multiple summary total by year. I run the query to give me selected time period(s) for my report. For example: I want to have the summary for the date ranges from the year 1994 to 2001, and then 2002, 2003, 2004 etc. I'm having difficulty for the first summary total which is the date range from 1994 to 2001.
I have a approximately 70 queries in my database. I would like to be able to run a query which would run all of the queries and output the number of records for each query. Ideally, these would then be written to a table so that the user could then just read the values from the table for the latest results, rathe r than have to execute the whole thing again.
The user may wish to select which queries to run. I was thinking that I would need a table as follows called say tblQueryResults:
So my first dilema is to work out how to run all the chosen queries that the user wishes to run. The user will probably have all 70 ticked as Yes initially.
Should I run this from VB code with a whole lot of VB statements. I would like to loop through the whole table and collect a list of all the queries to run based on a positive Yes for some or all of the queries. The results must then go and be written into the same table under the date it was run and the number of records that was found for each query.
The whole reason for doing this is that queries which return no records need not be run by the user - saving the user time etc. I appreciate that this query will take a considerable amount of time - given that it could be as many as 70 being run one after another.
I have a very simple single-table database with 23 fields. Some of the records have only two or three fields populated. I would like to be able to print a summary of only the populated fields in each record.
It would Ideally look something like: Record 1 Name Field 1 Title: Field 1 content - Field 2 Title: Field 2 Content - Field 5 Title: Field 5 content Field 10 Title: Field 10 Content - Field 11 Title: Field 11 content - Field 12 Title: Field 12 Content Field 21 Title: Field 21 content - Field 22 Title: Field 22 Content
Record 2 Name Field 1 Title: Field 1 content - Field 2 Title: Field 2 Content - Field 5 Title: Field 5 content Field 10 Title: Field 10 Content
Record 3 Name Field 11 Title: Field 11 content - Field 12 Title: Field 12 Content - Field 21 Title: Field 21 content Field 22 Title: Field 22 Content
I am trying to create a report or form (not sure which is most suitable) which when opened will show a summary of my data.
My data is essentially a table of timecards, with various linked tables which together enable time working on a lot of different projects to be recorded and reported on, and the value of the work can also be reported on.
In other words it's a bog standard time-recording system.
I can generate a number of reports, for example a report showing all projects with unbilled time and the value of that time.
What I want to do is produce a Key Performance Indicator (KPI) report/page showing total time worked in the last 7 days, month, quarter, year and the annualised amount of the first three of those.
Also I want to show the value of each of those in billing terms, e.g. what was the time recorded in the last quarter worth, and if that continued all year what would be the annual value.
I have created summary (total) queries which return all of these numbers. Essentially each query has a number for the period and a number for the same figure annualised.
I am trying to get all of these figures onto one page.
If I create a report based on one of my queries (by opening the query and clicking Create/Report) Access generates a lovely report showing my two figures generated by that query.
My problem is that I cannot get all of the different figures based on the different queries onto one report (or form).
Access will only allow me to show the figures that come out of the data source for the report or form. I cannot find a way to have multiple data sources.
I have tried creating text boxes where the data source is a different query. I dial up the query and the value, but all I get in the box is "#Name?".
I guess people must make this kind of KPI report or form all of the time. I read about dashboards and the like and see pictures of nice-looking Access pages containing all sorts of summary data, but nowhere can I find any description as to how to create such a page.
I created a database with a list of companies, with many details in separate tables linking them - shareholders, directors, address etc.
Now i want to create something where the user will be able to just Select the company, and the information would be shown below just for that company. I would want to design of course in order to appear nice.
