Search results

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

Hi I have got this working now using the following query Many thanks for all your help SELECT Printer.[Printer ID], Printer.Printer, Printer.Location, Printer.[Host name], Printer.[Printer Type], Printer.[Serial Number], Printer.[IP Address], Printer.Department, Printer.Usage, Printer.Server...

Hi i have tried the query you suggested and it has not worked here is the table i am trying to query SELECT Printer.[Printer ID], Printer.Printer, Printer.Location, Printer.[Host name], Printer.Warranty, Printer.[Date Expires] FROM Printer; the Date Expires will hold a date (i.e. 10 sept...

Hi Many thanks for the reply what i am proposing to do is have a warranty section for all computers, printers, but the warranty will be different for each comp, printer so i would need a seperate field for each hardware. How ever if i had a field with warranty expire(in the following...

Hi I am creating a database where i store information on all computer and printers we have. The printers have warranties usually lasting 2/3 years Is there a way i can set a function where when a printer warranty is expiring within 30 days a reminder is displayed on the main menu Many thanks...

Hi Just in case this doesnt make sense keyword search meaning a field that contains 50 words. i can type a word in and anything that matches that will be shown in the query. Many thanks