Search results

Thanks for the information, Just an update. Someone else in the office had the previous copy of the database which had the same queries, with identical sql (incl. the having statement). The only difference between his copy and my copy was that his copy used the old flat form design, and mine...

Hi I have 3 queries which produce statements for customers/suppliers and anyone with an overdue balance The customer/supplier statements work fine, and here is the sql: SELECT STATMENT.CUSTOMER AS [Customer Code], STATMENT.LINEDATE AS [Invoice Date], STATMENT.REFERENCE AS [Tyrenet Invoice]...

The report is used in 2 ways, 1. To create credit stop warnings for ALL customers when run once (Using a "Like * & [MyString] & *" to pass in a value). This is done at the end of every month, and i use grouping to create seperate reports in one run 2. To create a credit stop warning for one...

Hi I have a report which creates overdue payment notices for any accounts with outstanding balances over 60 days old. Every time i run the report it gives me the error code 2467 ("The expression you entered refers to an object that is closed or doesn't exist") When i run debug it shows me the...

That could be useful. We have some XP, some Vista and some W7 machines so the path can differ slightly due to directory structure

Hi I use the RunApp Macro to switch between a suite of databases that we use. When i release an update, I put front end of the DB on everyones machine. Only problem, I have to update the file path to include their users name. Can I use some code in RunApp to pull in their user name so it...

Never mind I have gone about it in a different way! Although if anyone has any advice in case i try this method in the future then please do post a reply! Thanks

Hi I have a form that I am using to filter possible parameters for a query. I have 3 unbound combo boxes in the following order: 1. SELECT DISTINCT [tblFleet].[Customer] FROM tblFleet WHERE [Customer]>"" (allows the user to select a customer who is NOT just a tyre dealer - hence the distinct...

I have sorted it now When i created my combo box it asked mt to name it...but it names the label! So i was referencing the label! oops.... i checked just in case as you had asked for combo box name and it doesnt seem to matter about the quotes by the way. Thanks!

Hi, i have created an unbound form which has a combo box listing our fleet customers. There are 3 buttons on the form which run 3 different reports. Each query upon which the reports are based, has the following SQL statement in it: WHERE (((tblVehicle.Customer)=[Forms]![Fleet Management...

fixed it. never mind!

Hi I use macros to navigate through menu forms, so that i can close one form as i open another. (im sure most people do this, but i know others that don't close a form when another opens) I keep getting the 2950 error message (see http://support.microsoft.com/kb/931407). However, the database...

Hi, I am using Access 2007 for a DB for our operations staff. One of them has poor eye sight and uses 640 x 480 resolution, whereas i designed the forms etc in 1680 x 1050. This of course produced some problems. I found the following form resizer...

Daft question i've sorted it. thanks again!

I have changed your code for another query pulling the costs by vehicle, and it works fine. However, how would i go about putting in a totals column at the end (to show cost of all work on a vehicle in last 12 months) Sorry to be a pain, but i appreciate the help! Here is the SQL: TRANSFORM...

Thats perfect!! Thanks very much. I've been plugging away at this one since last week. We used to copy and paste by hand, and it took hours. Now i've just got to do the same thing with costs per vehicle. Thanks a lot :)

I know this has been sorted now but, when im drawing lines on a report, i just use the rectangle tool and then size it down so it is only a single line

Hi I have an issue with group footers in a report (see: http://www.access-programmers.co.uk/forums/showthread.php?t=183047) As my footer ignores all but the last record in a group, i am using an IIF statement to get the values i want to display in the group footer (the detail will only display...

Another new idea! I realised that a vehicle can only be checked once a month, maximum. And, as we are only pulling 12 months of data, i thought i'd use an IIF statement to work out where a "checked" was displayed in order to put it in the summary. For example: =iif(count([Jan]="*", 1...

I've had a new idea with regards to this one which ALMOST works. I decided to create a report for the query, which groups by fleet, and then registration. In the detail section, the individual records for a check on a gvehicle are shown descending 1 after the other (as in the attached excel...