Search results

Hello. I'm trying to use the value in a text box on a form as the table name in a query. Example Form Name: Frm_Module1 TextBox Name: text500 I want to use the value in text500 as the tablename in this query: SELECT [tablename].Field1, [tablename].Field2, [tablename].Field3 FROM...

that simple eh? just a "= false". lol thanks buddy, much appreciated!

Sorry to open such an old thread but I am having a similar problem. CurrentProject.AllForms("frmVestigingenForm").IsLo aded <----solved 1 of my problems, so I THANK YOU!!! Now, is there an opposite to this? for "Is not loaded" ? I have it in a macro condition 1 for if it is already open and...

I more or less had to do what you are asking....... I converted the query to a make table query.....the resulting table I used to query against and update other tables, etc.... Convert your query to a MAKE TABLE query.....then you can further query against that data (table it...

It does and I really do appreciate you taking the time to help me through this. Thanks again John.

It doesnt prompt me for an ItemID. If I attempt to run the query just as you provided, it does not return data, it returns the message "only 1 record can be returned at a time with this subquery". So, in order to return data, I manually hardcoded into the query a criteria for a particular...

That's the direction I was headed. Excellent. Thank you again, Much appreciated!

There we go! MUCH APPRECIATED. Let me ask you, it gives me a message "only 1 record can be returned at a time with this subquery"------so I gave a criteria for a particular ItemID and it returned the info I wanted (which is GREAT). But is there anyway that I can return info for all items. So I...

OK I see what you mean. However, I am still getting that error "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect." and then it highlights FROM Looked through and everything seems to be in oreder.....

Ahhhhh, I see the light; however, I am running into errors. 1) Do I need to create the tPC and tPCMain tables as mirrors of the Tbl_PriceCheck table? 2) When I ran the query (even after going ahead and creating the 2 tables I asked about in ques # 1) I get an error "The SELECT statement...

I came across this on a google search. I guess it's not possible what I'm trying to do. But I wanted to thank you anyways for your help! Its much appreciated! "As you proceed, remember that by default, a totals query can include only the field or fields that contain your group data, such as a...

I had done what you mentioned in the past; however the query results gave me multiple records for the same ItemID...when my goal is to pull the lowest price for each ItemID. The table: Tbl_PriceCheck contains columns: ID, ItemID, VendorID, Price In Tbl_PriceCheck, the same ItemID can exist...

Having a similar problem, however I am looking to pull additional data of the record, but NOT in a report, just in the query itself......(so i can update with the additional data to another table)...... My query is as follows: SELECT Tbl_PriceCheck.ItemID, Min(Tbl_PriceCheck.Cost) AS...

Interesting. I did not think about that. Let me give that a shot. Thanks for the response.

Kind of stumped on this. Searching "append for each" just kind of throws me into standard quering articles. Any help would be greatly appreciated. Table 1_Customer: ID, First, Last (2 records) Table 2_Transaction: ID, CustomerID, Date, Amount What I'm trying to do is create an append query...

Yeah, that's what I started doing because I became discouraged. It's just that the expanded related tables is such a cool interface (in my opinion anyways). Hey, thanks for the response!

Is this possible to have available in a Form???? To show in a Form tables with the related tables below to be able to insert records in this view? I have been searching high and low and maybe im not searching proper terminology? Is this even possible in access?

First, I'm so sorry for my lack of terminology in what i'm trying to ask here. You know how when you make relations amongst tables and then when you open the table you can "expand" the + to see the underlying related entries in the other tables and make additions, deletions, edits from right...

I am having the same dilemma as the original topic for this post. My company has 2 stores which use identical copies of database. Terminal service is not an option because if the internet goes down, the satellite store will not be able to function, as this is 'point of sale' software. Nor is...

You can turn off the Security warning by turning down the macro security. >>>>>>>>> Tools>Macro>Security ---> and turn it to low