Search results

Evening all, its been a while since ive been here and yet again i need your help. I have a form listing a number of employees, using a unique employee ID number. At the moment when i want to update their records with user preset data the user just double clicks the employee ID number. I want...

Just a quickie. (i hope) i have no problem with splitting a databsae and linking to its tables across a network as such. what i was wondering is if it is possible to speed things up a bit. ie. keep the front end with the graphics reports etc on 1 machine. the tables on the backend and have...

Thanx for that Pat. I have used the combo box previously both with and without SQL. I don't need this for any particular application. I have started off with the basics of a97 and progressed through using VBA. Thanks to the help of this site my skill level with VB coding has greatly...

I am completely new to SQL server stuff so please bear with me. I have read a few posts from various sites and downloaded several documents but to be honest they all seem a bit to indepth for getting me started. i am quite happy relating the SQL statements to the Actions carried out when...

i have populated a form with treeview control. how do you assign an ID to each of the nodes? how to you refer to the ID so you can ensure the correct action occurs depending on which node is clicked? thanks in advance ian ps i have tried posting this in VBA forum but it wont except it for...

I hope someone can help with a coding problem I am having in a series of reports. unitswap = "FF101aDate" mycheck = IsNull(FF101aDate) If mycheck = True Then mydate = DateDiff("d", initdate, Now) datecheck Else mydate = DateDiff("d", FF101aDate, Now) freqcheck End If I want to...

i have a set of combo boxes that is currently used as a criteria in a query. This works fine. What id like to do is assign the combo box data to a global variable that can be used at other points in the database. is it possible to assign a global variable as a criteria so i can use the combo...

I have seen the use of node trees to make navigation of databases have a similar look to windows explorer ie. expanding trees. As records in one of my databases can be updated with the same details I thought it may be benificial to have this feature on it. So far I have used the in built help...

I have created a form that relates to data in an underlying table where the field is set to memmo. when i bind a text box to the memmo field it only displays, allows input, for 255 characters. How can i get the text box to display the full contents of the memmo field? i have tried the help...