Search results

I have created a database and successfully published on website but an alert message appears on the site "You have not created default Web Display form" I check the problem, but there is no form visible in the list provided in "options->current database->web display form. I have create a...

I am concatenating different fields by using following text. two fields are text while one is memo field. The function is working well when i use "unique records" ON but by doing this output results truncated by access. if i remove unique records then query provide whole text but it produce...

hello everybody, can anybody help me in following problem I have two forms, main & summary Main forms contains one subform with the name subform_activity having two fields, activity_ID and activity_Date Main form contains details of all activity while summary contain short version of all...

I have developed a database which is competible for web. In this database, i have many tables but i m just sharing the common problem facing with other tables as well For example Table A (master tbl) and Table B (Details tbl) are linked with 1 to many relationship through lookup wizard...

I have a database in access 2010 format and want to publish on web but after checking the competitablity, there are errors about index and relationships. The issues related to index have been solved but i an not able to solve the issue of relationship. How relationship can be created...

I have a main form which contains two subforms;subform1 and subform1 and a button btn subform2 also contains a subsubform. i want to develop a function which will be called through a button btn available in main form through this function i want to pass values to first the controls of...

i m tranferring data in bulk form excel after transfering the name field of the table shows spaces and i am using trim function but not getting result, a have a lot of techniques but not able to get results can any one highlight and solve my problem

Hello Can any one help me in developing a query I have three tables, tblA, tblB, tblC Tbl A has two fields, std and camp While tbl B also has same to field ( it is temporary table) tblC has one field camp tbl A and and tbl C are linked with 1 to many relationship I want to transfer data...

Can any one help what is error in the following function to count the total number of records of a query i always get error on line rs.close Function TotalRecords(qryname As String) As Long Dim dbs As DAO.Database Dim rs As DAO.Recordset Set dbs = CurrentDb On Error GoTo...

I have embedded crosstab query instead of subform in a form but i am not able to format the columns and values of output result of query according to main form formating for example i want to hide scrolls bar or navigation butthons which i likely can do with subform is it possible to do this

I need help to develop a query Infact i have two table one is stdtbl and second is temp table i want to move data from temp table to stdtbl table by doing following tasks Move data from temp table which is not available in stdtbl delete data from temp which is duplicate in stdtbl restore...

hello any body can help me, i am really stuck in this problem I have two tables both are linked, i have develop three queries, one query for sub form, while two other queries filter the data. In both queries i have used serialized function developed by "" THis function works fine when no...

I am using following function to get increment values THe input value is the colume of a query. if sr is divisible by 2 then increase otherwise old value of increment variable Sr Output required 1 10 2 10 3 11 4 11 5 12 Function IncrementValues(i, Optional myBase As Long) As Integer Dim...

I am using following code to format the excel sheet from access. With xlApp .Application.Sheets(sSheet).Select .Application.Cells.Select .Application.Selection.ClearFormats .Application.Rows("1:1").Select in first row only five cells have values and instead of selecting whole row i want to...

Hello!!! I have exported data from access to excel. From access i was able to format the cells of excel as well. I have changed few properties but can I change the view of exported worksheet from Normal to page break view, change in Zoom and boarder & shading of those cells which have data...

Hello can any body help me in developing following output of a query First declaring a global variable incrementVariable developing a function for increment value (one Hour) but first count the number of records in the output of a query. For your ease i have developed following requred...

I have find following code from other fourm to import data from excel into access. The name of site is also available in the code. I am unable how i can use or call this code by pressing a button. Sub DB_Insert_via_ADOSQL() 'Author : Ken Puls (excelguru.ca) 'Macro purpose: To add record to...

I have used following text to format the exported file but I am facing an error i.e a message appears called “"9-subscript out of range".. How this error can be resolved. Public Sub ModifyExportedExcelFileFormats(sFile As String) On Error GoTo Err_ModifyExportedExcelFileFormats...

Can any one help me in developing a column in query to create different time slots for each record like following: IDs Time new080592001 11:00 am new080592002 11:00 am new080592003 12:00 am new080592004 12:00 am new080592005 02:00 am new080592006 02:00 pm secondly how i can add unique values...

Hi I need help regarding developing a query. I have two tables both are linked with each other. One table contains different students while other table contains the result of different activites of each student. I want to extract the records of only those students who were "absent" or who...