Search results

Thank you so much Mike, I guess we'll have to sit down and come up with this coding. Thank you again, Raymond

Hello again, I come back again with yet another three part question. I would like to be able to generate unique id for my database. Is it possible to do this using fields that exist in the database; say I've District, County, Parish and Village... that have codes as 01 01 01. I would like an id...

Hi, I think I got the answer. what I want is form that opens to a record related to what is displayed on the main form -- a synchronized form!! :D someone on another forum help, Thank you all anyways, I appreciate... bye - need to read on synchronized forms.

Hi, I thank all who've tried to help me out. However, I'm still stuck. I've tried all and I have'nt succeeded. Maybe my design is wrong in the first place.... maybe I confused you with my question. I don't know... I would to transfer a paper based system to and electronic system. Therefore...

Thank you Gurman for the quick reply, yes I've the Data Entry property set to yes.

Sorry I forgot. The appointments table eventually we would like to be able to printout appointment weekly. One thing here is a patient may come in today and is given an appointmnt two weeks after, however because something comes up and they are not feeling well they can come anytime. And also...

Greetings everybody, I'm trying to transfer a community clinic's data form paper based to computer based using access database. Basically a patient has many visits to the clinic, during each visit a number of investigations can be requested by a number of doctors, and they get treatment (many)...

Alc, The error is 'the SELECT statment includes a reserved word or an argument name that is mispelled or missing, or the punctuation is incorrect.' Thanks, Samia

Thanks Alc, but ihas still failed.

Hi Guys, what could be the probelm with my query? Here: ****************** SELECT tblPartnerProfile.PartnerType AS [Org Type], tblPartnerProfile.PartnerName, tblPartnerProfile.PartnerLoc1, tblPartnerProfile.PartnerStatus AS Status, Count(PartnerType) AS TotalType, FROM tblPartnerProfile WHERE...

I sure appreciate everybody's time and the willingness to help. For that I'm grateful. Maybe what caused the confusion is the query thing, I've finally found a friend whoz trying to show me that, so you can cut that out. My main question was on the multiple variables, was the way I did it the...

Am so sorry, is not exactly what I meant. True I work for this organisation but as a volunteer IT support person looking to branch into dbase development. I sincerely apologise for the harm, Regards, Samia

Hello there, I'm trying to develop a database for an organisation for their partners....see attached. I would like you to take a look and tell me if what I've done is the right thing. Secondly, (I'm just learning Access) I would like to have a query that give a count of 3 how many CBOs, how...

Exactly, it is more than one answer. But this is just one of the many question in a questionnaire. Wont I run into problems if the tables are many? Thanks in advance, Samia

Thanks Guys, I sincerely apologise for the not so clear question. What I was asking is say you have a question: What is the role of ICT unit; possible answers are; To set guidelines, to approve bids, to approve budgets etc etc. So a person could answer any two or all three. My question is (I've...

Hi Everybody, I've a question that is teasing me. How would I create a multivalue/multiple answer field in access 2002. P'se forgive if this question has been asked before. Thanks in advance, Samia

Should I create a new field? Thnx Ecniv, Won't it change the (relationship) links? Should I create a new column field for id? Will I be able to create a link relationship?

Anyone else who would like to give it a short??

Thanks DocMan for your reply, P'se (DocMan & others) this is a database which was designed by someone else and I've just been called in. What I know is the owners dont know a thing about how their database is, and eventually they will want to blame someone. This is why I'm asking for your...

Hello Everyone, I've data already entered (access/tables) on two different computers, however for the clientid on one computer has a hypen (-) and on another - because of something they couldn't get the hypen to work - so they used the slash (/) my Q is: 1) can I search and convert these to...