Search results

On a form that collects physician information, there is a button the user can click that will send a report of everything the form contains to me through email, in a Word document. (We are currently moving from one system to another so we have to enter the same changes in 2 systems until go...

I can't think of a good way to do this. I have a query that selects all staff. I would like to change it to 3 or 4 separate queries.....one that shows the 1st through the 50th record, the next that selects the 51st through the 100th record, etc. Is this possible?

I have a macro that will open about 10 reports in the preview mode. Each report runs off it's own query. Several of the reports will have no records and therefore be blank. Currently I go to each report, print it if it has records and close it if it's blank. Which works fine. But I'm...

This is probably insanely simple, but I just can't figure it out. We have a field called Gender, the values are either M or F. We have a report formatted to look like a letter. I want to put a field on the report that will look at this gender field and put either "Dear Ms." or "Dear Mr." But...

We have a very simple database showing the menu for a given date....both the sandwich and the hot plate (full meal) being served. Only 4 fields are involved: ID (Autonumber) MDate (Date field) Sandwich HotPlate The Sandwich entries will have to be entered manually because they change depending...

Through other threads here I was able to calculate the elapsed time between 2 date/time fields. ActualElapsedTime: Int([StopActual]-[Start]) & " day " & Format([StopActual]-[Start],"h"" hr ""n"" min ""s"" sec""") It gives results like: 1 day 4 hr 5 min 0 sec Can I change it to give results...

I have a very simple database with only 3 fields, used to enter in the menu items (entree and full meal) for the day. Date Sandwich HotPlate I'm creating a form in a datasheet view for them to go enter in menu. They'll generally do a month at a time. What I'd like to do is have the date field...

This should be simple, but the solution is escaping me. I have a very simple database with 1 table. Fields are ID (autonumber), MDate, Time, Message. We're updating it via a web form, and also want to display the results via a webpage. It's simply for IS staff to enter a system status...

I have a database with only 2 fields...Name and Birthdate. I have this query set up to generate a list of people that have birthdays today: SELECT Birthdays.Birthdate, Birthdays.Name, DateSerial(Year(Date()),Month([Birthdate]),Day([Birthdate])) AS CurrBD FROM Birthdays WHERE...

I have a report based on a query, that will fill in a kind of form letter for everyone with a license about to expire. Each recipient (each record) is on a separate page. Currently they print the whole report, stuff each page in different envelopes, and send it through snail mail. Now they...

Everytime I think I'm getting somewhere I hit a dead end. I mainly accomplish the things I need by using macros but I'm thinking that won't work with something this complicated. I've used code but mostly with help, and I'm not sure how to do something like this. I have a form called...

I am completely stumped on this one. I have a database where we track IP Addresses and I just want to sort by IP...should be simple, I'd think. With these 5 IP's, I'd want them in this order: 1.2.3.1 1.2.3.4 1.2.3.7 1.2.3.9 1.2.3.10 1.2.3.17 1.2.3.21 But it sorts in this order: 1.2.3.1...

I apologize, I know this has been covered. But I just spent half an hour reading old posts and still can't quite decide how to apply it to what I'm doing. I have a db that logs surgeries and all their details. One of the new things they want to do is be able to run a list of average cost for...

I'm positive this has been addressed before but have been unable to find threads....I think I'm not using the correct search words. :confused: I have a database that we track IP addresses in. On a report, the sort order is kind of off: 10.1.100.1 10.1.100.10 10.1.100.11 10.1.100.2...

I've found many threads on how to filter on a form, I'm wondering if something similar is possible on a report. Normally I do this by basing the report off a query, and using a parameter in the query. For example, the criteria on a date is >=[Enter Start Date]. It prompts the user for a date...

I want to combine 3 different fields into 1, with a newline inserted after each field. I know how to put them all together with &", " to make one big string. Is there a way to insert a newline between them? I want them to appear like this: Operation1 Operation2 Operation3 Or maybe a...

I have a database that is used to log surgeries performed. They had me create 3 fields for them to record up to 3 surgeries, as sometimes when they get in and are operating, another unplanned surgery is performed as needed. I set them up as: Operation1Performed Operation2Performed...

At the top of my form I have a combo box where the user can select which record they want to edit. This is a really minor thing, but is there a way for the form to open up blank, and only pull up a record once they select one? Currently, when the form opens, it's displaying the first record in...

Hopefully I can explain myself correctly. Our surgical department currently logs all surgeries in a big book. At the end of the month, they hand count how many of each type of surgeries. I am wanting to set up a database so that, once they enter the information, reporting can be pulled to...

I have a database an employee uses to capture physicians' credentialing information. Anyone that needs added to our patient registration system, she emails the information to me so I can enter them. I had some help setting up a button that, when she clicks it, saves the current record and then...