Search results

Hi, I am sorry for posting the same problem again but some replies to my pld problem said i dint explain the problem well. so i am making it a bit detail here. I am working on a database where I need to take some data out of one table (say Table1) and append the data onto other table (sat...

Hi, I am working on a database where i need to append a query on to a table from a form. I am doing this without forms till now. Is there anyway of doing that from a command button. Also is there any possibility of deleting the table with the same command button (i.e. delete the table data...

HI all, I have two problems to discuss in this thread. I am working on Access 2002. the queries are: 1. I had a address field with carriage returns in the middle. I used some code to remove the carriage returns and it worked fine. But the problem is som data has "," character at the end of...

Hi all, I have a database where there is a text box in which the user has to enter only P,R,I,D,E characters. Is it possible to do that. Thanks in advance.

Hi All, I have a real big problem with auto incrementing of numbers which must increment on a special case. Its very urgent guys pls help me. I am here with attaching the database "db1" for clear understanding. I have around 16 wards with a code assigned for each ward. This data is...

Hi all, I am trying to amend the data entered into a table from one form with help of another form. The database is like this: I designed a form to enter the data of different wards and stores them in a table. The main important thing here is the refno field which depends on the wardname...

Hi all, I have a really serious problem with auto increment of numbers. To say something about what i am trying to do, I have a autoform which should store data onto a table I made. this auto form have a field "wardname" which takes its values from a table which has 10 different wards with...

Hi all, I have a really serious problem with auto increment of numbers. To say something about what i am trying to do, I have a autoform which i made from the table data. this auto form have a field "wardname". This is base ona lookup table which has 10 different wards with codes. Ex...

I have a database where there is a field "date time" and some of the entries of this field have the time and some don't. I wrote a query to display them.my job is to split them into two seperate fields of date and time. I used the commands Date: Left([RECEPD],Instr([RECEPD]," ")-1) Time...