Search results

I've just started getting this lovely message when I try to compact my database... "The compact and repair operation has been cancelled. You might not have adequate permissions to the folder that the database is located in. You need full permissions to the directory the database is located to...

Well it’s been a rough few days for the North island of NZ specifically the east coast. We are in the middle of a national emergency with our region pretty much cut off due to destroyed bridges, roads and power substations. Luckily my family and home is all ok but the same can’t be said for...

My low level annoying problem is that every morning when I log onto my PC, all of my apps that I open, open on the monitor that they were closed from on the previous day. Except for MS Teams. Every day it opens fully maximized on monitor 1 and I have to drag it over to monitor 2 and minimize...

Another random problem that one of my co-workers is having is that he regularly will be working on a workbook in write mode and approx. half an hour later I'll hear him swearing and then showing me that his file has gone from write mode to read only. I've never seen this before and thankfully...

Maybe not an Excel question per se but this is where the problems are occurring so I'll post it here. I constantly have issues where I go to open one of my workbooks (on a network) and it comes up with the msgbox stating that "file is locked for editing by 'another user' " or by an actual user...

Hey guys, I was just wondering if there is any update in regards to this issue as it's driving me crazy. I have a simple db (using O365 on Win10) that really only has 2 users, me being one of them. I import text files into it regularly and part of that process creates a temporary 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...

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

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

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

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

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

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

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

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

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

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

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

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

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