Search results

Hi, I'm having trouble understandign the issue with my error handling not working. What i need is the following: Run code queries 1-10 If there's an error in query 2 to 3, then ignore and go onto query 4 and run to the end If all is ok - run everything Finish sounds simple but i'll be...

Hi, I've been looking around for a while, but can't find a solution to what i need. Due to IT restritions I have 3 databases, on of which holds order data, one holds sales data and the other to hold the summary tables and reporting suite. I'm looking for a bit of code, where i can click a...

Well this was a simple one and i thought i'd share it if it's not too obvious. To display an ampersand (&) ina form etc, you have to write two next to each other. So, "Check & Confirm" becomes "Check && Confirm" Hopefully at least 1 person might find this useful sometime in the future.

Hello, I have spent most of today trying to find the answer, attempting different method and searching for all i'm worth but nothing so far has worked. I have a query called Qry_Output - which has 2 columns - Reference_Name and Value which i would like to be able to click a button and it...

Hello, I have created a database which multiple users are logged into and it works fine. Apart from 1 user. Because of the way the system works, it requires a filed to be populate with a date. This is automatically done using the =DATE() function. This user has the message ?name in the box...

Hello, I am using the below VB code to try and send a load of values from one form to another, but only if they are not nul. I run the code and it states " Compile Error: Else without IF and highlights the first occurance of the Else statement. Any help would be much appreciated :)...

Hello, Hopefully this is a really simple request - All i need is a bit of code to runt aht opens a specific folder on the network, after running off a few items first. I have put in the code to run the queries / macros i need but after this i want it to open the folder and display the...

Hello, Is there a way of using the TransferDatabase - Link function in a macro to link a table from another database place on the server, but offering the user the option to find and select the other database? The reason behind this is I have one database which does a load of work for the...

Hello, Is it possible to export a query to a text file within the server. I have a query called Excluded Parts_Repair and i need it to automatically export the results to a text file on the server called: J:\Reporting\Weekly\Parts\BI Data Extracts\ as the file name...

Hi, In Access 2002, does the Not In feature work? (or how does it as i may have made an error) I'm using Not in ("YQ", "YW", "YZ", "ZY", "ZX", "ZA") Or could i use Not in ("Y*", "Z*") Thanks Rob

Hello, Is there an easy way (which i might not have noticed) to get Access to create a folder on a server (the address on the server will be the same each time) but to have it rename the folder to something relevant and drop a report / table i need in it, with the name as specified. for...

Variance Calculation Hello, I have a bit of a difficult one for you (or maybe not). I have been asked to produce a query for around 200 records which calculates a variance as a % of plan vs actual I understand the standard calculation for this is: (Actual-Plan)/Actual but unfotunately it seems...

Hello, We have a database which has been created by an external developer. We are now in the process of putting in a few additions, but i go to the master database and the tables show a little logo with a red and green circular arrows and the property shows "Table (Replicated)". This means i'm...

Hello, I think this is the right area to submit this question. What i am looking to do is have a form load up - showing the date and some other detail. I need a button to be visable if the date is past the 23rd of the month, but hidden if not. Is there a bit of VB i can use to make this...

Hello, I have a slight problem with chart formatting. I have a report containing a line graph with 6 lines of data. It works fine and runs perfectly. The problem i have is that i cannot alter all the line colours. If i run the chart it shows all the lines as required, but wheni go to design...

Hello, I am running a report which has the following: Report & Page header: contents - fixed UPC header: contents depending on parent company Retailer Header: Retailer name & reference number, dependant on UPC Detail: containing measures by month, a total, plus an extra field showing submissions...

Hello, I think i've got friday dimness, but can you help / slap my brain into gear with this AVG function? I'm trying to average certain values (in a query) but can;t remember how to ge tit working. What i need is an average of coulmns 10 11 and 12 I put in =AVG([10],[11],[12]) but no luck...

Hello, Not sure if this has been covered or not, but i've been trying to get a form, with some buttons on it. What i want is to have the button show a graphic, but when the mouse is over the graphic, it change to a different one and also become active so that it can runa command when clicked...

Hello All, I thought when i gave up on this it was just a Friday afternoon moment, but it seems to have lasted into today :confused:. I have a table with 242 rows (relating to retailer numbers) and 64 columns (relating to retailer answers to the questions. What i need is to be able to show...

Hello all, I have a bit of a problem with my CT query. The normal query seeks it's reference from the code "[Forms]![Frm_main]![referencetextbox]" referencetextbox is a textbox on the main form of the screen and i want the CT query to look at this to then show detail. The normal query works...