Search results for query: *

I just figured it out. I copied the dll files from my computer to the client's computer. Thanks. Sincerely, Kal-El

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...

KellyK, Hey thanks for the reply. Don't worry about sounding condensending, you're not, besides so much of programming finding out where we made that silly little mistake that caused the whole thing to crash. I figured out a solution to my problem. I ditched the listbox and I created a...

Dear EarS, I was hoping to automatically select the value in the list box. I guess what I'm having trouble with is automatically selecting the first value in the listbox (NOTE: the query that gives the listbox its data only contains one record (e.g. the only choice in the list box is 2.29)). I...

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...

Thanks for the help. You advise really helped. Sincerely, Kal-El

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...

Thank you Gentlemen. Your advise really helped. Sincerely, Kal-El

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

Paron, Thanks for you help. It worked wonderfully! Sincerely, 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...