Search results

Dear all, I have an array: varray = array("john", "paul") How can I add values to my array with code in order to get something like vresult = varray + louis vresult = array("john", "paul", "louis") Kind regards, Hans B.

Yep it works. Thanks man.

I have the following code for when a user closes a form Private Sub Form_Close() vconfirm = MsgBox("Are you sure you want to quit", vbYesNo, "IT problemlog") Select Case vconfirm Case vbYes 'form will close Case vbNo 'don't close the form End Select End Sub How can I...

A classic problem: I'd like to retrieve records between txtstartdate and txtenddate. For example all records between 04/11/2007 and 06/11/2007. Easy enough, if Access wouldn't always want to change the formatting to mm/dd/yyyy instead of dd/mm/yyyy. How can I resolve this issue? Kind...

Yes I do. In the attachement a screenshot of how it looks. Please note I want to keep the main window opened.

Nope, it ain't working. Columns are still visible...

Hello, I have created a pop up window where I can select which columns are hidden on a datasheet on my main form. This pop up window will write the selected settings to a table when closed. I would also like that the main form re-initializes so that the changes are visible instantly. When I...

How can I make sure a date on my form will always be in this format: dd/mm/yyyy Access seems to switch things around to it's own liking: - 11/05/2007: Access reads this like 5th of november 2007 (wrong) - 26/10/2007: Access reads this like 26th of october 2007 (right)

Isn't writeline supposed to start a new line when you write data to a textfile? Set fs = CreateObject("Scripting.FileSystemObject") Set vtextfile = fs.CreateTextFile("c:\testfile.txt", True) vtextfile.write ("test") vtextfile.Close This code replaces what's already in the file with...

Simply but effective. Thanks a lot Ken! :)

Hello, I need to look up a textbox name in a table and then refer to the same texbox on my form. For example (how it should work in theory): vformname = dlookup("fldformname", "tblfilter", where xxx) me.vformname = 29/10/2007 How can I make this work? Kind regards, Hans B.

Actually I've just found the following: RunCommand acCmdUndo RunCommand acCmdRecordsGoToPrevious Is this also valid?

I have refential integrity turned on in my relational database. Suppose a record is created by accident in a form and the user wants to cancel this record he will get a prompt saying that the record needs a value in the related field. How to abort a record with vba (so I can create a cancel...

Actually no, and how would it be applicable in this case?

Hello, suppose I have a table with 3 persons: - John - Kate - Rudolf and suppose that I have a table with 3 types of fruit - Apple - Orange - Banana How can I make sure that when John takes the apple, it won't be visible for Kate and Rudolf, until John 'releases' the apple? In other words...

Hello Wazz, thanks for the reply. I got around trying it today and I got the query's working. Unfortunately I was still not able to make it work on the forms. I tried the following in vba: lstissuesbound.RowSource = "SELECT * from qryselected1 WHERE tblissuelog.fldcaseid = " & Me.txtcaseid...

Dear all, please see screenshot for table structure and a form view. tblcases is a table with information about a case. tblissues is a table with issues that can occur for each case. tblissuelog is a table that links cases with issues. A case can only have the same issue once, but one issue...

Which is a good idea when nobody comes up with the answer.

Hello, when I update a form with a new record, that record will copy to any previous record that I click in the same form. This only happens when I'm adding records to a table that contains a memo field... Anything I need to keep in mind about memo fields? Kind regards, Hans B.

Hi, people randomly ask me to install software on their PC's. Instead I'd like them to be able to fill in this form (see attachment) so all information is stored in a database. The fldsystems field is pulled from a table. How would I create the 'required' field so that multiple users can...