Search results

Hello, I have very simple program with three tables and want to make data input in simple way. (as you see the attached file). on the main form I want that I can choose company name and then start inputting information in dividends section. It allows but when I hit save button it changes...

Thanks so much for your help. it has space issue.

Thanks it works, but it showing the total on 2nd page although there are space on 1st page. It allowing to add more products on 1st page but still showing the total on second page. I want it to be on next page when first page has no space.

Hi, i have simple invoice report. i want to show the totals on 1st page if the invoice detail has some products and when products are many then want to show the total on the second page only. Currently it showing the total on both pages when there are many products on 1st page. Please check...

Thanks but I don't want to input the criteria in the query design criteria. I first would like to view all records in form if I put 20 then it shows the records where value in a field if equal to 20 or less than 20.

Hi, I have created a form using query. I would like to show the form records based on the text value. Basically wants to filter the records as: When I put 20 in text Box in form it shows records where values are less than or equal to 20. Waiting of your kind reply. Thanks

Hi, I would like to update a Stock table using another form field. I am using update query and writing the statement as below in query design (update to). ([tblItemsStock].[InStockQty]+[Forms]![frmAddItemsQty]![AddQty]) It is not working and updating 0 record. any idea?

Now its working. Thanks a lot. How I can rating your answer?

but Exit Function is not allowed in Sub and your code is not working.

Hi professionals, Here is simple code in which I running query which updates records in table. I just would like to handle: When user click on button and ms access shows option that " you are going to append ... records" If I click on No I don't wana see the Error Message with End and debug. I...

Thanks for your suggestion but actually I am looking for not to separate the first name and last name but only want the text as : Before suhasini-pashikanti/15/214/622 suhasini-pashikanti-62221415 After processing suhasini-pashikanti suhasini-pashikanti

Your help is much appreciated. Thanks again.

Also can I use update query to only remove 's'? if yes can you please give me sentence?

But how do I update existing record by removing the 's' can you please tell me procedure.

Hi, I would like to use a query (update) to just remove the letter 's' from https. so where https i would like to make http. Original Link: http://www.linkedin.com/pub/suhasini-pashikanti/15/214/622 Updated Link: https://www.linkedin.com/in/suhasini-pashikanti-62221415 I have tried it but no...

Hi Professionals. All other work has been achieved and now I would like to separate the name from like. Original Link: suhasini-pashikanti/15/214/622[/url] Updated Link:suhasini-pashikanti-62221415[/url] So how do i take the Name before the Slash or dash. I have tried to got position of...

Hi Experts, I have small program with login screen. I would like to track when a user logged in into the program and what editing he/she made in the records. Thanks and waiting of your kind response. Regards Rehan

But there is issue. just Suppose MainTable has Primary Key as : Sr_No and contains 1 to 5 records(1 2 3 4 5). Similary TableTmp has also Sr_No Field with Same records(1 2 3 4 5). so in this case no record will be appended due to primary key on MainTable. I would like to view the whole (1 2 3 4...

I am doing the appending but later my Clerk may do it. I just want to view all those records which are not appended.

Hi, I would like to get the list of records of TableTmp are not appended into MainTable. both Tables has same fields name and data type along with primary key. Thanks and waiting of your suggestion. Regards Rehan