Search results

Hi Can anyone give me some ammo to tell me boss what a safe number of users of an access database is. It is a well built database that runs quickly and effiecently but I need to know at what point this will be put at risk. 100 users? 200+? I am running the database a FE/BE with the client...

Thanks Roy-Vidar and my aspologies again for PM'ing you. Its the first time I haver used it.

If I wanted to add more afterward, how to I seperate the first concatenated variable from the next?

Great stuff!! Thank you so much.

Hello Can anyone tell me how I use a variable I have defined within a SQL string. e.g. ***code start *** Dim ComputerName as string Dim Sqlstr as string ComputerName = Environ("ComputerName") Sqlstr = "INSERT INTO ComputerName ("ComputerName") SELECT ***This is where I need help including...

I know..I am too :-) Thanks for your reply mate.

Can anyone please help me with this? Thanks Gareth

HI Thanks for your reply. I have posted it now. If you try and open if the single form that is in there it will hang. The code is probably nothing like what I should be doing... :-(

Hi I have created a small form that hold a cube of 9 boxes on it. The idea is that it will act as a small icon that indicates the system is loading. (Purely cosmetic) I have triggered the boxes to change colour on a loop when the form loads but the problem is that the loop function is being...

Great! Thanks. I will give this a try.

Hello all...Happy New Year!! I have obtained some VB code shown below which adds an icon to the windows task bar as I intend to put some additional code behind this that displays messages near the clock when something happens in the database. The problem I have is that the code does add an...

Thanks for your reply. Could you give me an example of the code I would need to write...please and where it would need to go in the form code. Thanks

HI all I have managed to populate a treeview with some menu items I required and it looks great but I now need to get it to do something. How do I get a tree view value (selection) to act as a variable in routine. e.g. if my tree look like this. Menu ¦ - Compaint management I...

Sorry...Im being dense...I have worked it out. Thank you so much for your help!

HI again If I wanted to link this to a text box do I simply do: Me.txtbox = Debug.print Environ("USERNAME") ? Thanks

Thanks I will give this a try. :-)

Hello to you all... I am just after a bit of assitance if anyone can kindly help? Basically, I need to redevelop a Complaints database for my employer as the current one is no longer fit for purpose. The current database is a FE/BE database and users are required to login with a username and...

Hello I am aware that there are a lot of existing threads relating to compacting and repairing but I cant seem to find what I am looking for. Basically, I developed a complaints database for my employers and it is used by around 45 people at any one time. The database was one of firt I built...

Hello people. Im just after a bit of advice please?? I have created an audit trail for data held on a form so that when a field is changed it adds a line of text to a memo field with the date of the change and the old and new field values. The problem I have is that each time something is...

I do not use DAO but I will think about this for future models. I do also use some memo fields. Thanks for your help everyone. :-)