Search results

Good morning all Please help - having a nightmare! I have finally rolled out the database I have been working on and already have fallen at the first hurdle! - I have multiple users needing to use the database at the same time. - They are using a run-time version of access 2010. - The...

Good morning all I am hoping some can help... I have written the following code which allows a user to save notes on a phone call taken (for a CRM system). There is a 'notes' field (memo) which the user is free to type whatever they want in. I am having major problems if the user decides to...

Hello Hoping someone can point me in the right direction please. I am creating a quick database for my hubby (keen gamer, under-statement!) I have 4 fields on my form for Price: 'Gold', 'Silver', 'Copper' and 'Iron', I want to be able to create an extra field that will concatenate the 4...

Good afternoon I am hoping someone may be able to give me some advice on the following... I would like to put something in place that will warn a user if a Company Name already exists in the database (to avoid duplicate records which would cause no end of problems). I have put the...

Good Morning :D I am hoping someone might be able to give me some advice on the following... I would like a list box on my form which lists times for the user to pick (increasing in 15 min intervals). I would like to start time to be 08:00 and the last to be 19:00 I know I will need to...

Good Morning Another query I am struggling with... I have a combo box that shows a companies Contacts. I have merged the forename and surname fields together (due to other aspects of the database) My manager has reviewed the database on Friday and has stated that he wants the Contact Combo...

Good Morning I am struggling to work out how to add to my existing query. I have a search form so that users can search for companies in the database. There are several 'filter' options that they wish to be available. I have managed to get the query working so that it filters a) by Company...

Hello Does anyone know whether it is possible to change the forecolour of the tab control Name - just for one tab? Thanks

Good morning I'm hoping someone may help, I am trying to avoid duplicates in one of my queries.... Can the SELECT DISTINCT be used in a query in access 2010. I have tried looking at the SQL view and inserting it at the start (after the SELECT) but that makes no difference... I wouldnt...

Hello - I'm hoping someone can help me to understand how this works. I have just opened my database (stored on a shared network) on 2 PCs. PC1 has the full version of Access 2010 PC2 has the runtime version The Options are set to Record Locking - all Records Both PCs entered the same...

Good Morning I am trying to find out how to create a shortcut menu for access runtime. For example I need the cut, copy, paste and filter / sort options available to my runtime users; as all of the usual menus / ribbons are unavailable I will need to create my own. Depsite looking on the...

Good Morning I have been working on a Sales Database for my boss now for well, way to long! I think I am finally getting to the stages where it is ready to be used (YEY!) I would really appreciate some tips / advice on how to successfully deploy my database across our network so it can be...

Good Morning I am hoping someone may be able to help with the following... I have a requery on a subform that in certain situations is trying to run after the form has been closed. Giving me the error that 'Access cannot find the referenced form'. I have attempted to solve this by adding...

Good Morning :) I am hoping for some advice on exporting data into Excel (2010). I have written the following VBA which is working really well. The only issue I have is that two of the fields (LTD and PAYE) are yes / no fields and the data is exported as True / False into the spreadsheet. This...

Hello I am hoping someone can help identify where I am going wrong ... I am having some trouble with the where clause - i think it is the ContractRenewal that is wrong - I need to show all companies whose contract is up for renewal in 3 months time... lsSQL = "" lsSQL = lsSQL & "...

Hello I have the following function which checks certain fields on a form for any changes. It then stores these changes and puts them on a form for the user to be able to keep track of old / new data. The problem I have is that I didnt allow for 'new data'... I only want the SQL statement...

Good Morning All, I am having some issues with Autonumber working with a global variable that I set... My database stores information for Companys - each company has its own unique reference (currently Autonumber). I have a global variable 'ICompanyRef' which uses this autonumber - I use...

Hello Just a quick question; I have a field in my Contacts table for 'Website'. I have set this field in the table as a hyperlink field. When the user enters the website address on the form this then appears as a hyperlink and will take them to the appropriate website when clicked - all...

Hello, I'm having a problem with conditional formatting - wondered whether anyone else had experienced this... I am trying to change the back colour of multiple text boxes on a continuous sub form to highlight particular records if they meet a certain criteria. I know the rule I have written...

Good Morning and Happy Friday :D I am hoping someone may be able to point me in the right direction with the following - I hope I explain it clearly enough but if anyone needs any further information please let me know... I am working on a diary system at the moment in which users set...