Search results

How are you using this data? .. In a Report? ... Side note ... spaces are not really good characters to use in field names, also, "Date" is a reserved word is not such a good choice for a field name. Consider the "_" in place of a space, and when you have a data value you wish to record, use...

Okay .... so .... what is your table structure for the two tables involved? you can list them out textually. Indicate datatypes and Relationships.

The query seems to be over complicating the mechanism for acheiving the final result desired. It seems that the goal is to find all the records in tbl1 that meet the following criteria: [Prop ID] does not have an "o" at the end {INNER JOIN between [PROP ID] and [PropIDbx14]} And [Inspection...

>> I would not put a ... .... images anywhere a near database << I generally do not have issues with using images on the Front End to enhance the user experience (ie: Form Backgrounds, Button Images, Company Logo's, etc.) ... But with the .MDB format I definately agree to the thoughts...

Okay ... here's how the dbl-qoute, single quote thing works ... If you want to use dbl-quotes in a literal string that is delimited by dbl-quotes, you can double them up ... strString = """Hello""" Will yeild "Hello" (including the dbl-quotes) into the variable strString Likewise you can...

>> George did attend the 2008 Summit and based on what he's told me, there are changes<< Awesome!!! ... I hope they are worth that anticipation! >> It is too painful << I understand!

>> I think you might be surprised << Maybe (and I hope I am). But ... (to paraphrase a friend! .. ROFL) ... I didn't see you at the 2008 Summit, so you missed the stuff I would be talking about ... so the depths of the vision discussed in '08 may have gone farther than you think ... ROFL! ...

>> And I didn't see you (Leigh) at the Access Dev Kitchen and you weren't at the Summit, so you missed the stuff I would be talking about. << Despite that, what version do you think we talked about at the 2008 summit? (Which Leigh attended) ... it wasn't A2007! ... granted the topics may have...

>> Dim rs2 As Recordset << rs2 is probably being typed as an ADO recordset (Check your references and if ADO is above DAO, the ADO will get the priority) ... So ... explicitly declare your object variable like this: Dim rs2 As DAO.Recordset Then you are telling Access exactly which...

>> consider using decimal << The DECIMAL datatype has its own issues and is (IMHO) difficult to work with in VBA, since there the Decimal datatype needs to be stored in the Variant datatype. I personally would consider using the Currency datatype (not to be confused with the Currency Format of...

You're welcome! ... Always glad to help out!

In theory, the only limit is the 2Gig limit that Access has. But, to me that would be too big simply because it is cumbersome to distribute and performance would probably be pretty slow with a FE that grew to that size. But as to say 10meg is too large, or 50meg is too large is too black &...

One small clarification ... when Banana used the term "Relationship" ... it really should be "Relationship With Referential Integrity". A "Relationship" by it self, pretty much just tells Access how to "AutoJOIN" two tables when they are brought into the Query Designer ... Many times a...

My thoughts/clarification ... >> 1. When you "open" an Access file, Access creates a connection to the data through JET. << Expanding and Clarifying: JET has 255 "connections" to hand out. So if you connect to the data via an ADO connection in Outlook, JET gives one connection spot to the...

>> People who do not follow the laws of their religion should not claim to be followers, it's they who give the rest a bad name. I'm pretty sure Jesus didn't like hypocrits very much... << 'Laws of their religion' --- well Christianity is based on a relationship with Jesus, and as a...

>> I'm not sure how to phrase this, but does that limit assume that the connections are remote << One thing to realize ... Access is a user interface to a JET database file ... so "Access" is really NOT a database .. its a database manipulation application, and the database Engine defaults to...

You are definately headed the wrong direction with what you are doing ... the RuralGuy has the right idea with a subform with a Source Object form in datasheet view mode (or a ListBox). If you customer wishes, you could easily create a report to view "all" the information. As another...

>> Yup that works << Cool! ... extremely glad to here it! >> how much i have to learn still.. << We all have a lot to learn! ... we just need to be open to learn it! ... I certainly do not know vb.net! (yet) ... :) .. ... Good luck with your project!

A simply point of clarification ... >> I don't have to split the database because I am using Access as the back end only. << Your back end is a JET database, NOT an Access one. Access uses a JET database as its default file format and storage facility, but ... you can have a JET (.MDB)...

Also, make you you set the CanShrink/CanGrow properties of the text box contols to Yes. Also do that for the section of the Report that contains those controls. But, one thing to note, a Label control does not have CanGrow/CanShrink properties, but when a label goes hidden, most of the time...