Search results for query: *

I have an treeview control on my form and I am working on coding specific actions when nodes are clicked using the .HitTest(x,y) function. The problem I am having is when I single click (right or left) on a node that has children, the treeview control automatically expands the node so the...

I am trying to set up a correct normalized table structure that involves what I supposed should be a series of one to one relationships, but as I am thinking through the outputs of the database, I am not so sure. The basic problem is as follows: I have a table of samples upon which I may or may...

My actual application is a bit more complex, but this example demonstrates what I want to accomplish. I have 5 tables: JellyBeansJellyBeanID Color CupsCupID CupName CupDetailsCupDetailsID CupID JellyBeanID NumberofBeans BowlsBowlID BowlName SurveyScore BowlDetailsBowlDetailsID BowlID CupID...

Is there a way for users to enter a time into a date/time field without needing to type the colon? Specifically, users should input time in military format but if they forget to put a zero in front of times earlier than 10:00, I would like the field to correct and accept the value...

I am trying to create a way for users to fill a number of default records in a subform at the click of a button. the form is structured with subforms 3 layers deep (form-->subform1-->subform2-->subform3). Subform3 is the one I want to have the button fill. My approach is to have a button that...

I am sure this has been addressed before, but I am struggling with how to ask the question properly. My basic problem is that I have multiple data streams that I am pulling together from independent sources where the only linkage is date and time. I would like to assign an ID from table 2 to...

The formula: =VLOOKUP(B4,$D$2:$Z$95,13,FALSE) is returning the #N/A error if I replace B4 with the value in cell B4, the function returns the expected value. I have XL version 2002(6789.6714)SP3. I have noticed that this error occurs for some users, but not others. Does anyone know how to...

I wanted to get people's perspective on the issue of when to use a one-to-one relationship between two tables and when to make a single table. For example, I am in the middle of designing a db; I have a table (tblResults) that stores experimental results on a particular material. One set of...

Hi All, I'm trying to set up a delete query that deletes all the parent records that have no child records. But I'm getting an error that says "could not delete from specified tables" Generically, my sql is: DELETE parenttable.*,childtable.foriegnkey FROM parenttable LEFT JOIN...

Hey all, I am wondering how to save a pdf retrieved from a remote source to a local hard drive using VBA. What I want to do is 1) open the file -- I think I have this figured out (theoretically) 2) save the file under a specific file name Can anyone direct me to some code (or help file) that...

Hi All, I have a rather frustrating problem... I hope someone can provide some insight. I have a complex equation that of which one part is simple multiplication: 15.8 * 5.1 This should equal 80.58 Right? But Access VBA returns the value: 80.5799984931946 While I know this will round to the...

I am stumbling my way through this, so any help will be great. I am retrieving a lot of data from a Lotus Notes database and am trying to normalize the data at the same time. So, I want to put the data into two tables and assign a primary key/foriegn key relationship. The primary key is...

Hi All, I am trying to build a dynamic array and thought I had it licked. But my code puts the built array into the first slot of the array (not too surprising). I'm trying to get around that problem any suggestions? See my code for what I'm trying to do. Thanks! Shane Public Function...

Hi all, This is my first post in this forum. I am trying to get data from a notes view into MS Access. The problem is, I created the view and only had the option to make it private. So I don't know how to find it using ODBC. Ultimately what I want to do is locate a document within LotusNotes...

I am totally clueless on how get data from a lotus notes db. I have spent days on this and am extremely frustrated. What I want to do: 1: open a lotusnotes database 2: go to desired view(note the views are in folders) 3: search view with a search string 4: return hit set 5: see if hit set has...

I was wondering if there is a good way to have a message box pop up when a search generates no hits. I have a form with unbound controls that are used to populate the where clause of the recordsource of the data display form. a portion of that code is below. Any Ideas? Thanks, Shane Dim sqlF...

Hi All, Our company primarily uses Lotus Notes as storage for our data. I am building a MS Access database that brings portions of data from several of these depositories and evaluates the data. I want the user to be able to quickly access the raw data (located in Lotus Notes) if he/she...

Hi all, I feel like this is a dumb question that has probably been answered before, but I am having no luck with the site search. I am trying to create a code that will generate email. I have read the FAQ concerning this so I think I have that ok. My problem is getting the correct main...

Hi all, I am gettin the following error: "The Microsoft Jet database engine does not recognize '[forms]![chartoptions]![combo7]' as a valid field name or expression" I have a chart that is based on a query. I want to give the user the option to limit the data set of the query based...

Hi all, Method 'Requery' of object '_subform' failed I'm getting the above error message when I click the record navigation button to go to the first record on a form. My form has 4 subforms. The first subform (ResinData) dictates the data viewed in the other three. I have a requery set to...