Search results

  1. Darrell

    Auto-population of table

    Hey guys, bit stuck on this problem.... I want to do a simple stock control function based on three areas; Stocktake, goods inwards and sales. The bit I am stuck on is the stocktake part. Example: I have a products table with say 10 items in it called in this case X1 to X10. The stock can...
  2. Darrell

    Using IsVisible property

    Going down a death spiral on this one and have finally given up... I have a report based on a query of orders vs deliveries. For each item in the order there may be several deliveries as they can be spread over a time period. So in the report, it shows duplicate lines for the order item (Inv...
  3. Darrell

    Datatype mismatch in Union query

    Just for a change I have something that was working perfectly for well over a year that has now stopped working and is causing vast amounts of :banghead::banghead::banghead: I am doing analysis of production operation times and as such have two tables - one which has production order header...
  4. Darrell

    More 2010 wierdness

    I have a spreadsheet that I have set up as a Gantt chart with lots of little coloured squares and text boxes. One of my macros re-organises all of these based on start and finish dates of the individaul charts and fills in gaps where ones were deleted etc. This all worked absolutley fine using...
  5. Darrell

    Calendar stuff

    ok so my workplace decides that it would be great fun for us to upgrade from 2007 to 2010 and my worksheet calendars stop working. Turns out that MS in their infinite wisdom have stopped using the Calendar Control and replaced it with something else like DatePicker. So after much research I...
  6. Darrell

    Report filtering again...

    I am trying to do a supply/demand shortages report and as such have tried valiantly to do a running sum calculation in a query but that was waaaaaay too painful and so I have given up and left the query reasonably simple. On the report that is based on this query, I have a calculated field that...
  7. Darrell

    Output format of Nz() function

    I have a query which has three fields using the Nz() function from three different tables. In the tables these fields are stored as numbers. In the query however, the value doesn't seem to be output as a number as: 1) I cant change the format to standard and 2) if I add two of these fields...
  8. Darrell

    End Of File error

    Hey Guys - I have a wee problem while trying to import a text file in that I get the Run-time error '62' Input past end of file error. Now I know what is causing this but not how to fix it.....(I'm smart enough to know how dumb I am :rolleyes: ) Basically, the text file is comprised of two...
  9. Darrell

    Sorting the good from the bad....

    I'm creating a simple report based on a query for demand tracking. I am trying to sort based on one of the fields in this report but I get the "Too complex to be evaluated blah blah blah..." message. This field is calculated in the query so I can't see why it doesn't work. The query is...
  10. Darrell

    More querying of null values...

    Hi guys, I have an issue with my soccer db which has happened for the first time ever and it has got me stumped. When I report the weekends game in my db, I enter the results for the division into the main form and when my team is selected, I enter the goal scorers name and the number of goals...
  11. Darrell

    Supressing Page Headers

    Hi guys, I've got this report (well it's not actually mine but I'm helping...) where there is a graph in the report footer and so the user would like the page header and footer removed from the last page of the report. Now I've had a bit of a look around and I found this which has mostly...
  12. Darrell

    Disabling Splash Screen

    I've got a bit of a problem with splash screens at the moment. I finally managed to create a start-up form which has a timer event opening a menu form and this works perfectly. I then decided to look at how to disable the Access splash screen and after reading through quite a few posts, found...
  13. Darrell

    Inappropriate query type...?

    I am the manager of one of the local football teams and as such provide a report every week of the results etc. One of these reports is specifc to our team where it reports the following info by week for the season. Date (of game played) Vs (opposition) Goals for Goals Against Player of...
  14. Darrell

    Don't shoot me just yet...

    After spending most of the day searching the forums I've given up and decided to ask for help, so please be gentle with me. I have a form which uses two dynamic combo boxes to filter for a specific record. This is pretty much EXACTLY the same as the one in the MS Solutions database (Edit...
  15. Darrell

    Sluggish Refresh

    After trolling through the forums for some time, I haven't been able to find a solution to this problem so... I have a form that has several dlookups and calculations based on them for a product costing generator. When the user has finished inputing data, they click a button which refreshes...
  16. Darrell

    Modify pics

    I have a small database which is used by our sales team as an estimation tool for new products (food packaging). They would like to know if it is possible to have a picture of a product a) linked to their choice of product type and b) modified relevant to the dimensions that they enter for that...
  17. Darrell

    Leaving parameter entries blank

    I have a form which inputs the parameters of a query such as Start Date, Finish Date, Shift Number, Machine Number etc... What I would like to know is, is there a way to have all of the data selected from a query if one or more of these parameters are left blank. ie, if I selected a Shift...
  18. Darrell

    Too complex?

    I have a report which displays a field called "Mod Std Set Up" from a Query. When I try to sum this field in the report footer by using =Sum([Mod Std Set Up]) I get a system message stating that either the expression is mis-spelled (which I've checked a thousand times) or it is too complex and...
Top Bottom