Search results for query: *

This is starting to irritate me so if some could tell me if this should work in Access 2003 I'd appreciate it I'm sure I've done this in the past by declaring an array like this. Dim myArray(-1) But I can't remember what I was using at the time (VB5, 6 or VBA or something else) The idea...

As PHV says you'd be better of using a recordset or you could use an update query which should be quicker

You can set the new forms "Pop up" property is set to yes. This will keep the form on top of all other forms. Or You can use the setFocus method in the code which opens the form. Waud

Hi Whilst you could use seperate vairables to store the selected items storing them in an array would be an easier option. The code below gives an example of how to do this Private Sub StoreInfo() Dim varItem As Variant Dim intAryCount As Integer Dim lstBox1 As ListBox Dim...

You could either use a Select Case procedure e.g. Select Case Me!nr Case 1 to 10 'You're Number is between 1 and 10 Case 50 'You're number is 50 Case > 100 'You're number is greater than 100 Case Else 'Does not match any of the above criteria End Select or you could...

Jason This is a bit of a guess but if the cycle property of the form is set to "All Records" and the combo box is the last control on the form then when you tab to the next control the form will be trying to go to a new record. Hope this helps

I sounds as the field you're talking about is has been set as a foreign key. Have you checked the relationship for the table.

Hi To recreate the procedure using ADO (& ADOX) something along the lines of the code shown below should work. I'm still using Access(97) at work so haven't been able to test this but I think it should be OK. Sub CreateProcedure() Dim cxnDB As New ADODB.Connection Dim cmd As New...

Hi I've used code similair to that below (in A97 but it should work with A2k). Which takes the file path as an argument and also has an optional file extention argument. Then returns an array of the files found in the specified location. Public Function strGetFiles(astrPath, Optional...

Cheers for the help guys. I've now got the fuction working

I am trying to write a function in Excel(97) that when a user enters a value into a cell it compares the new value that has been entered and the old value of the cell, and returns the difference between these 2 values. I realise that I could do this by using to different cells but unfortunately...

Can someone have a look at the following log and let me know if there is anything that shouldn't be there. Also where can I find what these entries mean. Logfile of HijackThis v1.97.7 Scan saved at 22:16:32, on 09/02/2004 Platform: Windows XP (WinNT 5.01.2600) MSIE: Internet Explorer v6.00...

Carl The code below is an example of how to call a stored procedure (a saved query) in access and set values to its parameters. I've assumed that you using DAO if not let me know and I'll post an example using ADO Dim recRecordSet1 As DAO.Recordset Dim qdfQuery1 As DAO.QueryDef Dim strValue1...

Thanks for the pointer vbkris

Hi all I'm fairly new to ASP and have been roped into writing an ASP site for a friend, he wants to use a component (.DLL) provided by a third party. I've spoken to the Host and they have advised that I can upload it to the webspace and they will then register it on the server after which I...

If you create a form and set the modal property to true. This will then act like a inputbox (and msgbox)

It sounds as the field name is not being found in the recordset object you are using. Have checked that "ShWithValues.Cells(Row1, ShColNo)" is returning a valid field name.

As an addition to pellets you could use an update query. However if you have to use VBA then I would use something similar to the code below. Sub UpdateValues() Dim recSet As DAO.Recordset Dim intTemp As Integer Set recSet = CurrentDb.OpenRecordset("TableName&quot...