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...

Thank you!!! I added this to my new plan macro, so it saves the record before running the queries, and removed the event on after update. You rock!

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...

Thank you MichaelRed! I used: Format(([start_time]/1440),"Long Time") This gave me the times of the appointment in non-military time.

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...

My question is along the same lines - how to select records based on the following work week (Monday - Friday). I could use an iif statement based on the day of the week it is and adding the correct # of days, but is there any function that would return the date of a specific weekday? Thanks...

Thanks so much Mike! It worked! That just makes my form so much better.

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...

You totally rock! Thank you PH. This is exactly what I was trying to do. Melanie

I know I could do it if I do it using the wizard for one month, but is there a way to get all 12 totals on one query?

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...

Thanks Duane!

txtMySql3 += (strDescription + "', '"); You mention Description is a memo field. I don't know a ton about this stuff, but it's almost like somehow you are trying to process a memo field as a text field and it gives errors because text fields can't be more than 255 characters. Is that the...

Okay, I think I know what might be causing the problem, but don't know why. In my query, I have the paid field criteria set as 0 (false). It's when I use the criteria that I have issues with the today field popping up. Is there a way to not have this happen? Here is the SQL view of the...

If your query, you could use the flight_date field or whatever field you would like to query on to prompt the user for starting and ending dates. Example field flight_date criteria could be between ["Starting date"] and ["End date"] Hope this helps! Melanie

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 am using an unbound control. When I reference and a report exists, I'm fine. As soon as I try using HasData in the equation, I get errors. I just can't understand why it's not working with the HasData part in the formula. Melanie