Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Set password only if the user enter with SHIFT + ENTER
Hello, A simple question...How can I set a password to my database only if the user access my application using SHIFT + ENTER ? Regards, Adrian- adita1983
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Select Top N, where N is a variable from a form
Hi, PHV can u be more explicit ?I need Me.cmb_Procent percent from total records of my table. Tks in advance, Adrian- adita1983
- Post #8
- Forum: Microsoft: Access Forms
-
Select Top N, where N is a variable from a form
Hi, Thaks guys, it works.The problem was with syntax. strSQL = "SELECT TOP " & cint(Me.cmb_Procent/10) & " tblTemp.* " & _ "INTO " & strTableName & " " & _ "FROM tblTemp " & _ "ORDER BY tblTemp.RandomNumber;" is correct.I have one more question.I want...- adita1983
- Post #6
- Forum: Microsoft: Access Forms
-
Select Top N, where N is a variable from a form
Hi, cmb_Procent is a combobox in a form. Here is my code : strSQL = "SELECT TOP cint(" & Me.cmb_Procent & " /10) tblTemp.* " & _ "INTO " & strTableName & " " & _ "FROM tblTemp " & _ "ORDER BY tblTemp.RandomNumber;" The error is : "The SELECT statement...- adita1983
- Thread
- Replies: 8
- Forum: Microsoft: Access Forms
-
SELECT TOP n, where n is a number recive from a combobox
Hi I want to select first n recordsets from a table in a new table , where n is a variable recived from a combobox in a form.Here is a part of my code : Private Sub Submit_Click() Dim strSQL As String strSQL = "SELECT TOP cint(Me.cmb_Procent) tblTemp.* from tbl into newtable" DoCmd.RunSQL...- adita1983
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
I have a problem with dates in a form filter using "between"
Hello, It works with Format.Tks a lot Ken Reay.- adita1983
- Post #4
- Forum: Microsoft: Access Forms
-
I have a problem with dates in a form filter using "between"
Hello, Can u help me please with the following problem? A want to use "between" in a filter with 2 dates.Here is the code: Private Sub Submit_Click() Dim str As String str = "Total_sampling.Statusenddate between #"&Me.Data1&"# AND #"&Me.Data2&"#" DoCmd.OpenForm "Total_sampling", acFormDS, ...- adita1983
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
