Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Dec 1, 2006 12:11 pm
43808
Thanks Darrell, I got rid of the Click Event and now the click does highlight a member name, but it is still not consistenly moving the record pointer. I've...
Darrell this is my second post since your last one. I just noticed that it works while I'm testing it if I call the program from the form object box in Access,...
Hi, Can someone please tell me if it's possible to "attach" documents to a database record. I want to be a create links to Word, Excel & PDF document that...
Humble too, nice. Myra C. Symons-Kazanci ... From: Bill Mosca <wrmosca@...> To: MS_Access_Professionals@yahoogroups.com Sent: Friday, December 1, 2006...
One way is to create a table with a field that will hold all the file names. Make datatype of the field that is going to hold the file names "hyperlink". Open...
depending on the version you are running and as long as the systems have Word Excel and PDF, you can create a hyperlink field. They are a bit tricky and you...
Portella You can create a macro and use TransferSpreadsheet for the action. If you want to use VBA, you would use DoCmd.TransferSpreadsheet By the way, It...
Bill Thank you for your response. My problem is: I have a very long worksheet consisting of groupings of rows with several cells that contain information that...
Portella If you name ranges, you can import them separately into Access. Is that what you needed to know? Bill ... worksheet ... information ... determine the ...
David, At this point I'd say post a sample in the AssistanceNeeded folder. The process works in the sample I have using the frmMembersMainData form. Are you...
Chris, If you wish that subreport header should get displayed even when there is no matching data, it would be necessary to use a wrapper query incorporating a...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Dec 1, 2006 6:10 pm
43820
Thanks Darrell, I have loaded my file for viewing and any assistance - ROC Church Management Center2. I have a form, "frmGetDates" that will allow a user to...
Hi Everyone - I am in the process of creating a database for a senior animal rescue organization. I have a table that is meant to capture information about...
Hi all - I have another question. I need to add 2 numbers in a form to come up with a total cost. The help section is not very helpful it says to 'type an...
Hi - sorry for all of the questions today! Part of the purpose of my database is to be able to pull out data for a year ie in xxxxyear we spent xxx$ on vet...
Chris, I assume that your form has two text boxes that will have the numbers you want to add into a third text box. I'll call them txtNumber1, txtNumber2 and...
Just create a form based on your table or query, then on the form, make a combo box. Let the Wizard guide you through creating the combo box and when prompted...
Go ahead and store the full date as one field. You can always pull out info for a given year using the Year() function. Paul ... spent ... would I ... ...
... Chris, I assume that you want to populate a field in your MedicalEventTb with data that lets you identify which animal the record is about. If that's...
... Chris, if you need to display the result of this calculation on the form, do this: 1. Create a text box on the form. 2. Set the ControlSource property of...
A.D. I tried this today and had some strange results. I must have done something wrong. At first it seemed to work ok, but then I noticed I couldn't open...
This can be done in a query. You don't have to denormalize your data. Select * from YourTable Where Year([Date Spent]) = 2006 Myra C. Symons-Kazanci ... ...
Thanks Paul. I did that and it worked. Now, is there anyway to do this in the table? I really need it to be a value I can query. I have an idea and I am going...
My idea did not work... ... From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Chris Thomas Sent:...
David, Problem 1: You're filtering the form's recordset to the current MemberID on the Contributions form. You have to change frmGetDates' filter property in...
Chris, Here is something to try: 1. Create a query pointing to the table(s) 2. Add an expression field something like: TotalOfFields: [FirstField] +...
Bill What I really need to know is what is the best way to convert a 10,000 rows Excel worksheet into an Access table. Several rows (each row with several ...
Jim, Could you please upload a zipped copy of your file with some nominal sample data, at the earliest? I would try to fix it for you. Also please confirm...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
