Search results for query: *

I am using Access 2000 and Visual Basic 6.0 and I have a database that requires the "Microsoft Works Calendar 5.0 Type Library". Could anyone tell me where to find this. I've tried looking through the MSDN website, but I have to admit that I'm rather lost. Thanks in advance for you...

I have a query (Query1) in which I would like to select the field name based upon the result of another query (Query2). In other words, lets say I have a table which contans the fields: Field1, Field2, Field3. I have a Query2 which returns a string such as "Field2". I would like to...

I am trying to create a SQL statement in my query that will get a string from another query (Here query2) and use that string to change the field name within the SQL statement. In the example below I want the query to substitute the field ChangeMe to the string from query2. SELECT...

I am having some trouble with a query returning duplicate values. This is a rather general question, but does anyone know how to remedy this problem? Is there a way to filter out the duplicate entries in a report? And if so, how do I go about doing it? Thanks for your help with such a vague...

I would like to get the year part of a date from table called tblTempDate. I would then like to add "January" to the front of the year inorder to run a query using the new date (e.g. January 2000). I've tried using the following as the query criteria, but I get a mismatched type error...

I'm having trouble with getting data from a listbox and placing it in a table. I am using an update-query to grab data from a listbox and place it in a table called tblData. The listbox gets its data from a select-query. If I set the listbox's default value to some number (e.g. =2), then the...

I'm having trouble with getting data from a listbox and placing it in a table. I am using an update-query to grab data from a listbox and place it in a table called tblData. The listbox gets its data from a select-query. If I set the listbox's default value to some number (e.g. =2), then the...

I am having some trouble with no data appearing my listboxes. The way the form works is that when the form opens, a combobox will get a value using DLookup from a table. This part works fine. The listboxes then run a query using the data from the combobox. The problem is that the listboxes...

I need to temporarily store a value that is entered by the user on a form. Another form would use that stored value then delete the value. My goal is to make sure that the second form can alway access the newest user value. Is a temporary table the best way to do this? And if so how do I go...

How do I automatically fill a combo box with the first selection in the drop down box so that the user does not have to select it? Thanks in advance! Kal-El

I am having trouble setting the default value in a textbox called txtDate on a form I call frmConfirmUpdate. I want to fill the textbox with the Date from my table called tblData which contains the Date and a unique identifier called MonthlyID. I would like to enter the MonthlyID into a textbox...