Recent content by chaft

oh YEEEEAAAHHHH!! now we're kicking...[bigglasses] lifetimes of manually indenting, now all history. Hugh you are quite right it's a good habit to pick up. A Habit I've yet to pick up.

My friend showed me this cool formatting tool in his java editor where after a click of his mouse all the code formatted itself. So all the loops were correctly indented automatically. I've been doing it manually for years in vb. Is there a way to autoformat my code? It just takes so long...

gah...it doesn't show which form controls rely on which query. It only shows Reports and Form query dependencies and not their individual controls

[pipe] no wait! I think I get it now... the recordsource for the reports and forms should identify the queries I'm using and as I'm not knowledgable enough to use VB driven SQL I shouldn't lose any queries. I'm going to give it a try at least. Let you know if I succeed.

[sadeyes] Gulp! I did some SQL at uni and so some of the instructions look familar. However I've not really done anything like this where I'm mixing my vb skills with it. If I get my next job I'll probably learn and do some Sql. The advantage with Access was that I didn't need to any SQL...

Now I'm inundated with Information... What exactly should I be looking for to help me reduce my queries? I'm no expert and I don't want to delete any by mistake. If any of you could suggest a strategy I'd Appreciate it.

thanks it worked with your help. Can't say it was easy.. Microsoft IF statements are REAL pain as I can't seem to copy them into notepad and everytime I have to keep toggling. I wish microsoft would make it easier for nested loops.

works much better than i expected.

You were all quite right. I played around and got it to work and naturally came to the same-ish conclusion as Joe At Work came to. You are quite right Gloom too. (thanks all) I haven't used an OR clause in so long that I forgot how to do them properly. Question is now...(not essential but...

I tried changing all the AND's to OR but that didn't seem to do anything..

ok... it's quite large SELECT zearchall.ContactDetailID AS Contactid, Trim([Title] & "") AS Titles, Trim([FirstName] & "") AS [First Name], Trim([Surname] & "") AS Surnames, Trim([gender] & "") AS Genders, Trim([Dateofbirth] & "") AS [Date Of Birth], Trim([Nationality] & "") AS Nationalitys...

I have a query set up that looks to find contacts using criteria. using queries much like Like [forms]![searchall]![Surname] & "*" This allows me to search and find people that are in many categories. However that doesn't suit my real purpose. I want to be able to select the categories and...

I want to be able to set the configuration for the "Find and Replace Boxes." So instead of "whole field", I want to search for "any part of the field" etc I had been using Sendkeys to do this but it doesn't seem to have the same effect on all machines. Some versions of Office act differently...

I'm Having a difficulty mastering the IF statements in icrosoft word. I have two if statements that I want united I only want one IF statement to present it's answer. In the case of both having the required data to run then I want the second IF statement to have priority. I have two IF...

Hi I made loads of queries through out my project to try stuff out and a lot of the time they didn't work. I now have loads of queries, but I can't work out which are being used by a report or form and which were from my trials. Any ideas of how I get rid of them without deleting something...