Search results

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

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

?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...

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...

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...

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...

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...

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...

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

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

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...