saurabh_kanwar

Hi Guys, I was just wondering if there's a way of restricting access to the contents of a database by creating a list of users and their corresponding password. So when ever someone tries to open the database a form pops up asking for their user name and password. Thank …

Hi Guys, I've created a recordset which is saved in a txt file using following code [code] Private Sub Command0_Click() Dim Conn As ADODB.Connection Dim Rs As ADODB.Recordset Set Conn = New ADODB.Connection Conn.Open "DSN=movex" Set Rs = New ADODB.Recordset Rs.CursorLocation = adUseClient Rs.Open "Select * from PESALES", _ Conn, …

Hi Guys I've got a bit of problem with date. When I transfer data of a table to txt file the date column that appears in the table like "28/03/2001" changes to "28/3/2001 0:00:00" in the txt file. I've tried to change the format of date in the table but …

Hi Guys, I'm having some problems in importing data from a file into a table. I created this file by exporting data from the same table. I've deleated all the records from the table and now I want to fill it up from the file I've created I'm importing data …

Hi Guys, I was just trying to transfer data from access tables to a txt file and then back from file into a table using following code [code] Private Sub Command0_Click() DoCmd.TransferText acExportDelim, "Db Export Specification", "AUTHENTICATION", "J:\Power Equipment\Common\SK\db.TXT" End Sub Private Sub Command1_Click() strSQL = "delete * from AUTHENTICATION_TEST" …

Hi guys, I've got a database which frequently need to be sent over the internet so that other users can update their data. As the database is huge with more than 30,000 records, it's really hard for other people to download it as they are on dial up. Is there …

Hi Guys, Just Wondering if it's possible to choose whether to run a macro or not depending on which user logs in. I've got a macro which updates the database everytime it starts. I want to restrict it to only limited number of users. Thanks for your time

Hi Guys, I'm having a bit of problem with my reports. I've got a report containing a subreport which has some headings in its report header. The subreport normally goes for 2 or 3 pages. The headings of the subreport appear on the first page but do not appear on …

Hi Guys, Just wondering what's wrong with this coding UN = Form_MAIN!LOGIN_DETAILS.Value model = Form!COMBO_MODEL.Value stDocName = "MODEL_SELECTION" stCOND= "[MODEL_LN]='" & model & "'" And "[TM_NAME]='" & UN & "'" DoCmd.OpenReport stDocName, acViewPreview, , stCOND I'm getting a type mismatch error on the line where I specify value to stCOND. …

Hi Guys, I just need a bit of help in VBA. What I'm trying to do is to open report from a form. The reports are based on Query. The form consists of a combo box and a command button. What I want to do is to select the condition …

Hi Everyone, I just wanted to know if it's possible to create a chart in a report based on multiple queries. Thank you for your time

[COLOR=#000000]Hi Everyone,[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]I'm stuck in a bit of a problem. I've got a table called sales with a date field in it, but the date is not in the date format, its in the number format and it's too late to change it as the table's got over …