Search results for query: *

I am using Visual dBase 5.7, I know...its pretty old. It still works great for so many things that I use it for. I was hoping to get some help with 2 things. One, is it possible to create a form in Visual dBase and run the form window independent from the Visual dBase window, is there a...

I just went back from scratch and was able to solve the problem... Bob

I am using Access 2007. I had a form that was all setup using a subForm. I need to make a change to my original setup. I removed the subForm and I need to change my form to a split form. Well I did change my form to a splitForm and now I am not seeing any of my data. In the PropertySheet...

Sorry I'm back again...everyone here has given me such an education in 2 short weeks, but I have another one, this time for the "Form" We have used the Split Form before but I have a condition a bit different and I don't know if this is possible. I have a table "qry2010MasterTableWithSC" and a...

>>MajP<< Answered it for myself. Thanks again for yet more help with this!! I was trying to find a way to send you a PM but this forum doesn't seem to have that ability... Bob

>>MajP<< When I am running this against what I already have I assume it will not disturb any values that do not contain the word Subdivision, am I correct? I can run it just like any of the other queries you helped me to setup? And in this case the query goes out and uses the Module that was...

TheAceman and dhookom: I am sorry if I upset you that was not my intention. The reason for the switch is because regardless of what I am doing, I do need it both ways. I probably should have put it into two different posts and I apologize for that. The route it ended up going seemed to be the...

Andy, Its funny that you say that. We have about 6 different tables that we will be running these things against and we are trying to find the best way to do it. In this table the data is actually clean where all the values look the way I used in my example. This table is from 2010. As the...

>>MajP<< You have done so much to help us with this. It is just another way we were trying to get through and clean up this data. What I did, and tell me if I am correct, I added the first code into a module. I used the second code and created a query. When I run the query does that look to...

>>dhookom<< I am not sure what I am doing wrong, but no matter what I try I am not getting any results. And it is probably something I am doing wrong. I tried to run the code and I get nothing. I am very new to Access and most of this is still over my head. I am trying to understand...

Wow..OK I will give that a try. You make it look so easy. I'm sure I will get it. Thanks for explaining some of it a little more I really appreciate it. I am still fairly new to Access but with a lot of help from people such as yourself I am understanding more and more each day. Thanks...

>>lameid<< I will check out those functions. Now that you say that I think I do remember something similar that I had worked on. I will do a little more checking on those functions. Thanks for pointing me in the right direction! Heather

>>Andrzejek<< I am still pretty new at this so if you can explain this Split Function to me a little more.... I understand what it is doing I am just trying to determine how to work it into my data properly. Do I put this in a VBA Module or in a query? And how do I put my results into the...

Aceman1, Thank you for help us with the code. I basically would like to know how to run with code and place it into the subdivision field. The data in question is a field called propertydescription_1 and place it into the subdivision field. Bob

Duane, Attached is a file for you to use with the proper field names. The field the value is coming from is called "PropertyDescription_1". The results are going into a field called "SubDivision". I'm not sure if I explained myself the right way. I just want to make sure I did. I want to...

I am looking for a phrase based on if a field (NAME) has 4 characters or more. If the field starts with 4 characters or more. I want to take everything up to the first space or the end of the field, whichever comes first, and put that into another field called (SECNAME). Heather

I would like to make a query that can handle the following: I have a field called TVCName. In that field field there are many values that all have the same format: MILWAUKEE, CITY OF GERMANTOWN, VILLAGE OF WINTER, TOWN OF And so on... This is what I need to do. If the field Contains the text...