Search results

still not quite working, If I put a number in the box, I get runtime error 3464 Just for a test I tried Criteria that starts with a number, but ends with text I get runtime error runtime 3075 same as earlier, only now it puts what I put in the text box after the = If I put just text in the...

It seems to be getting closer, Now I'm getting an runtime error 3075 syantax error, missing operator in query expression '[member_ID_Number]='

I tried changing it to what you have above, but I'm not getting a runtime 2001 error. Any Ideas?

I would really appreciate it, maybe if I see an example it would make more sense to me. All the criteria will not be just date datatypes, the dates are only 1 piece of each sub category, they need to be able to store: provider names, drugs, provider numbers, it just depends on which sub...

I've thought of cascading combos, and I think once I get to the forms I'll be using them. But I'm still not sure how to design the tables and how to store the data for all these categories. A part of me, just wants to be lazy and create 1 big criteria table with all these fields, knowing that...

tblmain is the many side to my tbl_member So it has fields like this. Date_loaded>> date that this record was created Loaded_by>> user who loaded this record 'UserID' Comments>>Text field to allow them to write comments about this record The dates in the criteria sections, are related to that...

I'll try and explain a little more to what I have, and what I need to do. I have a member table tbl_member MemberID PK Member_id_number name etc tbl_Main Main_ID pk MemberID fk date_loaded loaded_by I have some other tables that relate to this main table, that hold other information...

So instead of having a table with 3 fields for: Dates Provider Whatever else they want. I would just have the 1 field? Where they could type in all the data into it? Or am I misundertanding what you mean? If that is what it's for, I see a problem later on with reporting. This field could...

tblEntityOptionData EntityOptionDataID (auto, pk) EntityOptionID (FK) DataKindID (FK) DataResult (Text) I'm a little unsure what DataResult is?

Thanks, sorry I didnt' give enough info. Something I left out is, all this information would be related to a record in my main table. It looks like I might be on the same path of you, I have my main table. I then created a 'criteria' table that has Criteria_ID PK Main_ID FK from Main...

HI, I've been banging my head on this, and I just can't seem to find a good way to create my tables. They want a selection with a sub selection, and then allow the user to fill in data depending on that data. I'm not sure if I should make a new table to hold the data for each sub...

I was thinking of the onclick of the button on the search form, it should work there shouldn't it? My VBA isn't all that great, but am I on the right track with this on the onclick of my button Dim stDocName As String Dim txt_membercheck As String If DCount("txt_membercheck", "tbl_member"...

I think option 1 would be the way to go. So I've been reading up on DCount, would I put something like this somewhere on my main search form? DCount("txt_membercheck", "tbl_member", "Member_ID_Number = 1")

Hi, I've search the forum, and didn't see this question asked, but I might not be searching for the right criteria. Here is what I have. I have a form where the user can enter a user ID, and when they hit submit it will search our user table. Here is what I want it to do next, if it finds...

Hi, I've been searching and haven't seen any examples, or this question come up before. What I'm thinking about doing is, I have a main form, on this form there are some yes/no type fields that will have additional info needed to be filled out depending on what they select. so in trying to...

Ya I was making sure I was selecting my main table, but no matter how many times I did it, it would delete from my temp table. but I tried the delete dinstinctrow, and I think it worked this time!! I wrote down my totals of all the tables queries before I ran them, and then subtracted after...

GRR, I guess it didn't work. I should have checked closer, Once I find the PK's that I need to remove I create the temp table that stores it. I then created a new query, add my main table and my temp table it draws the line between both Main_ID's. I enter all my fields from my maintable * I...

I got it to work by doing option #2. I didn't think of after getting all the results from the new query, just selcting all delete (lol) I was making it too complicated.

OK, I know what records I need to delete, just not sure how to do this. I have 2 tables. My main table, and a child table that hold some additional info for that record. What I've been asked to do is, delete all records where in the child table the records meet a certain criteria. So first I...

thanks, I think something happended and somehow an older version of my form got loaded. I changed it to this Case Else If Len(strLastTab & "") > 0 Then Me.tab_more_info.Pages(strLastTab).Visible = False '-- hide the Previous visible tab End If strLastTab = ""...