Search results

I tried editing and saving the data. The data in the Subform when edited and saved, is NOT saved in the Table. The subform is actually querying data from 2 tables. One table which has the Combocode and shortclose field is updated but the other fields of the other table are not updated Meanwhile...

Mr Arnel Thanks. It works beautifully. A couple of questions: 1. Can I modify the Form Ex1 by adding more fields form the query? 2. Can I rename this form? If yes where do I change the Macro? 3. Can I modify the table where I am adding data to add more fields? 4. The combo code in CustSODtls...

Yes it Works. Wow! Many Thanks Can you tell what was done for learning from this exercise. Also I need to modify the query and the appended table going forward

Thank you Vlad for remembering the earlier post! I did the following steps 1.The Select qry name is PendingOrderQry 2. I changed the qry to Make table qry and table created from it is called Temptbl. It has a primary key which is combined key of 2 fields, called ComboCode 3. I changed the Qry...

I opened the Ex1 form which has both the query and the editable form. The fields are not editable. Is this the correct form?

I created a continuous form using the query as the source, say Form A. Then I created a continuous form for the new fields needed - say Form B linked to Table B. I also created a conjugated field in the tables for the 2 key fields I want to link - the query has the conjugated field and also...

In other words, Data for Table B will be seen one record at a time, perhaps based on which record in Table A is selected

Yes this is possible. The problem is that to add data in Table B, I need data of Table A and B to be viewable in a continuous form , side by side with Table A data as non editable and Table B data to editable. This is the reason I thought that if Table A and B are continuous and we find a way to...

try a new query and show that in the new continous form. - I had created a new continuous form using the existing query as record input but that wdid not help (by the way, a hard question to read) - should I try to rephrase the problem?

I have a query where I need to add a few columns and create a report or query with the additional columns. The output after linkage needs to be in continuous form (with query columns followed by the additional columns of the table) as the rows of data will be large and the report is needed for a...

I need to make a pending order report as per format enclosed and need to build a query to combine 3 tables 1. SO Header Table - which has Customer name etc (CustSOHdrTbl) 2. SO Details Table (CustSODtlsTbl) - which has the details of items booked. These 2 tables are linked by a SOHdrID 3...

I have a table of items with Internal code, specifications Groups, Subgroups etc. To build a query wherein we can search either OR all the search fields (Internal part no, Group, Sub group1,2 etc), I built a form with text boxes and a query to read these text inputs and search for records...

Crystal This did not work. What eventually worked was reducing the columns under City from 3 to 1. In my cbo for city, I was using 3 columns - City, State and Country. When I reduced this to only City, I got all the cities in drop down of the selected state. Why, I dont know yet :-)

Thanks for the suggestion on fields. Will rename. When a user selects the country, the form can capture the Unique CountryID i/o Country and likewise for state etc. The problem is they need to see the names on the form to be sure it is selected correctly , at the time of entry and editing etc...

Indeed the Unicode had changed. I corrected it to Yes, the field lengths are same - 50 in both tables, but still could not get the same corrected. I tested the same code where all the data of countries, state, city was typed in, and I dont face an issue in this database. I have added the...

Here I go again. I thought I had it and I am stuck again. I created a table with Country, State and City this time. In the form I select country, state and then city. I am able to select the state easily after selecting country. Using the same logic, I am unable to select the city from the same...

When I create a combo box display using 3 fields, I do not get the option of selecting which column value I need to capture. This screen simply does not show. I use Access 2016. I reinstalled Office thinking there is an issue with the installation, checked with Microsoft Support too. They have...

I have started using Access a week back and was not sure of many things. I am beginning to get a grip. Need to deliver and learning time is short. Thanks again and will be more perseverant in future

Thanks. Yes I needed to read it a few times. Resolved. Thanks a ton

This Is the screen shot of the table