Search results

Hi, I need some help in calling form.. A function is being executed in a form1. In this function a call is there to open form2. The form2 opens. No problem in this. But when form2 opens it resumes the execution of the remaining part of the function in Part1. What I want is once form2 opens it...

Hi Ppl, I have few questions in access forms. 1) I have a few forms in my access file. When a user opens the file the main forms pops up. When the user wants to go for design he need to press Shift Key and open the file. Any way to make the design mode password protected. 2) Suppose I make a...

You the SQL join query in Form recordsource property. Then assign the textboz property by selecting the appropriate column of the query from the property window.

if the data in table gets populated by only cross product from the other two tables where intsalesID and intcarid are column then it should not affect the population of third table if we do not have PK defined. But if we have PK defined then probably the search will be faster on the table as it...

Use this code to do the import: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "BUD_INPUT", STR, 1, "BUDGET!A:P" where STR is the excel file name. BUD_INPUT is the access table name where the data needs to be imported BUDGET: this is the sheet name. "A:P" this says that it gonna...

This seems to work but dont know why its not working for me. I tried something like this: Created a new form. In design view of the form I went to record source and selected the query "Alert_data". and changed the form default view property to datasheet. When i open the form though it opens in...

Hi Bob, I can see from the form property window the place where to make the allow property to NO. But struggling to find the display as Datasheet. and how can i link the query output to form datasheet. Ashish

Try out something like this Dim dbs As Database Dim rs As Recordset Dim qdf As QueryDef Dim productName As String Dim strSql As String Set dbs = CurrentDb() productName = "ADSL" strSql = "SELECT [Information].* From [Information] WHERE [Information].Product = " & Chr(34) & productName &...

Hi, I have a made a query named "Alert_data" in query option which selects the data from a table. When i click a button in a form this query output should be displayed.I am using the code in the button click event as DoCmd.OpenQuery "Alert_data" Its working fine. But the problem is if i...

Hi guys, As per the suggestion I am planning to change the front end and back end in two different places. One small doubt. Making FE/BE separate means having two separate mdb's but off course they are linked. am i right? So while transferring the application I need to copy both the MDB's. Ashish

right now if i have to make the back end and front end separate I have to change the macros at many places. Any idea to make it work in my case where the front end and back end are same. for eg: i should sepcify the prod mdb path name and it should be able to copy the data. One small doubt. I...

Hi, The MDB files contains the macro and forms. I keep on modifying the macros in TEST.MDB file. Once I am satisfied with the macro updation I need to run them in production data. This can be achieved either by migrating production table data to TEST.mdb tables or copying the dev macros in...

Hi, I need to send e-mail through Access. I got the way to send mail through Outlook library in access But is there any way to send mail without using outlook configuration. In VB6 i used the code to send mail through Vbsendmail.dll but when i am trying to use the same code in Access its...

in your VBA use this code. Dim db As Database Dim lrs As Recordset Set db = CurrentDb() Set lrs = db.OpenRecordset("select version from tblname") lrs.movelast text1.Value = lrs.Fields("version") Hope it helps. Ashish

Hi, I have my 2 MDB files. One test version and one production version. Both have the same table structure. Periodically I want to copy the data from production MDB tables and pasting in test version MDB tables manually. Is there any way to do it using macro. I can write macros but i dont know...