Search results for query: *

I got an old laptop from my Dad for school, but whoever he got it from messed with the settings or something because no matter what I do, the paper is showing as dark blue in Word. I have tried changing the background color, shadings, anything at all to white but nothing does it. Did this...

We have a database that has a linked table from another database we are not allowed to make changes to. This table includes a list of all our customers. Some are marked active, others inactive. I need to sort of add fields to the table (but can't because I can't modify the linked table...

I have a form, where people enter plan information. This information needs to be entered into a table before a report can be run on it. My problem - I want to have a Calculate Plan button, where the user clicks it and the plan report is pulled for the current record's information. The problem...

I am again trying to use someone else's information and it's nuts! We have start and end times for appointments - some are 3 minutes some are 10. When I look in the database at an appointment with a start time of 450 and end time of 453 it makes me think the time is listed in minutes - but how...

Someone wrote a program for us using access as the backend database. I have linked to one of their tables so I can run reports off it. The problem is pulling records by date. 7/14/05 is stored as 38547 for example. How am I supposed to do queries using the date? I can format it as...

I have a form with a subform on it. When the doctor approves the items on the subform and moves to another record (on the subform) I would like the subform to refresh itself or reload (not sure what to call it). I know I have to use the after update event, but don't know how to make it refresh...

I have an orders table, and would like to run a query that will show the total of all orders approved broken down by month. I have the following fields to work with: order_date approved So I need to pull all records where approved = true (Since it's a checkbox field) but getting things broken...

I have a client table which has all our patients listed in it. Doc would like me to write up a "calendar" for the year (which WILL change). Basically, he would like to have various tasks done or checked for our patients each week in different departments. I have created the following tables...

I have a query auto_cc which pull from tbl_auto_cc One field gives the current month. today: DatePart("m",Now()) Two fields are using switch based on the today field's value. currency...

I need to pass the totals from subreports to the main report, but if the subreport control has no data I need the control on the main report to return a 0 value. Example: Subreport dd_report has a control ddtotal subreport co_report has a control cototal Subreport cash_report has a control...

Two questions on formatting in an unbound control: 1) If the unbound control includes text and numbers (ex: ="You have $" & [dollars_left] & "left to spend." Can I bold the text portion of this, but leave the calculated field unformatted? 2) Can I change the way a calculated field is...

I have this statement on my report, and it's not working out. Here is what I have: =iif([max_visits]>0, "You have a max of "&[max_visits]&" visits per year." AND iif([used_visits]>0,[used_visits]" have been used.",""),iif([pocket_max]>0,"You have an out of pocket max of...

I already setup a table that is NOT ideal, and would like to try redoing it, but am not sure what is best. Here's the details: I have a table named AUTO_CC which has the following fields: id pid (patient id, lookup to client table) start_date end_date card_num exp_date vcode jan feb mar (etc...

Hopefully someone other than myself finds this useful: I was creating a report with several sub-reports on it. Of course you want some of the values from the subreport to show on the main report. Here is how you do it: Create a control on your main report, and assign it this value...

I referenced a subreport control to get it's value on the main report (in hopes of tranferring that to another subreport). I tried all sorts of things: =Reports!plan_report.Reports!dd_report![2005overflow] =Reports!dd_report![2005overflow] None of which seem to be working. What can I do to...

I have two subreports on a main report called plans_report, one is dd_report and one is coins_report. On dd_report I have a control which is a calculated field named 2005overflow I posted this value in the main report footer, and named it year1overflow. I tried referencing this value in the...

I have an update query that will update if the fields have already been updated previously, but won't if it's a new record. Does this not update fields in the plan_calculations table as long as the plan_calculations.costid = costs.cost_id AND plan_calculations.pid = today.plan_to_calculate...

My append query is not working all the time: INSERT INTO plan_calculations ( plan_wks, plan_id ) SELECT DateDiff("ww",[start_date],[end_date]) AS plan_wks, plans.plan_id FROM today, plans INNER JOIN plan_calculations ON plans.plan_id = plan_calculations.plan_id WHERE...

I have a macro which calls several queries, all based on the same piece of information. Is there a way to ask the user for the information and use it as criteria in each of the queries used after that in the macro? Thanks!

I thought I had it all figured out, but apparently not. I want to do an update query for table plan_calculations but no rows are showing up: UPDATE costs, today, plans INNER JOIN plan_calculations ON plans.plan_id = plan_calculations.plan_id SET plan_calculations.plan_wks =...