Search results

  1. Navyguy

    Search Tips

    Hi Everbody Its been awhile so hope all is well. I need some search tips to find threads on automatically updateing the front end when it is opened by a user. I have checked updating, automatic, front end, etc and have not found what I am looking for. Suggestions or links would be great. Thanks
  2. Navyguy

    Is this all the tables need

    Hey phat al On the surface this seems easy enough...but Just a few questions: are pizza1 and pizza2 the same tables? Generally try not to copy the same data over and over. Is your form(s) for data entry or lookup? An example is you might have to modify your presentation or layout of your...
  3. Navyguy

    newbie question: query only the records are in current month

    Hit there cuongvt Now() means right now...according to your internal clock of your system. This included both the day month year, hours minutes and seconds. I suggest using a filter that just looks for the month only. Also not sure what your fields look like but Date is a reserved word in...
  4. Navyguy

    Lost in Linking

    Hi there jermadem I have pretty limited knowlege when it comes to this stuff, but what I was thinking is that your web page is "looking" at the linked table (which holds nothing but the pathname to the data table) instead of looking at the actual data table. If you copied the data to your DB...
  5. Navyguy

    Requery on what event?

    So I see then. You still don't store the calculated age but use the date that you need to be referred to for future in the function. So if I wanted to know how old you were when people registered, I would just use the registration date in that formula and have it show in the report at some...
  6. Navyguy

    Requery on what event?

    So I reviewed the thought that Rich gave me about putting the Txt boxes on the same form. The calculations seem to work OK, but now my question is how do you store this data. Now before I get jumped on, I know that you are not supposed to store “calculated data” but there are some statistical...
  7. Navyguy

    Requery on what event?

    Rich I don't have DOB in two tables, but it does show on the main form and the subform. I figured that once I got the AgeCalc figured out I would just hide the second instance. With it visible it tells me that the requery is not working properly. Your question does make me think now about...
  8. Navyguy

    Requery on what event?

    Tonight seems to be the night for questions... I have been reading both from posts and from my reference manuals regarding the requey method. I have a main form FrmRegistration with a text box TxtDOB. I have a subform SFrmAgeCalc with has TxtCurrentAge, TxtDOB and TxtFutureAge. The subform is...
  9. Navyguy

    Form Referencing for Cascading Combos

    That was exactly what I was looking for!!! Thanks allot.
  10. Navyguy

    Bringing my DB to the www

    I am no expert, but from reading here I believe the concensus is use ASP or ASP.Net. What I have read is that these web enabled programs may need special servers and software. Also what I understand is, there is alot to do with read/write access on the hosting server which apparently has loads...
  11. Navyguy

    Form Referencing for Cascading Combos

    Hello All I have a series of cascading combos on a form that works great. Now I have a main form with some tab sheets that I want to use my cascading combos (now a subform) on and I get an error. Should I be referencing the tabsheet or the main form name in my Row Source of my Combo...
  12. Navyguy

    Tables for Cascading Combos

    ?Success At Last? Well I managed to figure it out. I am not sure how efficient it is but I know it works and the cascading combos work well. From my initial table of 231 records I ended with 5 tables for a total of 632 records. What I ended up doing was duplicating the data and assigning it...
  13. Navyguy

    Tables for Cascading Combos

    Hi Len So I have sat back for awhile now and then dove back into it. I am happy with the data table(s). In fact I think they are quite simple. My hassel is dealing with the Entry Forms so I have the least possbile chances for error. I have been working on a variety of cascading Combos...
  14. Navyguy

    Tables for Cascading Combos

    Just another question…in my example above I was thinking that the “Event Number” would be the last item to be found. Maybe another aspect would be to know the “Event Number” and have the other fields be completed automatically. I guess the only problem is that the reports that are required are...
  15. Navyguy

    Tables for Cascading Combos

    Hi Len I was not sure if the normalization rules applied to "Lookup" tables. I guess I am trying to make the inputting of the information as easy as possible and trying to foresee possible problems with the data entry, that is why I was thinking of the cascading combos (limits the possible...
  16. Navyguy

    Do I need to split tables into smaller tbles?

    Hello Switchwork What you are looking for is information about "Normalization". My understanding of it is that "all similar information" is stored in the same table, meaning that a table may have 24 fields that are similar to each or may have 3 tables of 8 similar fields within each other...
  17. Navyguy

    Tables for Cascading Combos

    Hi Everybody I am looking for some suggestions on splitting a table up for lookup purposes. I tried the table analyzer but it did not make sense to what I wanted to do. What I have right now is one table with about 200 records. The field are: Tbl-Events EventNumber (PK) Number Divisions...
  18. Navyguy

    Form Layout / Interface Style

    Not sure if this is what you are looking for: http://65.19.160.24/forums/showthread.php?t=67557
  19. Navyguy

    Data Entry Tabbed Forms

    This is what I have for IME. I don't really know too much it though. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/intl/ime_3n3n.asp
  20. Navyguy

    Data Entry Tabbed Forms

    WindSailor I think I have isolated the problem. Your sample worked great, but I then modified it to what I have more closely and then wham...the same error appears. I have attached your sample (modified) to this message. Take a look at it and see where I modified the main form and created...
Back
Top Bottom