Recent content by kabir_hussein

Hi Many thanks for the reply Im not sure what you mean by "autoReport module" i am trying to get either a form or even a message to tell the user to check if warranties have expired.

Hi is there any function or code which would allow me to run a macro every 20 days or so. This code can be implemented on the main menu. Many thanks

Hi Many thanks for the reply i realised what the problem was it was due to having that field as a text form not a date/time. hence it worked for one table and not another Thanks once again

Hi Sorry to reopen this thread but i have tried to reuse the criteria on another table of mine thinking it should be simply by just adding the query to another table But for some reason i do not get any data returned Any idea where i am going wrong Below is the query that is working SELECT...

Hi I am doing a date expiry query which has worked for one of my other queries i have copied the same criteria for another table but for some reason it does not work now Below is the SQL i am using SELECT Computers.[Machine ID], Computers.[Machine Type], Computers.User, Computers.Department...

Hi i have a report in my database that i need to run every 20 days or so, is there any coding that will allow me to run a report so i can check every 20 days or so when the database is open if any printers in our company have run out of warranty Many thanks

Hi just reading my 1st post it may not be as clear as i thought it was I am basically trying to do a textbox where users can type in a hyperlink (i.e. www.google.com) and then if the user clicks on the textbox it will open up the google.com Many thanks

Hi job done thanks totally forgot this as i have been for the last few years not using the form header and simply using the form

Hi I have a query where i search for data based on user names. I am trying to make my query show a message when there is no data from the query. As this is affecting my form by loading a blank form therefore my EXIT button does not appear and i can not exit the form Hope this makes sense

Hi I tried to Application.FollowHyperLink function but not sure how this works If users paste or type into the weblink field how does it work when i next go on the specific field and try click on the text box (as the weblink is not highlighthed) many thanks

Hello many thanks for the reply but this is what i am trying to do. Users will update a form about computer faults, if they find a site on a website they will simply copy the link and paste onto a text box in a form however this is not working as i am trying to make it work like Word where if...

Hi could some1 help with trying to insert weblinks by copy and paste on access forms I have been looking on the Access office help and also in this forum but could not see anything that would aid me Many thanks

Hi Keith Not 100% sure what you mean as i set the visble to no how will i click on it to enable the combo box Could you please show me an example if you dont mind Many thanks

Hi i have done this before but can not remeber how i did this. Basically i am doing a report function where users can choose which type of report they want to print- i am decided to use a radio button function so user have to click on the radio button to enable which report they want to view...

Hi i need to make a query run every 10 or so days as it is a query which checks if any printers in the database are running out of warranty Can anyone help on this I basically am trying to make this query run where if there is any data a report will preview stating this printer warranty is...