Search results

I have a form that has a combo box that contains every query in my database. This worked fine until i started having to create cascading queries to return the data I want. How can i populate my combo box with only certain queries in my database. This is the code I was using to put all...

I just do that for "Date" i did that, and all three records still show up??? What could I possibly be doing wrong? Thanks again

I have the user enter Manufacturer ID and SN, so in this case, if they entered "A" for manufacturer ID and "1" for SN, three results would be displayed. I only want ONE record to be displayed, that being the latest record based on the Status Date Thanks

Thanks Bob, I apologize for what are probably simple problems.......but your help is greatly appreciated. while you still may be there.....i asked another question in another section but i still havent figured it out....how can I limit the results of a parameter query to only show the latest...

This is my row source. I am not sure if it is a table or a query. I was told to enter this into my row source from a fellow forum member based on the question as how to populate my combo box with all the queries in my database SELECT MSysObjects.Name FROM MSysObjects WHERE...

Below is an example of my table "Current Status" Manufacturer ID___SN________Current Location__Status Date______Time A________________1____________Area 1________1/6/2008_______3:15 A________________1____________Area 2________1/7/2008_______2:10 PM A________________1____________Area...

I have a form titled "Run Queries" and on this form I have a combo box "Combobox12" that is populated by all the queries in my database. As of right now, its hard to find the query I want becuase its all in random order. How can I sort these queries in a combobox from A to Z. Thank you in...

Oh man finally got it, i entered in the one line in the actual code itself instead of tryin to insert it into the properties box......thank you so much for your help, i cant tahnk you enough

Private Sub CommandButton2_Click() DoCmd.OpenQuery Me.Combo12, acViewNormal, acReadOnly End Sub I am using a combo box, whose name is Combo12 when i put that in the event line on click, or after update, i get the error message : you may have entered an operator without an operand.

Still no luck, I keep getting NO Do.cmd macro, or invalid syntax.....

Thanks for the help. I have never written code before in vba/sql. I am a college student doing an engineering internship for a company and over winter break one of my projects is to create a database (???!) for them. I like the challenge and when I have free time I'm def going to try and...

Filling the listbox worked excellent, but I am having trouble in doing the openquery after update thing. If my listbox name is List8, what is the exact code I should copy and paste into the expression after update event line. I apologize for my stupidity.

I want to have users be able to choose query "x" "y" or "z" from a listbox. Upon selection of query "x" "y" or "z" from the listbox, I want the query to run? I want to run this query from form "RunQueries" Does anyone know how I can do this? Thank you in advance for any suggestions, I...

The boss believes I can help him with access, im not too sure, i dont really even know access. There is a table with fields for each month of the year for 3 years Jan 06 Feb 06 .......Dec 06....Dec 07....Dece08 Can i have a query that prompts the user to enter the month, and then...

Linked Table Manager......i knew i was missing somethign stupid. thanks so much

Hello. I created two databases on my personal computer at work. One is called "Main" the other is called "Link". As you might have guessed, I linked the tables from "Link" to "Main" and imported the forms that were in Link into Main. On the opening page of Main, users click either a button...

building the expression referencing the table, not the forms still gives me the #Name? =10*Log([Sensing Coil 2-14]![maxPIN]/[Sensing Coil 2-14]![maxPOUT])

also, im going to try it now, but the values in form 1 are saved in a table.....let me try that as well... but im really interested in the multiple tabs idea....because i have so many forms that seem slike it would clean up the database as well

neileg, I am a newbie, I think what you've just suggested would be perfect for what I have to do, at least it sounds like it. How do I create one form wtih tabs?

No, form 1 is not still open, users enter information about a product page by page as they build the product...... is there any other way to get around this......can i use a query to calculate log([Text61]/[Text47]) and then use DLookUp or something like that, i've been searchin this forum...