Search results

On the form where they make the entries, I'm using it on the afterupdate of my combo box. On another form, where they just view the records I'm using it on the formCurrent event. On this form, once they leave a record that has one of the values where it needs to display a tab, but then they...

Sorry to bump an old thread of mine, but I noticed something today that I didn't notice before. My tabs seem to be working good for the most part, but for this. I'm using a version of this tab on 2 different forms, but it's doing the same thign on both. On the main entry form, when the form...

OK, maybe I'm doing something wrong with the query I tried to make above. It will be working fine, and then it will all of a sudden just stop working, saying it can't find a valid field in the select. so I can then delete any column from the query, and put it right back and it works again...

Does this look right SELECT Alias.Main_ID, Alias.Edit_Type_ID, Alias.CodeID, Alias.Effective_Start_Date, Alias.Effective_End_Date, tbl_edit_type.Static_Text, tbl_display_text.Display_text, q_active_codes.Code, q_active_codes.Code_Description FROM tbl_display_text INNER JOIN ((q_active_codes...

These queries are for some reports, so there wont' be any editing using these. I've been trying to figure out how to switch to snapshot, but I can't seem to find where to make this change? do I go into query, design mode? Access Help is only giving me a way to export reports as a snapshot...

I've been working some more on this, and got this far SELECT T_tbl_main.Edit_Type_ID AS Expr1, tbl_IIR_description.IIR_code, tbl_Edit_Type_IRR.Issue, tbl_Edit_Type_IRR.Information, tbl_IIR_description.Static_Text, tbl_display_text.Display_text, tbl_code_description.Code...

Office LAN sorry, I should have mentioned that.

I kinda see how the derived table works, but not sure how to write this. Here is pt1 of my query, If I can make Include_in_Web, from tbl_edit_type set to true. That should reduce the records. SELECT T_tbl_main.Main_ID, tbl_IIR_description.IIR_code, tbl_Edit_Type_IRR.Issue...

Is there nothing that can be done by me?

Hi, I've been developing a database 900k records so far, and with the DB installed on my local machine my queries that I use for my reports work pretty good. They will open in under 10 seconds. but now that I've about done with the DB, I've moved it to the network, and now those same queries...

I've read the help, but it doesn't say anything about how to use the VBA function within a query? am I not looking in the right place?

I'm still not really sure how to use the VBA code in a query? I did some searching, and didnt' come up (at least I dont' think I did) any info that helps. I think all I need is to remove the first 5 digits, and leave anything that is beyond that. I'm guessing the code I used earlier could be...

How do I use the VBA from that page in a query? My VBA skills aren't that great, and not sure how to get those results to appear within a query? I think I don't even need the update query, because the column I'm pulling this data from will be deleted when I'm done. So I thought instead of...

Would I use this in a query? I see how it works in the example, but not sure how I would use it to move them to another field?

Thank you that worked perfect, but oh wow. I didn't realize how many records there were, 99k that had this condition. What I need to do is move those last 2 digits over to another field, i didn't think there would be that many and I could just do it manually.. Is there a way to create an...

Hey, have another question sort of related to this I think. If I wanted to created a query, that found all records where a certain field has more then 5 digits entered. Would it be similar to what we used above?

Forgot to mention there are maybe 2 tables from the old database that I'm going to have this problem with. How do I actually go about the importing of the data? If I just start with the first table in the old database, and then the 2 tables in my new database. I have 3 tables im working...

Hi, Thanks for replying, Yes the old database seems to be a flat file, it might even be something that's imported from a spreadsheet at one point. Not sure. The tables, don't even have a unique identifier for each row. I made a query on it, and got the columns that I need for this new...

Hi, Another question on this database I'm working on. I have my database pretty much ready to go, but they would like to import data from another access database into this one. The problem I'm seeing is, I've been working so hard to normalize my database with the proper relationships etc...

thank you, option 2 seemed to work!! woohoo!! That just saved me hours of going through and deleting them 1 by 1 :)