Search results

Hi is it possible to have a txt field which will contain an email address and once you input teh address it becomes a hyperlink, so you can just click it and send an email from outlook?

HI I am trying to create a form where i have lots of txt boxes but I want all the empty ones to be invisible. I have sorted the code so that i can make the empty boxes invisible however what I want to know is what is a quick way of selecting multiple txt boxes in a code i.e my code is: If Not...

Hi Can anyone tell me what the advantage (or difference) is in using a switchboard rather than just creating your own form and using command buttons etc? Thanks

Hi I have just found out that my admin team have re-named all my folders so now teh folder that my DB was in is called a different name, so now my DB wont open as it says that it can't find teh file (as its still looking for teh origional folder name). Is there an easy way around this? (I cant...

Hi I am trying to create a search box on my form. I can create an unbound txt box and use a comand button to open a form and display a particular fields fine however this isnt quite what I want. I want to be able to use an unbound txt box and be able to search different fields. So I would...

Hi everyone I am tring to create a query so that when I click a command button I can get all the records that have a date between now and the next 7 days. the reason why I want this is because my DB is a servicing schedule and I want to be able to click the button and have a list of all items...

HI I am just wondering if any one knows why if I have a list of numbers e.g. 1,2,11 and I do sort assending does it put them in the order of 1,11,2 rather than 1,2,11 Does anyone know how to correct this?

Hi I have a data entry form to enter a new record. the forms is set to data entry and pop up. My problem is that it wont let me add a close button either through wizard or manualy it just come up with: object or class does not support teh set of events. How can I get it so that when I click a...

Hi I have a command button on my form which when clicked changes a date in a field of evey record in a table. I have updated the code so that an extra msgbox comes up asking if it was the current user who did teh work. If the user clicks yes a field changes to their login if they click no then...

Hi i have a list box on my DB. Is there any way I can have a button so that when clicked a txt box comes up where the user can enter a new value into the field? Thanks

Hi I have a number field which controls a yes/no box (basically if the number is greater than 0 the box is ticked). However I have just discovered a problem, if the user just deletes the number rather than putting a 0 in teh box it wont change my yes/no field to no. How can I have it so that...

HI Everyone i have a field in my table (min qty) which needs to be filled in once when entering a new record but I dont want to show it on the form all the time. How can I have it so that when the ref number is blank the field is visible and once information has been entered it is invisible? I...

Hi I have a macro to send a query to an email address. Is there any way I can have this execute every Friday? Thanks

Hi I am just wondering if you want to say in code that the field is empty you use "Nul" however what if you want to say that the field has text in it, is it just Nul=false or is there a better way? thanks

Hi I am trying to create a txt box to display the current user, I tried Environ("username") but this displays the user logged into windows. I really need the user logged into the database ( a username and password is required to log in) as they may not always be the same Any ideas?? Thanks

Hi again On my form I have a "last updated by" field which works fine, I have added a label to this field so it reads "this data was last updated by" then the "changed by" field I want this to be where if the field is blank in the changed by the label is invisible I have used the code: If...

Hi I'm just wondering why sometimes when I try and write new code does it go red straight away and wont let me use space (when I press the space bar it moves forward then jumps straight back) Any ideas thanks

Hi I have really confussed my self but I am sure that I am nearly there! I have a form which will show personal detail which the user will update. These updates are shown using a subform and are entered by using a pop up data entry form. This all worked ok until I added more than one user now...

Hi When my DB is opened a txtbox macro opens telling the user that they need to set a password and how. This come up each time the user opens the DB, is there any way that I can get the macro to open only if the user doesnt have a password set? Thanks

On my form I always get a grey box that I cant get rid of. Does anyone know what it is and how to change it?