Search results

Hi guys I am trying to add items in multi column list box but it just keeps on giving me compile error at additem statement. Set rs=currentdb.openrecordset("qry_mysignoff") Rs.movefirst Do while not rs.eof I=me.lstitems.lstcount-1 If isnull(rs.fields("datesign")) then Me.lstitems...

Hi Guys Please see attached the screenshot. This is a report in access. What I want to do is to put some click event on the hyperlink in the Filepath so that will open up that file on the screen. Is it possible? Any help will be much appreciated. Thanks

its an option group with 3 options in it .

Hi All I have a form and within that there is a sub form. The subform displays Assessment questions, Scoring(Yes,No,N/A) and Notes. I want to put some validation on scoring so that the users need to select at least one option from (Yes,No,N/A) options for each question. They can't leave...

that's great , it worked for me. :)

Hi Guys, I am back again . The following code doesn't check the upper case letters in the password: Private Sub txtPass_Exit(Cancel As Integer) Dim InputLen As Integer Dim Char As Integer Dim i As Integer Dim AlphaCount As Integer Dim SpecialCount As Integer Dim NumCount As Integer InputLen =...

Hi Guys I have about 15 reports and I want to combine them into 1 report. I don't want to create 15 sub reports into 1 report but thinking of a possibility to create 1 pdf file that will combine hem. Any help will be much appreciated . Thanks

Guys, I have written the following code in the report : Private Sub Report_NoData (Cancel As Integer) MsgBox "There are no records to report", vbExclamation, "No Records" Cancel = True End Sub I have a form where the user will select the dates and choose which report he wants to print ...

Cronk, can you please amend my code accordingly? I am not sure where to put OnNoData event.

Hi Dave I tried the following code but still getting error message :(. Runtime error 2451, the report name you entered is misspelled or refers to a report that isn't open or doesn't exist. The same code works fine if I change acviewdesign to acviewnormal RName = DLookup("ReportName"...

Can anyone please help me in this?

Hi Dave I want to check if the record source of the report is empty or not . So the following code works fine and print the report only if the Record source is not empty. But if I change acviewdesign to acviewnormal then I get error Message at strrecordsource line . RName =...

thanks guys, Actually I want the following validations: 1. Minimum 8 characters length. 2. At least one capital letter anywhere in the password (not only the first letter) 3. ANy number of numeric characters. 4. Special characters should be allowed as well. Any help will be much appreciated...

thanks Dave, So what shall I change this to so that it works for both accdb and accde?"

Hi Guys I have written the following code on print button but very weirdly it works fine for .accdb file but not for executable file :( I get the error message "the command you specified is not available in a .mde,.accde while printing" RName = DLookup("ReportName", "tbl_RMS_TCPrintFile"...

Hi Guys I have a developed a password form so that everybody has to have a password in order to use the system. At the moment I have just put the validation that the password will only be greater than or equal to 8 characters. how can I add other validation like first capital letter,1 numeric...

Frothingslosh, Just wanted to check if the below (creating batch file) is the API or not? TestFile = CurrentProject.Path & "\UpdateDbFE.cmd" ' sets the restart file name strRestart = """" & strKillFile & """" ' creates the batch file Open TestFile For Output As #1 Print #1, "Echo Off" Print #1...

I am working within a bank so just wondering if we get sql server express downloaded free of cost online then will the data be stored within our mainframe or we need to buy licence for sql server full edition? Can anyone please explain it?

CJ_London, I understand what you mean. If I need to convert the backend into more robust backend i.e. sql server, my question is can I use sql server express edition which is free of cost? If yes then where the data will be stored? Will it be stored within company mainframe or will it be cloud...

Ridders , We will develop new frontend using .net framework. So the backend will be sql server and that's why my question is.