Search results

I use Environ function to detect the user name. But, do we have function to detect the full Employee Name?

Hi, I create a popup form using this docmd.openform "Name", , , , , acDialog This form I setup scroll bar = Both. When I open it, bar line is shown, but it did not show really scroll bar. It should be shown because the form does not fit the screen. How do I fix it?

Hi, I want to create the date column in the SQL Server table, but, I don't want the user the user to populate the date, I want the system automatically populate the date when the user input the values on other fields. When I create date column, there are Formula, and Default values. I tried...

Hi, Can we create a menu bar in the user form in Excel (similar to VB6 form)? Because when I create the userform in Excel, I cannot find that option. Thanks.

In the table, Can we setup the format in the field? I want to setup 0000, four digits, int datatype. the user just input 1, 2, or...etc. then it will show like this in the table. 0001 0002 ..... Can we do that?

In report, can we setup the object to be visible/invisble in the open event? Because I want to setup visible/invisble of the certain object depend on the other field value. Please let me know. Thanks.

Hi, In MS Access, we can insert image in the table by using right click + insert object on OLE datatype. But, SQL Server, we don't have option to do that. Please let me know about it. Thanks.

Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Set conn = CurrentProject.Connection conn.Open "Provider=sqloledb;" & _ "Data Source=localhost;" & _ "Initial Catalog=db1;" & _ "Integrated Security=SSPI" Set rs =...

Hi, I have a question. It's interesting. In MS Access, I create local table, named table1, and use ODBC linked tables from SQL Server to MS Access, named tbl1. Suppose I input 5 records in table1 I input 3 records in tbl1 Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("table1")...

Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Set conn = CurrentProject.Connection Set rs = conn.Execute("table1") MsgBox rs.RecordCount it gives out -1. How can I make it correct number? Thanks.

I added it, for i = 1 to rs.recordset msgbox rs.field(0).value rs.movenext next i but, it still out 1 record only. The table have 10 record lines. I tried msgbox rs.recordset, it only give out 1. So, it only loop one time. Thanks.

Hi, I create the table1 in SQL Server and then link the table to MS Access using ODBC. But, when I write do this statement Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("Select * from table1") for i = 1 to rs.recordcount msgbox rs.field(0) next i It only retrieve 1 record...

Line 26: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Line 27: Line 28: If MsgBox("Are you sure?", MsgBoxStyle.YesNo, "Message") = MsgBoxResult.No Then Exit Sub Line 29: Label1.Text = "Hello" Line 30: Why there...

hi, Will there be corrupt in ASP.NET? Because, MS Access will have corrupt sometimes, how about ASP.NET? Please let me know, thanks.

Can anybody suggest which software is better for fixing corrupt MS Access files? In internet, there are many, but I don't know which one is best and guarantee. Please anybody suggest it for me, thanks.

Hi, In MS Access, we can setup user-level security, and create the groups and assign the group to each user. In ASP.NET, can we do create the groups and assign it to each users? I know that we use SQL Server as the backend, but SQL Server only assign read permission, full permission, something...

So, ASP.NET only control 10 events so far, right.

Hi, I have a question. I know that mdb file maybe corrupt sometimes, but I want to know what conditions will make it corrupt? And also, if we create adp file as frontend, and SQL Server as backend, can we mimimize the corrupt condition? Please let me know about it, thanks. Because I don't...

Okay, thanks. But, if I use javascript to do popup form, can we do recordsource (similar to MS Access, table) at that form? Because, in ASP.NET, I want to do continues form, and each column has the values, when the user click either one of the values, then it will do small popup form in the...

So, In MS Access form, they have these events: On Current, Before Insert, After Insert, Before Update, After Update, On Dirty, On undo, On delete, Before Del Confirm, After Del Confirm, On Open, On Load, On resize, On Unload, On Resize, On Close, ON Activate, On Deactivate, On Got Focus, On...