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 Simon, When i tried this command, it is giving syntax error. the error is "wrong number of arguments. any help pls.

To be a bit clear, here is what i did. I have a table ABC which has the field "Address". This address has carriage returns and i used the following code to remove the carriage returns in an append query. Expr3: Replace([Address],Chr(13),",") and in the append to row of the query, gave the...

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 Kryst, here is the copy of database as an attachment Cheers.

Hi Kryst, The problem is i almost finished with the database and now just trying to tweak it for better user satisfaction. if u want i will send u the database to have a look at. Cheers.

i dont think it is possible..even it is possible, it makes the form look bad and i think its not a good procedure.

Hi Crake, the user has to select multiple valuse which is not possible with combo box. Cheers.

Hi John, The user has to select combination of those letters. Thanks

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.

I already populated a table with all the wards and their codes. Thats wardinfo table. Thanks

Hi Dave, Did you had a look at the other attachment i have sent. I should get the output that way. I cant actually figure out what you are advising. Please explain it a bit eloborated. Thanks.

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...

Thanks Mstef....thats really helpful db.

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...