Search results for query: *

I have a database which logs when a user opens the database and modifies certain things. The problem arises when another application connects to the database and changes the data that way. We have 1 guy who uses excel to read data and modify data. I would like to be able to run code in the...

Ok, this is going to seem like a stupid problem but bare with me… I have a 2002/3 database with a treeview on the left which filters all the forms to the right. 90% of the time, it works great. The other 10% is something else. It seems not to register the clicking in the tree and even if I...

Hi, I am having problems galore when trying to view pages on this computer from another. I can go to http://dell2006-1/localstart.asp and get the ‘Your web service is now running’ message so everything is fine there I think. I can remote desktop to another computer on the network and copy and...

Does anyone here know all the ins and outs of the access treeview? First I would like to know are the contents of a treeview saved when the user clicks save or when they are stored? This is because an error is cropping up when the number of items in the tree is modified. When I output the...

Does anyone know lots about the graphing in visio 2007? I am trying to draw graphs using data from excel and SQL server but when I try and connect the data to the shape, it will only take one record per shape. I don’t know how to connect multiple data to a single shape. Anyone have any good...

Hi, I am trying to create a simple addon for visio 2007 from visual studio 2005 but have hit a brick wall. When running code to create a new shape, the code runs until this point then just stops and jumps back into visio from VS. I have followed this guide but when it gets to the adding a...

Does anyone know if it is possible to create and save a query using VBA? I would like to be able to create something like the following... "Select * from tblUsers Where [location]='Australia'" and save the query as qryAussieUsers Is this possible?

Could someone help me translate a line into vb.net? I am updating a load of labels from a recordset but need help putting it in a loop rather than doing each one individually. For x = 0 To 11 Me.lblPlayer1.Text = rstMain("FirstName").Value & " " & rstMain("SecondName").Value Next x I...

Hi, I am looking for a way to share code amongst various applications. To start with it has to work with Excel and Access and later, vb.net. I have various functions written in VBA and stored in the background of various applications and I am hoping to find a way of storing them all in a...

Hi, Does anyone know how to list the tables that are in your database? I would like to fill up a listbox with the names of all the tables in my database. I remember seeing someone do something similar ages ago but I cant find it again. Any help would be appreciated. Joe.

Is something along the lines of this available? For this example, I want to be able to send the name of the form into a function, so I can modify things on it. In the end, I would like to re-use the function and send in various forms. If anyone can assist, it would be greatly appreciated...

I was wondering if this was possible or not. Can I write a function like the one below, which will accept a value and return many values? I would like to set various columns from one score. If I have something like “Expr1: returnArray(42)” in the query, can the function return the 3 values and...

Hi, I have encountered a problem and was wondering if anyone has come across one similar. I have a query running a function called GetYesNoScore (See below) with various parameters. It is a function to see if a field is a “1” and if so, count up the weighting. So, if I run...

Hi, I am trying to get rid of all the calculated values in my database. Some of the calculations are quite complicated so I was wondering the following was possible. Have a function like this... Public Sub calcScore(q As Integer, q As Double) If q = 1 Then calcScore = q...

Hi, I have the following code for working out a log function. When I put it in my database I get this error. "The expression On Load you entered as the event property setting produced the following error: Expected variable or procedure, not module." The code is; Static Function Log10(X)...

Hi, This problem has been bugging me for a long time now. I have some toggle buttons on a form which are bound to records in a table. When I select some buttons then click to another tab that uses the same table I get the Write conflict error. (This record has been changed by another user...

Hi, I don't know if this is possible or not... I have developed an application for a client and I was wanting to replace the built in help pages with my own application specific help. Is this possible? If so, have you any tips for searching for help on the matter because I am not having much...