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...

Thanx Thanx pat. I thought as much even though i wasnt fully aware of the technical info. your info has backed up my thoughts that if better performance is needed over a network i will have to give some serious thought to learning SQL and upsizing the database. thanx again. ian

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 again Sorry for the delay in responding to your answer Pat. Perhaps I havent put what I wanted across clearly enough. i have used the combo box previously which works fine. I am not after SQL coding to do any particular task, just some assistance on getting me started. I havent got...

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...

VBA sorry shouldve said its a VBA application. im using a97 on NT4.

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...

open 1 of your VB modules. click on the tools button on the menu bar. click on the references selection of the drop down menu. scroll down until you find "Microsoft DAO 3.51 Object Library". click the check box to put a tick in it. click apply or ok or whatever is at the bottom of the...

I assume you have this form based on a query for a particular table. eg customer form is based upon "getcustomer" query that users the "customers" table as its record source. if this is the case you can enter the following into the criteria for the field that you want to base the search on ie...

Assuming your using a97 the number of fields for a table is limited to 255 so i assume the limit for queries is also 255 fields. hope this helps ian

in the criteria section of the filed you want to base the query on enter the following. like "*"&[Enter your parameter here]&"*" substitute "enter your parameter here" for whatever instruction or question you want the user to see. when the query is run it will generate an input box for...

I may be wrong here but i dont think you can actually do that. the reason being that you want the user to click on the label. This would require the label to have the focus. if you asign the focus to the label it actually sets the focus to the next control and not the label. I suggest you...

for my help system i created a word document that contained hyperlinks to other documents and powerpoint presentations. this enables the users to view help information for the areas they choose and is quite easy to navigate. i created a help button on the main menu that uses a hyperlink to...

im not sure if ive got this bit right but it might help you any way. in your query add an extra field that is set to the current date.ie Expr1: Now(). in the criteria use the expression builder to set it to return those values between you startdate and endate fields. ie. Between...

If you want you can create a command button on the main menu that when clicked asks for a password. create some VB code to check the password validity. you could set it as a string within the code itself or create a password and user id table. if the password entered is correct you can then...

In the form properties set it to pop up and modal then remove the control box with the minimise buttons and the shortcut menu. this will stop anyone minimising the form or right clicking to get in the design view. this also means the standard toolbars and menus are covered by the form to. If...

I may have misunderstood what your asking here. Is the password required part of a criteria in a query which is run on opening the form. eg criteria = [Enter Password] if so this will result in a standard request box that allows the text top be visible. The way round i used was to create a...

for the text field you are using go into design view, click on properties for that field, click on the data tab. select or type password in the input mask. this should do the trick ian