Search results for query: *

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

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

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

Throughout my work I have continuously used Sendkeys to run code that I use a lot. I'm aware that this a poor way to design my database product but I don't know how to run the same segments of code without using Sendkeys to run command buttons. Can someone explain how I might run segments of...

help! i changed the startup options so that I could hide the access menus. Then I compacted and repaired the file and now I cannot edit the access database. I still need to fix it! What do I do now? I need to be able to design! heeelp

Ok I'm trying to get my head into gear for the final phase of my small project. I split the database into forms and tables. Have put the table file on the sever and given everyone their local copies of the forms. I tested it the other and I was pretty happy except for two things. 1) when...

I have a child form that creates the details for my Conferences. Which another form has two fields that are linked by dropdown boxes to two of the fields that are created from this child form. conference info Master table name of conference name of person name of place address...

Ok tearing my hair out completey.. Have a conference table and a conference info table i have two fields from the 'INFO' table linked to the original two fields in the 'Conference' table one is a date field and the another is text field I have created a query of the 'Conference' table...

I created a field that linked to another table (to save the user from having to type in the information everytime they could just select the correct data that appeared in the drop down box) Problem was that where there blanks in the orginal they appeared in the drop down box...for example this...

I have an text box that records the position of the record in the database. Whenever I do a find it does not update this box. The reason for this is that my 'find previous' and 'find next' buttons increment and take away 1 from the number in the box. So when the find result jumps around the...

I have been able to get my code to run after each find search from the find records box but now I can't get it to stop running even when i'm not searching. I've tried a few IF statements to curtail it's use but if you have any suggestions that would be neat. The main problem I'm having now is...

My problem is that when using the find records box i have images that change according to the data. The problem is that using find records box I need to put my code behind the 'find next' button so that the images will refresh. I can't do this, So I tried earnestly to create my own search...

i have about 100 fields in a report which shows all the client's information. Except not all records have all this information. I really don't want to code the the query line by line to filter out those that have no data for the fields in the report.. I really hope there is a quicker solution...

I want my users to select the line they want to delete or for my code to do that for them. Except, what throws the users out is the *new line* for input that if you select and try to delete you cannot. I don't it won't it to be shown unless I want it there, I include a picture of the new line in...

I've searched for all kinds of code that would kill winword.exe if it happens to running in the background. However they seem grossly complicated and I can't get them to work properly . I was looking at the idea of identifying via a process search but I'm exasperated as I'm sure there must be a...

This is confusing and I see no reason for this. But when I go to create a report of a query that has 31 records the first record is the only one that appears in the report. When I run the query it works as expected, but when I go to create the report it doesn't present all the records except...

I have a problem with my between statement. I have two textboxes with values in and I want to be shown the records that match between the values. Simple? well yes it should be. The problem is that the statement only compares the first number and not the others. so between the values of 1...