Search results for query: *

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

I chickened out of the module idea, although I think one day I will have to sit down and learn it. I used ramou's idea which is my middle way solution and it worked well. I eliminated tons of sendkeys operations.

I'm going to try Hap's007 2nd idea. Sounds easy enough and sounds like it will work..will report on it's success or not thanks

Help I have to install my database on many machines soon and for each machine I have to go to VB and go to references and choose Microsoft word 10.0. In order to get a calendar function to work. I have Microsoft word 11.0 on my machine, http://www.megaupload.com/?d=K3OW8S2P is there a way...

Ok i've been googling the public variable option and I'm outta my depth as to putting one in a module and calling upon it when i Need it. Now I'm sure that's the best solution as I can feel my old teacher whacking me over the head with a cane saying something about public declarations and...

In the past I've found that an error in one of the forms has prevented 'compact and repair' from working properly. Now what exactly what I mean by error I can't say..memory loss. try exporting the forms out of it and then compact. then reimport the forms. You could try a bit of trial and error...