Search results

  1. A

    Word graph vba

    Good afternoon I have been struggling with some word automation I set up for a word 2007 document. It worked ok when it upgraded to 2010 however the upgrade to 2013 completely destroyed the functionality I was using. The task I an looking to acommplish is relatively simple. Open the...
  2. A

    Problem with DoCmd.TransferSpreadsheet

    I recently experienced a puzzling problem with DoCmd.TransferSpreadsheet. After having the some code run successfully for several months on a daily basis, the data from a spreadsheet was suddenly not imported anymore. There were no error messages or any hint of why the import failed. After...
  3. A

    Run stored procedure providing variables from form

    Good morning Following concerns about someone accidentally deleting the access database we have been using to crunch performance numbers, I have successfully moved the data on to an SQL server :D While the database works as it is, several of the queries are running extremely slow. I therefore...
  4. A

    Using a web API to load data

    I have been dabbling in excel to get data from an online database however I would like it to come straight into access instead of coming through excel. In excel it is quite easy using a web query however I have not been able to find anything that can do the same in access. Is it even possible...
  5. A

    Pivot trouble

    I have a problem with a pivot table that I am sure can be solved. What i need to do is rather simple if it did not have to be done in a pivot. My data is arranged and shown like this: Date Hours MaxHours 03-11-13 740 792 01-12-13 674 672 01-01-14 568...
  6. A

    Which is the best way???

    After getting everything to work in the first place I am now looking at improving the speed of my queries since it takes 5 to 10 seconds to make the final result. As it is today, I have 16 queries that collect and make calculations from a variety of tables for different subjects such as budget...
  7. A

    Summing up in report

    I have been working for a while on getting a rather complicated calculation working right but after getting it to work I have been hitting the wall with a head that feels like a pinball ball. The following calculation works for calculating the amount for each line for [IncentiveAmount] in the...
  8. A

    Counting number of vessels for each month

    I have been trying to get a count of the vessels we are operating grouped by months. The data is structured as follows: VesselID - VesselName - DateInManagement - DateOutManagement DateInManagement is always filled out with a date. DateOutManagement is either with a date or null. What I would...
  9. A

    Numbers, queries and Iif

    Does anyone know why access insists on throwing a syntax error when I enter the following in query: Performance: (IIf([tbl].[Number]>0,0,100))? After rooting around I ended up doing this by mistake: Performance: (IIf([tbl].[Number]>0 ,0 ,100)) Then it works however it is still being displayed...
  10. A

    Can I change which query is run from a button?

    I am working on creating a dashboard for selecting various parameters and then viewing the results. While I can create a dashboard for each main group I am working with I thought that perhaps you could use a combobox to provide the input for which queries it needs to run to get the desired...
  11. A

    Critique of first database

    I have finally completed my first database from scratch and so far it seems to be doing its job. I would like to invite you to give me some critique on it as I am sure I have made some things that could be improved or should never have been in the first place. The sample database is only in...
  12. A

    Data entry form problem

    Good afternoon. I am struggling to get a data entry form to work the way I want it. Basically I have a number of questions that have been answered by a number of participants. Still being new with access I have set up the tables and relationships as I believe they should be. I have attached a...
  13. A

    Question about questionnaires

    Hi everybody. After giving up on my last attempt at learning access, I have decided to come back for more. I have decided to try to make a database that will help us analyse the various inspections that are carried by outside companies. I got most of the basic tables needed for this figured...
  14. A

    Query for top three and building a list from that

    I have decided to try and build a database in access 2000 for keeping track of the catches we get in my fishing club. We have yearly competition where the top 20 catches of each species give points to the overall competetion. Each member can only participate with his top three catches. While I...
Top Bottom