Search results

  1. G

    Update query help

    I have a resourcing database that lists the activities of a team of trainers and allows team managers to schedule work to the team. I have one member of the team however who does not work a Friday. I don’t want to have to schedule RDO (Rostered Day Off) every week so would like to run an...
  2. G

    Update field 3 if field 1 = and field 2 =

    Hi All, I used to be able to do this in seconds and now can't remember how, I have a database with a field called [Start_Date] which is a date field, a called [Trainer_Name] which will have a unique name and a field called [Activity]. What I want to do is update the Activity field to contain...
  3. G

    Why can't I think of a simpler way?

    Hi Guys Happy New Year I have a resourcing database which has a form created from a crosstab query with the dates of every working date between January 2014 and December 2020 as its left hand column. By default the form opens at todays date and I have created a refresh (actually requery)...
  4. G

    Amend sql for find duplicates query

    Hi guys I have a find duplicates query with the following SQL: SELECT tblData.Vendor, tblData.[Loccurramount EUE], tblData.Last4, tblData.ID, tblData.Line, tblData.CoCd, tblData.[Document record number], tblData.PurchDoc, tblData.Reference, tblData.Curr, tblData.[Entry dte], tblData.Status...
  5. G

    Make one combo list depend on another

    Aaaaargh!!!! I hope someone can help. I've done this a million times and it always gives me grief. I have a combo: cmb_TrainingType. The sql is: SELECT tblTrainingType.TypeID, tblTrainingType.Type FROM tblTrainingType ORDER BY tblTrainingType.Type; My second combo (the one that should be...
  6. G

    Limit combo list

    Hi Guys This is related to another post. Can anyone tell me what I'm getting wrong with this code? I can't fathom it as it appears to be identical to the code I've used in another combo yet it works in the other combo. SELECT [Trainers_Projects].[Trainer_Name] FROM Trainers_Projects...
  7. G

    Inteligent combos

    Hi guys I've attached a rudimentary example db to give an example of what I'm trying to achieve. There is a form on the db called Resourcing with several combos. When I choose a Training_Type from the first combo it automatically filters the Project_Title combo to show only the...
  8. G

    Show all names in first column and insert zero where no record exists

    Hi There I'm sure I've seen this on here before but can't think how to word a search for it. I'm tracking the holiday entitlement of a team of people. I use a query to work out how much unbooked holiday they have to take. My problem is where I'm scheduling next year my query returns the...
  9. G

    Calculating the information for a text field on a form from a query

    Even thinking of the title for this question was difficult for me. When it comes to code I'm a rank amateur. Just ask vbaInet:D Here's what I would like to do: I have a data entry form [Resources] and I would like to display some information about holidays in the form footer. Once the user...
  10. G

    Warn about conflicting entries and offer choice to edit conflicting entry or current

    Hi All I'm hoping someone can help me with some code to handle duplicate/conflicting entries. I am creating a resourcing database. Staff are scheduled for either AM, PM or All day for each date using a Form ("Resourcing"). The fields on the form are [Start_Date], [End_Date] and [Duration] (ALL...
  11. G

    Paste query to Excel template

    Hi With loads of help from vbaInet I was able to create a form with lots of conditional formatting that did pretty much everything I wanted it to do. The only problem is that it takes about 4 full minutes for the form to open. As an experiment I am reluctantly now trying to display the results...
  12. G

    Conditional formatting with like

    Hi Guys What I am trying to do is create conditional formatting to colour fields within a form. The conditional formatting option built in allows me to colour based on set values i.e. Value=Design turns green. I need to somehow say if Value contains the word Design turn green. This...
  13. G

    Event procedure on selection

    Can't quite get my head round how to write this but I know it can be done. I have a form with a field called duration. The user selects AM,PM or All Day from a list If the user chooses All Day I want to create a duplicate record DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand...
  14. G

    Create duplicate records with incrementing dates

    Hi Guys I have almost no experience of VBA outside of working a little with codes generated for me like docmd etc. If I can explain in English what I am trying to do can someone point me in the right direction to start creating the code. I am trying to create a database for resourcing staff...
  15. G

    I must be nuts

    Hi All I'm not technically a new member but I've been away for a while. About four years ago I created a database for recording the activities and hours worked for my team. About two years ago I updated it. It became a big hit and it's used in all sorts of ways to analyse what training we...
  16. G

    Append query help

    I want an append query to duplicate a record I create but change the date. Let me try to explain. I create a record that records someones activity between a given start date and end date. I have a query that works out how many working days between the start and end Let's say the query says...
  17. G

    Help with Iif calculation

    Total Hours: IIf([Time]="All Day",[Work Days]*7.4,[Work Days]*3.7) So what I am looking to return in English is: If the time entered in the Time field is All day then multiply the figure in the Work Days field by 7.4. If the entry in Time isn't All Day then multiply the figure in the Work...
  18. G

    Crosstab query using dates

    I'll probably have a hundred questions following on from this one. What I'm hoping is that someone has maybe tried this before and has an example that I could reverse engineer. I want to create a cosstab query with dates for the next 12 months accross the top as columns and employee names...
  19. G

    #Func! Calculating difference between times

    Hi all, I'm returning to access after quite some time and discovering that I have forgotten how to do even basic stuff. I am starting to create a resourcing database that needs to be able to work with dates and times and perform calculations on them. I need to work out the number of hours...
  20. G

    Date formula not working access 2010

    Hi All I'm possibly missing something obvious here but a date formaula that I was using in access 2007 doesn't seem to be working in 2010. The formula that I had was Between DateSerial(Year(Date())-IIf(Month(Date())<4,1,0),4,1) And DateSerial(Year(Date())+IIf(Month(Date())>3,1,0),3,31). The...
Top Bottom