Search results

Is there a way to import a PST outlook file into Access 2010 or 2013. Or is there a Plug-in needed that can do it. Bob

I was using Access 2010 and just updated to 2013. My first use of a 2010 accdb file gave me this error "Could not find installable ISAM". My OP is Windows 7 Pro 64 Bob

Will this wizard show me a query of one record at a time or will I be able to enter many values and then do the query? Bob

I would like to query a table called permit which has a field called seal. Seal is a seven character field. Permit has approximately 300,000 records. My problem is I have stacks of records that may or may not be in the permit table. My goal is to run 10 to 30 records against the permit table...

My company has been compromised, to say the least, by a trusted employee of 18 years. There are emails on this Forum with the appearance that she is associated with Amerifax. She is not. The only person from Amerifax that will be using this site is Bob Snow, which is me. Since my identity has...

I was able to get it to work using 99/99;0;_ as the input mask. So basically, if I do not want to enter the "0's" then I need to enter the "/" or I can enter the "/" and not the "0's". At least that is how it seems to be working for me. Thanks for your help. Bob

I tried Access "Help". Needed to know the difference of, listed below. I'm working in 2012 Design View. Text Box - List Box - Combo Box Guess what I learned. HOW to SPELL them. Can anyone give me a brief on the difference? Bob

99/99;0;_ 99/99;0;_, 99/99;0;_. 99/99;0;2012 No luck Bob

Yes. In design view, input mask. All my data is ??/??/2012. The mask is 99/99/\20"12";;_"" This is what it defaulted to when I selected Short Date. It locks up, value not appropiate is message when I type in 0815. All years are always 2012. This is a short job. Bob

Is there a way add the "/" and 2012 in the default database, 2012. By default, I mean creating a database and then going into the field properties. Bob

>>pbaldy<< I do a mass of amount of calculations for homes being built in Wisconsin. With my limited skills in dBase, now Access, I had to come up with a way to retain the yearly totals in the database. Rather than every year change the field name two 2013, 2014 etc we came up with this...

>>recyan<< I will research the term "left join" this might be my problem. I also suspect if a value is blank I might get a undesirable response. Bob

Okay. Parentheses is something I had not considered. I will get on that right now. Here is what I'm trying to do: Actually any of "YR_" greater then 2 with "TOT_B5>5" should be a positive response. If TOT_B5 = 7 & YR_M = 3 this would be a positive condition. Or should I say part of the...

I'm trying to select several different values and it's not working. In one field "TOT_5" the value is greater than five. In several other fields, all similar, the value has to be greater than two. It must meet all these conditions. SELECT BUILDER.* FROM BUILDER WHERE (((BUILDER.TOT_B5)>5) And...

>>make-table query<< This is the term I was unable to find. I saw it posted many times but unable to find it. Bob

I have to unexpected issues with the query in 2010. 1. in my quarry table. I deleted two records and was surprised to see that the deletion occurred in my database that I was querying. As I was looking at the rolls in my quarry. I thought any deletion done would only affect this quarry. 2. Once...

>>on the Left hand side of the join,<< I'm not familiar with the term Left Hand Side. Does this have something to do with how the query processes? Bob

I will read the article you suggest. Thanks for your help. I know I have a lot to learn about Access. Just trying to get up and running along the way as I learn. Do you a know of a way to get the query to work for now, until I can understand this article fully. I feel like I am so...

OK...that does make sense. The yr fields are total for a given year. The reason we use a,b,c... etc is because it automatically updates each year. YR_A is the current YTD, YR_B is 2011 and so on. The field SC is actually a 6 character field. The field as a whole is an identifier for a town...

I am fairly new to VBA. I have a query set up, but I am not sure what I have done wrong. What I need is to pull all the records from the builder table where the SC is equal to any one of these ("14","20","28","30","40","45","51","59","64","66","67") AND any of these "yr_b" through "yr_s"...