Search results

Thanks for the reply Bob. The ID field is text - i was wondering about that too. the - & " just added the & to the error statement with the same error response.

Any help is appreciated. Its basically a filtered report issue: Cant seem to find my mistake - Getting the Runtime 3075 syntax error.... in 'True AND [ID] = New Construction' See below for the code: Private Sub Preview_Click() Dim strWhere As String strWhere = "True" 'retrieve if no other'...

Thanks you All. I did lock myself from the tables too but i was able to get into it again and all is fine. Used the concise version and it worked. Co-Workers kept on touching the tables and changed the relationships and didnt know how to put it back together... hence, the lockdown. Thank you...

Can someone help me out on how to lock down the database tables? Tried the code below but its not working. What am i doing wrong? or if you have a better way, i would appreciate it very much. Private Sub LockDown() DoCmd.ShowToolbar "Ribbon", acToolbarNo DoCmd.ShowToolbar "Menu Bar"...

Thanks SOS. Got it to work using the code provided. It was calling the wrong subform - one without the filter.

I tried it out... but it seems to export all items in my subform. Am i doing something wrong?

thank you very much Craig and SOS... i will try that suggestion and will let you guys know.

First off, forgive me if this is posted in the wrong discussion thread. Just dont know where this goes. Here is my issue: I am trying to export data that has been filtered by a few search criteria. The search form that i have contains a subform at the bottom that displays the results ( and...

Drake... thank you you have helped me alot.

Used your Solution and modified it a bit: On the qry: added another field with this on Mid([LOCATION],1,2) with a filter criteria of "2AB" I was able to get what i want out. I had that code NrsStn - since its part of a drop down selection - that was a mispost.

I am so lost now... So i created this ( see included code ) and its giving me syntax error... what am i doing wrong? =Sum(IIf([LOCATION]='2AB' AND '2AC'))

Drake, thank you for your time and help. If i create another field then the other reports we have running on Data element "Location" would have to be changed to accomodate this change... Do you know of a less invasive change that will not alter the fields... kind of an if and then clause...

If anyone could lend me a hand on how to perform this: I have a report that contains 3 data elements: Location, name, unit. the location have these values in them: 2A, 2B, 2C, 3, 4, 5, 6A, 6B, 6C, 7, 8 How can i merge the results of 2A, 2B and 2C as "2"; and 6A, 6B and 6C as "6"? I did a...

it worked Thank you.:)

Hello all, I am trying to add another parameter on string that i have placed on the combo box's row source:SELECT Contacts.ID, Contacts.[First Name] & " " & List.[1Name] FROM Lists WHERE Lists.source='1' ORDER BY List.[2Name]; Currently, the combo box returns with a list that has a source...

Thanks Paul... found the issue. it has something to do with my reference table

One more thing, this has me confused. When i performed the join the Entity Value is now showing but it narrowed down my table as if there is a filter - do you happen to know why? I dont have a filter on any of my tables nor queries.

I did it using a query that i have that looks at all the fields in a table and performed the join there and created a report thats based on that query. It worked. Thanks Paul.

Yes. The Combo Box on the Form that looks at the entity table, stores the data into a different table using the ID. I will try the query joining those two... Thanks.

Thanks for the reply Paul. But I did that and on the table it works properly - showing me the data value using this code SELECT T_Entity.ID, T_Entity.Entity FROM T_Entity; For some reason, when i get to the reports to bring it up, i get the ID (key)