Search results

Hey, Ian that's a little beauty! Just so the dummy doesn't mess it up, TbleCompanies will be my Sect228 right; and Tble Assns will be a new table. Then I go through ALL my tagged records and determine a strict priority order. Then when its all done throw your command button onto my...

That's fine. I hv lots of other things happening with the data. Here's another aspect. Code DM usually only is associated with two words that frequent; 'data' and 'records' or 'record'. Some of the other 25 codes may be tied to a wider no. of key words. These associated words might be placed...

So lets come to terms with the defining the flds first, and will this be a separate table from Sect228? viz. within Sect228, there are 4600 records but probably only 100 words to 'associate' and prioritise initially. The max no. of associations is 25. Using my example, do I make a fld for the...

Thanks Ian, you can see exactly what I want to do, and have conceptualised the problem precisely. They are not companies, but "Sub _Structures" but your example hits the point. In the Corp Data Comms case, which may occur, I will rank subjectively by word frequency viz. I have fewest Comms...

Yes, you're right. I think that I've answered half my own question. But let me elaborate in case others have similar conceptual problems. The data comes into MainTable and appends c. 400 records weekly. Main has about 12 fields which have data appended, one of which is text called Sect1. When...

Okay, on 14/9 I posted this problem and had a nil response... Maybe I can rephrase what I'm trying to do. In my MainTable I have a field where the text entered serves as the primary key in a related table (Non RI'd, because this fld may also be blank). My objective is to automate a series of...

Thanks Pat, you're dead right. I had to re-locate the computer and on start-up, came to the form and tab is normalised. Tks.

My form, of some vintage, Access 2000, has suddenly decided after trying to Tab to NextFld, to tab right out of my form, and go to Access main page. My properties appear as always, so any suggestions from anyone who may have experienced this oddity? Addendum: However using the enter key now...

There's a wee arrow in the bottom left corner, click the < and your first record appears, and records are then in that order! Of course, click on your date field 1st.

Well I cracked this one within 24 hrs! Thanks Dynamic. I solved the error code by putting in the name "THeFileName" which was equivalent to Me.txtpath anyway. The first test of data-input, previously running on 10 macros proved great results. But as I have to make six manual consultancy...

One further thought.... Being an employee, you're in a bit of a bind, as all the others have said (mostly all). As the other company is most likely a competitor (but not always), you have to work out whether you are still an employee or a consultant. If the latter, and your db has merit for...

Can DLookup Do This One, or will Combo boxes help? Okay, my db is getting larger & larger (41,000 recs), personnel data, and I have the following problem: 10,000 recs have a textfld with about 7,000 variations, 31,000 are blank on this field, called Sect1. 95% of data comes in under a lovely...

Method or Data Member Not Found? Dear Dynamic When I put the code in at the on double-click event for the text box which produces the new path, I get the above error command. I'm not sure why unless perhaps the code must operate off a separate command button? Any suggestions? Thanks in advance

Hi there, Using both macros & code, now tired of all macros. I use a form (tied to code which defaults to C:\My Docs), but I would prefer a form to pop-up with previous week's filepath, as outlined here in my first converted macro Module, called GetNewData. In other words, is there code which...

That's a great, logical explanation!

If you have 10,000 serial nos. then these go in one table. Second table will be common features for each unit, and the units will be records in the unit table. Think of it like personnel in a department and again, study the Northwinds sample. You create new tables in your query, even if you...

Always start by outlining your database design on paper, then draw a report of what fields of info you want where. Then study the Northwinds sample and look for similarities. Then use the search key, and read the many sample questions. Start by putting each team in a separate table, then put...

To get your totals first use your sigma key, and this adds the Group By command in your query. Click Group By and you'll find the other options , somewhat akin to Excel. Then try the crosstab for totals, and failing that, try a query-on-a-query. Hope this helps.

Dear Tim Tks yr suggestions. I'll try the update approach, as from what you write there's no simple code to make the Strconv permanent from the textbox...it just appears to make the change to the text, i.e. in the form only. Thanks part 2...had forgotten.

If I read you correctly this is a question of understanding first off, that you want the one table with three fields which all might contain a number you already have; in which case I think you need to look at your database design, read the DLookup posts here, and perhaps re-structure your...