Search results

  1. A

    Record / Table locking issues

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

    trouble with quotation marks...

    Sorry, I should have been a bit clearer. Datatypes are as follows: CorrRef - Autonumber DiaryID - Number CompanyRef - Number CompanyType - Text Contact - Text Date - Date/Time Time - Date/Time Notes - memo Createdby - text CreatedWhen - Date/Time
  3. A

    trouble with quotation marks...

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

    Calculation of currency...

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

    Avoid Duplicate Entries

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

    Listbox to show time

    That works perfectly :-) I'm a great believer in not doing anything i dont understand fully though so please could you explain how the 'red' added bits have worked - is it similar to the Trim function; i.e. it is only showing 5 characters (being the 4 numbers and the semi-colon?) Thanks again...
  7. A

    Listbox to show time

    I have tried adding display_time = Format(display_time, "h:n") But this is not working??
  8. A

    Listbox to show time

    The only other thing is I only want it in Short Time format - I tried to put display_time = #9:00# instead but it keeps reverting back...
  9. A

    Listbox to show time

    Perfect!! I knew I was close with the code but couldnt work out why it wouldnt show in the box! Thanks! :-D
  10. A

    Listbox to show time

    Thanks, that does seem the easier option however I was really hoping to avoid that and increase my knowledge on the VBA side of things. I have found the following code that I have tried adapting however although the loop is working fine the actual values are just not appearing in my listbox...
  11. A

    Listbox to show time

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

    Filter Combo Box Results

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

    Filter on Select Query / List Box

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

    Tab Control ForeColour

    Thanks, good idea, the only problem I have is that certain tabs on my control only appear in certain situations so I am finding that the label is in the wrong place on some ocassions, if that makes sense?? I cant actually get the label to 'stick' to the top of the tab...??
  15. A

    Tab Control ForeColour

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

    Select distinct

    I have just read somewhere that it wont work properly if some of the fields have Null values, could this be the problem?
  17. A

    Select distinct

    I have tried changing the properties in my query to Unique Record 'Yes' - which makes the SQL look like this... SELECT DISTINCTROW Tbl_Correspondence.CorrRef, Tbl_Correspondence.CompanyRef, Tbl_Company.Company, Tbl_Correspondence.DateOfCorr, Tbl_Correspondence.TimeofCorr...
  18. A

    Select distinct

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

    Record Locking

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

    Runtime Shortcut Menu

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