Search results

Hello again. I've been looking for an easy to use helpdesk DB and I found one on the Office templates site. (I've uploaded it here) It's pretty simple but it suits my needs. I was wondering if someone can help with my question. How can I setup the DB that each time I open it, it transfers data...

Hello. I want to know if someone can help me with this: I'm starting to write some code to run an office (not professionally). When I write the Client Class, how do I make it that the number of the client be a primary key (unique and auto incremental)? Also, I want that all the Client and...

Yes, that was it. Thank you very much.

Hello. I've been hitting my head all day with this and maybe anyone can help me. I have this piece of code on a view: Select HA_Id, HA_Seg_Id, HA_Data from dbo.Hist_Analysis where (HA_Data BETWEEN CONVERT(DATETIME,'2001-01-01 00:00:00', 102) AND CONVERT(DATETIME,'2009-01-01 00:00:00', 102)...

Thank you for your answers. I'll give it a try and I'll let you know of the results. Cheers

Hello, I have a file in word that is like this: Name 1 Address 1 Phone 1 Postal Code 1 Comments 1 Name 2 Address 2 Phone 2 Postal Code 2 Comments 2 And so on, intil 300 and something. How can I import that into records to an Access table strtured more or less with the above mentioned fields...

Sorry about this, but just wanted to see if Crilen007 (or someone) could answer me this last question.

I'm not sure I undestood you correctly. Do you mean change the items names directly on the tables or just on the forms? If I change them on the tables won't there be some warnings about relationships or something? (just guessing here...) Thank you.

Hi Crilen007, I've checked out your updates to the file and I wonder if you can enlighten me on someyhing: editing the Add/Change doctor's subform's properties, I've stumbled across some VBA code. Was that your doing or was it automaticly generated? Am I going to learn something about VBA to...

Hello Crilen007, Thank you for your post. I'm sorry I didn't post sooner, but the webserver at work was down today. I'll study your modifications now that I've downloaded the file and I'll get back to you. Thank you

Crilen007, the example you provided pretty much covers it, with the alterations Pat Hartman mentioned (thank you). But what about this: Maybe I didn't make myself very clear. What I meant was how I could find out if a new doctor is introduced or if somone's address changes or something like...

Thank you all for your input. I'll study the example you've provided, Crilen007 (you're correct with your assessment on my Access knowledge) and I'll get back with my doubts. No doubt I will have them. Thank you.

Hello guys. Just starting a very simple (one should think) DB for keeping track of medical doctors. How should I approach this? Doctors_Table should contain : - Id - name - address - state - phone - medical area - addicional comments Medical_Area_table - Id - Medical_area State_Table - Id -...

Hello. I'm sorry for my insistance, but since I can't get the participants part to display correcty on the report (after checking, only the last one of the participants selected to that meeting appear on the report), all the purpose of this db is frustated, because the whole point of it is to...

Haven't figured the last one out and I've also noticed that the reports, when printed even that there is no data on it, come out with 3 pages. Any ideas?

Pat, thank you for that explanation. That did the trick. However, I have one final question: On the report that I want to print, everything appears correctly, except the participants, because no matter how many participants are in the meeting, it only appears one. Can you help me on this one...

Ok, Pat, I've figured out the cascading part. However, I'm having dificulties linking the meetings form to that Meetings report. I'm creating a new report tmplate by draging the fields on design view form the form directly to the report and it looks fine, however, when I save it (as you said)...

Thank you, Pat. I'll try it and I'll let you know of the results. Cheers

Pat, thank you very much. That was really it! And it wasn't really easy 8at least for my knowleges!! Now, I have only 2 questions: 1 - When I press the button "Erase Meeting", it displays the message (roughly translated from Portuguese): "Can't Eliminate or alter record because table...

I'll have to see it carefully, Pat. I'll let you know if I have any doubts. Thank you very much.