Search results

Hello I would like to show number of records in reports and also I would like to display only one record, i am showing all the records tabularaly and would like to have only first records from the given report query. For total number of count on report I already tried =count(*) and also tried...

Hello there In my combo box, would like to add one column value from supporting table and rest of the value from main table so like below customer name ( supporting table ) --> company Id( main table) --> company address ( main table) why we are saying support table because we just want to...

is there anyway we can put report directly on form ? instead we create a button and that would open report ?

In My report it shows as follow. First Name las Name Class Rank Address Street It should be shown as follows First Name --> Last Name --> Class --> Rank --> Address--> Street. data 1 ........ data2.......... like was I dont know if cross tab query can help here instead of showing column...

Hello I would like to create an access reports that has to be horizontal instead of vertical column wise field mapping to report query. for example if 5 records for person it should give me five reports row/horizontally not column wise /vertical. While putting existing fields from query on...

hello there I have subform attached to form which is datasheet type of the form which is linked to main form by customer ID field, and in there data gets changes as different customer Id selected in main form. Now my query is that datasheet type form looks little odd to end user, is there any...

Hello I have combo box with following table as bound as row source and columns ID --> CustomerName--> CustomerID --> VendorName --> Invoice Number So in control property I set column count =4 and column width = 0";2";2";2";2" and bound column =2 as I want to store CustomerID when I save...

It worked, you came all the way for me, thanks a ton.

Thanks but we have table structure wherin we have same value for customer Id field and that is one of the primary key among others.

One customer can have many values isnt ? like one customer can have multiple address in multiple countries. I am sorry it would be difficult to upload the database... I am really sorry for this.

It is CustomerId as primary key in the table.

Hello, I have combobox with the below choice here ---> refer to column since HTML would wrap the text so I am putting --> to differentiate column in combobox. basically there are four columns. Customer ID ---> Value --> Name --> Address 1 ----> Test1---> Retain Inc --> Newyowrk 2 ---- >...

I really dont know about active control and how they works, first condition was working so I put seocnd condition, vendorID and plannedID are alias we have created. In fact in combobox we have multiple different value for same id for example PlannedID VendorID 1 "test" 2...

I am searching the record and populating them below works and populates the field based on combobox selection. ="[vendorid]= " & "'" & [Screen].[ActiveControl] & "'" and I want to add one more conditing which is numberic comparsion with planned ID and if I do this thing does not work...

hello On combobox after event I have macro field and has searchrecord condition in there I have following where condition, it is not working as expected ="[VENDORID] ='" & [Screen].[ActiveControl] & "' AND [PLANNED ID] = " & [Screen].[ActiveControl] & "" VENDOR ID CAN EXPECT NUMBER AND TEXT...

No, I have query which is associated with the form and fields are bound to that query, so if user selects the value from combobox it should change the value on the form accordingly. but that is not happening.

Hello Which is best online training for access 2016 or best book available for access 2016 with step by step instruction. Thanks

Hello i have combobox which has value like below VendorID Value 1 Malysia 1 Japan 1 Singapore 2 South America When I select value from combox it should populate fields on the form with both of the above value. But when it...

I have two tables one table contains ID and one table contains name so I want to have relationship between these two tables which would give me names accoudning to ID from first table.

Hello I would like to have a combobox which would take values from two different tables, more precisely it would query and one table. the problem is that if I create like that it does not update rest of fields on rest of the form. what would be best way to have rowsource of combobox from two...