Search results

Ok another question....and I should've mentioned this off the bat. Ultimately I want this list of names to go on an intranet site, through database results. Apparantly database results can only pull from a query or a table, not a form. Is there any way to get this list of names into a query...

Never mind, I googled the error message and got it fixed. Thank you SO much for your help!!!!

Wow thank you, I very much appreciate the help! I set up a module identical to yours but when I run it, it stops on that first 'Dim' line and highlights "rs As DAO.Recordset". The error is "Compile error: User-defined type not defined". I went ahead and set up the form anyway, because I know...

Thanks for your reply.... but that's way beyond my level of expertise. :( Any chance of telling me exactly how to do that? Would be much appreciated...but of course I'd understand if you don't want to do my work for me. :)

How would that work? I've been playing with it but I've never used them before and I'm not coming up with anything useable. I have it where it will put each name in a separate column but also in a separate row. 10/21/2008 George Jones 10/21/2008 Steve Smith 10/21/2008...

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

A friend found a Microsoft article addressing this very problem. Very slick!! Thought I'd pass it along in case anyone else has this problem. http://office.microsoft.com/en%2Dus/assistance/HP011646131033.aspx Thanks to all of you who offered suggestions!

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

Thanks for your help so far! I'm still running into problems, and I assume it's something I typed incorrectly. I created a form named ChoosePhysician and the only thing on it is a combo box named DrComboBox that pulls a list of physicians from the Physician table. In my query criteria, I type...

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

A true genius you are. Thank you very much, works like a charm!

Thanks for your help. I made the following new field: Operations: [Operation1Performed] & Chr(13) & [Operation2Performed] & Chr(10) & [Operation3Performed] But what I get is one big long field with a box symbol where I'd like the line break to me. Did I type something in wrong? Thanks again.

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

Well I used Mile's suggestion before seeing these other, and it works for my purposes. Thanks much!!

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