Search results

Thanks... The query of the subform only contains two tables, the query of main form contains one table.... each table is different in this set of 3. However, in the database relationships, all three tables are linked together. The image I used above was an attempt to show the relationship...

I realize this thread is old, but I've been having similar problems and no posts referenced the solution I happen to stumble upon... so here it is for use by others: Private Sub Patch_ID_Click() Dim WebLink As String WebLink = Application.HyperlinkPart(Me.Patch_URL, acAddress)...

Thanks for all the questions =). 1. It does not. The form pulls all variables from table cyber assets and the subform pulls all variables from table patches_cisco, plus 3 fields from table patches by devices. The link between the child and parent is by device key, which appears in both the...

Okay, I pretty much merged the databases and I've gotten everything to work as it should, or at least a lot closer to what it should be. It's pretty much as described above, except merged. One question: In my junction table... how can I auto-populate it (I realize usually this isn't possible...

Good point about the combo boxes, but basically I'm not there yet. The problem is that form appears unable to pull data from the linked table, at least based on the values in the junction table.

I have one database called asset management. It consists of one main table called cyber assets. Most fields in this table are linked to a manually created lookup table inorder to restrict user input. There are also two additional, none lookup, tables used to list a) the IP addresses (there can...

Here's a link to a post I made a while back which can provide you with more background (see the relationships image at the top): http://www.access-programmers.co.uk/forums/showthread.php?t=239883 So I got everything to work exactly as I wanted it to.. the listbox has its rowsrc manually...

I had the same problem. I am using a Listbox as the main form record navigators instead of the typical record selectors. So all I appear to have to do is save and reapply the list index... here it tis: Dim placeholder As Integer placeholder = Forms!VIEW_CYBER_ASSETS.UNIDs.ListIndex...

Thanks, didn't know there was a script out there to do this. I have run thru this type of process in that past and it typical does speed things up a tad... if the problem comes back, I'll give it a try and, if it fixes it, I think we'll be able to say it is somesort of bizarre resource problem.

The form has numerous buttons on it, all function correctly on all computers except that one button does not function on ONE computer but works on every other computer. When you click the form load button on this faulty computer, it just hangs as "not responding" on occation and other times...

I find it useful to rebuild my code, regardless of environment, from time to time. I don't mean starting from scratch, I mean like rebuilding an engine. Start with a new database, import each table from the old one checking everything along the way... same with the code... forms are a little...

I decompiled/recompiled my code using these instructions, second post: http://stackoverflow.com/questions/3266542/ms-access-how-to-decompile-and-recompile The original database size was 27.5 MB, now its 25.9 MB... helped a little I guess. And it did get faster, it used to take 2-4 seconds for...

Yes, but as this example relates to my situation, you'd have to take it a step further... you'd have a table called "People" that relates to the table "Addresses" (1 person can have multiple addresses) then Addresses would relate to the cities_states table (except in my situation one address...

Regarding the capital letters, tell me about it: http://www.access-programmers.co.uk/forums/showthread.php?p=1223693#post1223693 Regarding the stand alone table comment: Does that mean your suggesting I use a subform for what I am trying to do? You understand why the data, as is, needs to be...

hmm.. okay, I'll try out those tools. And I'll give an effort to some sort of find/replace effort... with a backup taken first of course =). Thanks guys@@

I think I figured it out, kind of complicated and it slows the loading time down 4 fold... but it seems to be working. Here is the on load code: Me.TFEs.RowSource = "SELECT TFEs.TFE_Num, TFEs.TFE_Name FROM TFEs INNER JOIN" & _ "(CYBER_ASSETS INNER JOIN...

Here are the three linked tables, the big one is the control source of the main form: Here is the control I am trying to get to work on the main form, a 2 column listbox: Here is the non-functional query: SELECT CYBER_ASSET_TFEs.TFE_NUM, TFEs.TFE_Name FROM TFEs INNER JOIN CYBER_ASSET_TFEs...

Thanks Guys... I'm guess I'll just live with it, for now :o

My DB has a front end and a back end. There are currently about 10 tables and 5 forms and roughly 1000 lines of code. All my table names are like this, for example: CYBER_ASSETS, MFR_MODELS, IP_ADDRESSES All my form names are like this, for example: VIEW_CYBER_ASSETS, EDIT_CYBER_ASSETS...

Thanks man, I concur... you explained it better than I. I am open to alternatives and that's one of the reasons I started this discussion. If you look back at my first post, you see that there are 2 format options for the UNIDs. I recently changed this a bit so that all the tags are formed using...