In designing a database, is there a way to keep users from looking at tables, if all I want them to have access to is their form.

I have 5 tables as below: tblProvinces ProvinceID (PK) ProvinceName ... tblDistricts DistrictID ProvinceID (FK to tblProvince) DistrictName

Good day, I am able to create the list box with the reports in my Dbase however I am unable to achieve the end result I would like which is on double click...

Hi guys, I've got a form where the 'after update' event triggers an append query. I've currently written it in SQL within the vb code of the form and use...

I have table A (courseA, note1), Query B(id, courseB, begin, end) PK: courseA and id sample data: courseA: a - b - c id : 1 - 2 note1 :...

Guys, thanks for your cooperation ! Another question, I wrote a function which allows me to translate my fields name, from english to chinese. Basically it...

I have already taken my computere to a technician and they said it was fixed. But when I hit the key " I get @ and when I hit @ I get "

Hello, I was wondering if you could help me. I am a a brand new user of accsess and am having to design a database for some coursework. Basically, one of the...

When I drag a command button on my form, the wizard doesn't start. How can I get it back wihtout re-installing Access ? Thanks

How do I change the titles for the Datasheet view in Access? It doesn't give me the opportunity to go into table design. But the titles ended up being ones I...

Hi All Is it possible that once data is added to a table it is inserted to the table in alphabetical order. Eg. Name Security ...

I have created a report that uses the counting procedure, now I need to total that procedure. I also need to know how to save the program to a CD so that it...

how do I insert photo's from a folder on my hard drive into a form in access 2003 without bloating the dbase.

How can I change the background colors or fonts in a Access message box?

I am working a database that houses patient lab records and Medicial record numbers. Some of the data needs to come to from a website that deals with...

I would like to know the difference between Microsoft Access 2000 and Microsoft Access XP

I need to set up a database to record all of the pupil reports sent out to parents. At the moment we are using excel and although it is possible to do this by...

How do I create a process for producing a report based on an individual record in my database. I need to produce a report each time I add or amend a record in...

Morning! I have a Invoice and an Invoice Details table. At the moment I have a services table, and you choose from a drop down which item to bill for,...

Hi, This may sound stupid but I would like to create a table to hold some playing lottery numbers and I'm not sure the type of structure should I use. The...