Search results

Guess what...i think you might have just solved my problem with that last question....The Row Source is a query that is selecting from the FIRM ID Table.... uggh....sorry....but thank you...I'm gonna have to change all my firm id's to autonumbers.......thanks !!!!!!!!!!!

Private Sub Firm_Description_NotInList(NewData As String, Response As Integer) On Error GoTo Firm_Description_NotInList_Err Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("The firm " & Chr(34) & NewData & _ Chr(34) & " is not currently in the database." & vbCrLf & _ "Would you...

Yep..the Firm_ID field is the primary key and is essentially just a three letter identifier i input to link up with another table. I'm guessing that i should have just used an autonumber for this??? But when i make a dummy table with just an autonumber (as primary key) and firm description, it...

RG, the row source for the ComboBox is a query from the FIRM ID Table which only selects the actual Firm Description.

yeah pb..my table FIRM ID contains.....the following An Auto Number FIRM_ID (which is a three letter code i created, but now looking back probably shouldn't have) Firm Description --which is the value i'm trying to insert Firm Address Firm State Firm City But the last three are blank for...

Just following up on this....KG or anyone ...is it possible to have the three tables that are not static...Strategy, Funds and Firm ID on the Back End and have the other tables on the front end...Would it make a difference???

KG...actually i lied...the Strategy and Funds tables are the two main tables which are displaying the data on each of the respective forms and which will be housing all of the data input by any user from the form...so these need to be housed on the back end as well... I tried what you...

KG...most of the dropdowns are static...except for FIRM ID, which i'm working on trying to change that field to allow for updates, so that will change RG...i tried that, and it seems to speed things up a tad, but still dragging quite a bit

actually here's backend..wouldn't fit on last file....

Okay here's my database okay i'm attaching my database (fe+be_....if you look the forms are frmSearchStrategies and frm SearchFunds...there are a lot of drop downs on my forms, but i think most are based on queries....if someone has a chance to take a quick look...i'd appreciate it...thanks...

Uhhh..yeah maybe some more clarification here?????

RG ...thanks...it sort of worked, but not really, after typing in a name, the prompt comes up to ask if you want to add the new firm, and after choosing yes it says that it has been added to the database....but, then a prompt comes up that says, "The text you entered isn't an item in the list"...

I have a combo box on a form i'm trying to use the not in list event.... I'm getting an error when trying to imput a value in the combo box.. My errror says error with Inster Into Syntax... Here's my code Private Sub Firm_Description_NotInList(NewData As String, Response As Integer) On Error...

So, I split up my database and housed the tables database part of the split on a shared network drive and am experimenting with the front end of the database which i've housed on my local computer. I've tried most of the recommendations: shortened the name of the db, changed fe to mde file...

Paul, one last question on this. In trying to build the report, the query is stretching across two pages. Can you tell me how to continue the data on the one page and have it flow underneath the top line of the page?

Paul....you're the man!!!!! I have no idea what you did, but that is perfect!...Thanks so much!!

ok here's db with sample table........the queries aren't in the db, but esentially, query 1 is just counting each record by asset_class (which are existing --under existing_prospect), and query 2 is counting the same but those which have Alt_Identified as "No". P--thanks for looking at this...

Ok..well i uploaded an excel sheet which is the way i need the data to look. Should i create a report with one query and then put subreport in the original report????

I have one table called "Funds" which lists an extensive list of mutual funds and each is categorized by a particular asset class (ie Large Growth, Small Growth, etc). I have two queries; one which counts each of the products via the asset class, and another which counts via asset class if a...