Search results

Hi, Right i am sort of there. I have used Mod Browser, originally written by Ken Getz to get the selected file (i'll let the user do this. I just need now to get the following code to work: DoCmd.TransferDatabase acLink,"Microsoft Access", ##Here it needs to select the value from btnBrowse...

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

ah i removed out Specification Name and Code Page and it worked!!!!!!! yay! and thanks for your help anyway. :D

hi i tried, but got stuck. i used the parameters: Transfer Type: Export Delimited Specification Name: L400 Link Specification (haven't a clue what this is) Table name: Excluded_Parts_Repair File Name: J:\GS Reporting\Weekly\Parts\Extracts\Excluded_Parts_Repair.txt Has Field Names: Yes HTML...

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

Thanks for all your help. I had changed the query to Not like "Y*" and not like "Z*" and it worked, i just had to prove to an elder that it wasn't the same as doing a SQL query. :D

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

hi, thanks for your reply, i'll have a search around :)

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

Hi David, Thanks for your in-dpeth reply. Indeed the database is user for laptop / extrnal users who synchronise when possible, so i believe he is using the correct method. Interestingly tho we don't have the DM on our servers, so i'll raise this point. The only reason i was trying to get into...

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

WOW! how quick was that reply - many thanks!!!!!!!!!

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

hi, i managed to get around the problem by using a sub-report. i had the user enter the required details in the front form, which held the certain criteria for the search. The main form displays the detail and the sub form runs off a separate query, using the same data, but summing up the...

hi, thanks for the reply - i have tried this method, but for some reason it doesn;t allow it to work. it keeps asking for an entre for the "MaxofSpecial" box. i get the feeling it's not recognising it but can't suss out why? :confused:

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

hi. thanks for the reply. a colleague just gave me the answer - then looked at me like i'm a complete donut. never mind :o

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