Search results

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 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 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 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 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 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 Does anyone know how to do a keyword search in MS access so in a knowledge tree with 100 of records with a few keywords in one of the main fields i.e. symptoms i can reduce the amount of records to go throught Many thanks in advance

hi i have been posting a problem i have been having with trying to open my database on the network once i used the security wizard. however i think i may used the wizard wrong and hence i am having problems tryng to open my database on the network. Could someone please if they dont mind in...

Hi i have recently created a user group for my database using the security wizard. However once you create a user group the security wizard makes a shortcut to the main database. You have to use the shortcut to get into the main database. This is fine however i tried to use the shortcut from...

Hi i have recently set a security wizard where users have to type in their name and a password in order to get access to the database. Does anyone know of any code where you can show the name of the user on the main form. At present i have a username on the form but that is linked to the...

Hi i am hoping to make my database secure so users can not edit the designs of forms or even tought tables. queriies etc I have had a look at the tools menu and tried using the security wizard but it is a bit confusing can anyone give me some tips many thanks

Hi I have an order report form which due to all the headers needed for certain reasons i have been asked if i can do a report on A3 paper. Is there anyway i can do a report on A3 and change the setting so i can even out all the fields to fit on a A3 paper size many thanks kabir

Hi i have done a database and was wondering if there is a way you can hide the forms and also dont allow people to click on design form. I want the users only to see the forms and prevent them from touching the back end of the database i.e. the tables etc many thanks

hi i am doing the following update query to update prices UPDATE PartTable SET PartTable.[Selling Price] = (([PartTable]![Mark Up]/100*[PartTable]![Guide Cost])+[PartTable]![Guide Cost]) WHERE (((PartTable.Category)=[Forms]![FrmCategoryEdit]![Sub Category])); but for some reason when i save...

Hi i have a form where i can search for parts in the database. However the form ( please check the attachement) is done using radio buttons which u click on to enable different searching methods. Is there any way when you click on another radio button the previous drop down box can be set to...

hi i have a form containing data from different suppliers. Each supplier has a supllier ID, Name, lead week, price. Based on the lowest price is there away i can send data to another field showing the lead week. The lead week is that of the best price I have tried endless amount of ways to do...

Hi i asked a question couple of days ago where i wanted to know if there is a way you can get a primary key byt adding two different fields togeather. i was told to use the following code =[IdentifierCode] & "" & [item No] which worked fine but i have realsied that as i have changed the...

Hello I have a query regarding data from a sub-form being transfered to a main form. At present i have a part list and a subform which holds prices from different suppliers. The cheapest price shown will automatcally be selected as the best price and will be shown on the main form. This part is...