Search results

I will check that out. And sorry, I am using Access 2007.

Not sure what the name is but I would like to know. At least there seems to be hope for me. Bob

Back in dBase IV it was possable to develop a fprom or complete program that could run without the over head of the developing program. Example: If you had a form that looked like a flag that was within Access If exported All you would see is the flag, no Access because it would be a runtime...

Good question what is my purpose. Over the past 15 years, as far back as DOS dBase, I have been developing a program to process building permits. I have now decided to switch to access. You Bob have helped with one of my first items. I would like to know the best way to approach what I'm...

I have three rows ,fst,lst,name. Using Access7 how do I get the value of row "name" to containe "fst "last"? I would like to run the entire table at once. Bob

Thanks once again for your help. I am figuring out my way around in the form design. I do have another question I am hoping you can help with...When I create a Form, where exactly is it getting saved? Can I take the form I create and attach it or use it with different tables that all have...

Something known to me. I'm in the "form design tools". I have a column of 20 fields or tables that are similar like Name, city, address. I want to indent the address rows. I thought I would be able to just drag the left side in a little bit. I must be missingf some thing. Bob

OK will give that a try. Does the fact that the file has 92 fields already have anything to do with why it won't work? Just a thought? Bob

I have a table with 260,000 records. I need to change a field type from character to date. When I try to change a field type from text to date I get the following error: Microsoft Office Access can't change the data type. There isn't enough disk space or memory. What causes this error and what...

OK , I have one more thing...again I can't thank you enough for your help. That really does give us the basis more most of what we will do in Access. How would I add a command to the query using the per_date field for... 1. per_date month equal to November or 11 2. per_date month equal to...

I figured it out, I found the Linked Table Manager. I am going to look at everything and I'll let you know if I have any questions. Regardless we thank you so much. This takes us one step closer in our change over to Access. That substr command in dbase is something we use daily so...

When we try to open the Permit table we are getting an error that it is looking for L:\temp\permit\permit.accdb We don't have an L: so that must be yours. I'm thinking we need to find this "Linked Table Manager" do you know how else I can do this. I opened Permit first, then I held down the...

OK Thanks for letting me know..I really didn't know how else to possibly do it! Bob

I am not sure what I am doing wrong. This is the procedure I am using and maybe you can tell me where I am going wrong. I start with a blank Access Database (builder.accdb). When it open is believe it has a table called Table1. I close that table. I click on External Data, More, dBase. When I...

It took me the week end to figure the export but I think I have it. Bob

I could not see how to link to files at the same time. Thanks again Bob

The data, 500 records each, I'm sending is live. Permit is actually 350,000 and Builder is 20,000 records. There are both converted to Access from dBase IV. Hang on to the data, I might have a couple more questions. Thanks for the help. Bob

Bob, I have tried that also and am just not having any luck. I am sure it is something simple I am missing but I just can't get any of these to display any data in my table...this is so frustrating! Bob

I attached a picture of what my window looks like...when I try to switch back to "Datasheet View" I get a pop-up window that says: "Enter Parameter Value" PERMIT!Left("sc",2) "Blank text box" OK and Cancel Buttons What is it looking for? I tried entering In(40,45,66,67), In(40), 40, nothing...

OK I did give this a try. When I put Mid(sc,1,2) it creates "Field1". When I try putting in the criteria such as 40 or 67 or 51 I am not getting any results at all. I even tried it like this: Mid(sc,1,2)=40 I again get no results. In the criteria how am I supposed to be listing it, am I...