Search results

Many thanks for this steve

Is there any way I can remove people from the database, I wish to do some upgrade and find that people are not at their desks or have gone to lunch etc which wont give me full access to the system. I know they are when I check the ldb file I can see whos in but cannot access their office etc...

Thanks very much I will have a go with this. Steve

I have a macro which sends a report via email, I have built into the macro a number of email address, and this works well, but I would like to take the email address from a table so the macro need not be edited when someone is added or removed from the list, is there an easy way to "pick up" the...

Thanks Pat that at least clears up why I cant make it work !

I would like to print query results in the same print format each time. I can set the page to landscape and margins etc and then print the query results with no problem, but after the DB is closed and re-opened the page setup defaults back to portrait etc. Is there some way I can force the...

Thanks for that Rich, I can now get the correct value from the table into my new text box, the only problem I now have is how to pass the value into a field on my form which performs the calculations etc. this field is part of the main table which also stores the exch rate in the record for the...

Thank Rich for your speedy reply, my problem is that I not sure just how to apply Dlookup where to use it etc. Steve

I need to create default setting in my mde database such as Exchange rate and Vat rate etc. at present I have fields on my form which default to my settings, but when things change it means creating a new mde each time. I have created a settings table with a single record, with each setting...

I have a simple select pramater query which requests first/ a text input using the Like [Inv No] & "*" Second the Between [From] And [To] which are date critria and third another Like [Enter the first character(s) of Customer] & "*" to select an account this report gives a selected history of...

Delete Query Sorry to bother you all but I found it append!

I wish to only delete the duplicated records within a table, I can find them using a find dupliciate query but can someone advise me how to automaticaly delete only the duplicated entries, leaving just one unique one in the table?? regards Steve

Thanks Sue, I,ve tried that and I can see how the first bit works and if I make the field visible I can see the counting in action. I cant however get the total to give me any results, I have tried the field in all sections but stilll results in #error, any suggestions? regards Steve

My report list a number of consignments brought into 4 to 5 locations by a number of carriers. the report groups first in date then destaination then carrier. I can total by the no. of consignments per day but I want to be able to introduce the no of consignments by carrier each day. Steve

Thanks for that but unfortunally is does not work, there are levels of grouping in my report as you said and they may be stopping it working, but these grouping are also needed. any other suggstions? please Steve

Could anyone please help with the correct count syntex for the following. In my report I need to count the number of times a certain text appears in a field, I have the =count([carrier]) which works fine fot the total but I need to count the number of times each carrier is used. something like...

Thanks but I dont think I'm explaining myself correctly: I have several thousand orders per week which are directed between 9 channels of business. I need to show a graph week by week and month by month, showing the no. of orders to each channel. I can run a query which will output to a report...

Thanks for that, but I have created the basic reports which sub-totals on specific points ie dates, channel id, and then totals on them. What I need is to be able to export the sub totals and totals only into another table / report? from my report. at least I think thats what I want? Steve

Could anyone advise me the best route or where to look for samples / advise to producing a query/report. That will produce totals for a specific period ie Weekly / Monthly etc and that those totals can be transfered into another table (without the underling data) so various graphs can be pulled...

Thanks Pat that seems to explain my problem. Steve