Search results

use a Query mate! simpler.... Use the queries listing to create a new query. select the whole table (*) and click on a column you want to sort by in the table window. The click the sort dropdown in the QEB(Qery expression builder) and sore records by the column you choose. HTH Paul

I have a query which updates prospects in distribution lists. When the query runs it creates a new distibution list as a consequence of updating the prospects table because of the relationships between the tables My problem is is that I use a form to create a new distibution name, this then...

This is a strange one. I have many computers using my database accross a workgroup. Some PCs are win98, some winME, some XP. When my database wants to send emails automatically using the sendobject command all is fine apart from when the Xp machine does it. It always defaults to the...

GUYS!!! I know many people prefer to work on a specific access release - '97 , 2000 , 2002. Having designed much in access 97. I find it very easy and fast to use. However I do want to progress and move on. many in the past have said varying comments regarding each release. I'm about to...

Hi guys!!!! I have some code which loops through a ercord set and peforms an action if a certain criteria is met. Then is continues looping until the end of the records. The code is not structurally great but it works, however what I've noticed is that When I open the program and run the code...

cheers fuga, Still doesn't quite work the way I want it to. Outlook when opened in the shell method, even if i use ,vbhide or , vbminimizenofocus in the expression, remains as the focused application. How do I revert back to my database? anyone know? Cheers Paul

Hi guys My application uses outlook heavily. To the point now where my application only works effectively if outlook is open and running. I want to be able to open outlook when i start my application. I can do this using the shell command but I open a new instance of outlook each time i do...

Hi! Hope everyone is well... I run an access solution accross a network, Many reports are used in the network printing. I'm not quite sure why this happens but each report seems to choose its own printer, regardless of which default printer is selected by the user in printer settings... Is...

Cheers John that worked... I Should have known that....! Cheers Paul (I like the flag..)

Guys, I have had this little gremlin for some time now. I want to test in code if a form value has no entry, ie nothing has been put into it. (in basic terms) I've tried if text1="" then ... and if text1 is null then... and if text1 is empty then... but either the condition isn't met or I...

Thanks guys! I'm not sure what it is but it was non of the above? I had to use a backup database to reconstruct a new database.. Lost a little data but it's ok now..... Worrying! never seen this before? Cheers for your efforts paul

Hi guys, Something just happened that I don't quite understand.... When Opening my data base and I click on my tables tab, all the tables are missing, a message saying that "Record is deleted" appears and the New/Open/Design buttons are not showing..!? Does anyone know what could be the...

Ok, I have a form which is used to enter prospect information. In some cases 80% of the prospect information is the same for each prospect ie company address etc - but not always. I have a toggle called "clone" (for want of a better word). which when its clicked (-1) , all the next new...

Hi guys, Easy one... What's the quickest way to autopopulate a form with data in fields from the previously entered information... Cheers Paul

Hi guys, this should be a quite straight forward one.... I have a set of 6 count queries which count different conditions in different tables. hence some will return 2,1,20, etc as resultant counts another summary query uses the count of each orginal query so that it provides the base...

Hi Guys and Galls, A QUICKIE!! I have a report with several sub reports...If the subraport has no data access doesn't display it at all. This is ok but I want the Mesage "No report data" displayed in its place...How do i test whether the particular report has data or not so that I can...

Hi Guys, how do I get an event to occur in my database program at a predefined time during the day. Is this dependant on a form being open or not? (what I want to do is: at 17:30 each day, access automatically backs up the tables in the dbase). Another quesstion :How do you run a...

Quickie Guys I know how to use datepart to get the value of a month from a date e.g. Datepart("m",01/08/2002). (UK) gives 8 Does anyone know how you go the other way around. eg given 8 and want to express the first day of that month 01/08/2002 or give 3 as a quarter and express the first day...

Hi guys, I want to be able to find the first date of the next quarter and next half yearly point. I have a listings of subscriptions. Client's can join at any time and select the frequency need to ba able to identify the date of the next Quarter and the date of the next 6 monthly interval...

Hi Guys, I'm trying to cet a period when reports need to be printed. Each report is needed either on a monthly basis or quarterly basis. I want to set the date of a report as the month it has been completed like 072002 then get access to know that the next report is required on the 082002...