Search results

In searched around and Found FMSIncs statistics page and sent a query on a version for MSA13. Thanks again.

Just checked those sites. Doesn't look promising but I can email them, just worried I might get a sales promise that will cost a bundle. I am doing my error trapping now, and have saved a couple seconds. Also, I was able to keep the original design, open the forms on login as hidden, leave them...

Thanks Pat. I won't know the environment unfortunately. I'll look at those vendors. Hey, let me see if I can stump you. I will also post a new thread, but check out this problem. I have a table (call it A) that holds records that are part of a multiple items optional field in another table (B)...

I am automating in excel on some formulas that Access doesn't offer. I shopped around for an Access adding to install and distribute with the run time version but found nothing online. Are you aware of any? Example of formula, SSEReg, in excel, not in access. Would like to have some add-in do...

It's not like I haven't been working on the main question for over a month YAKNOW:) Bottom line is, there is no way around the form load time. On Current, I have a status check to either enable or disable controls. On Open I am going to new or specific record or first record (depending on add...

I have a form that takes too long to load so I have resolved to do the following: After the form is opened for the first time, closing the form from the form nav changes the visibility property, and when you open it again from the switchboard, it opens quickly. It closes when you exit the...

Hmm. I wanted to use Sagekey but they are still testing the MSA 13 version. I went with InstallAware but have some issues with it. for one, the files get compressed when downloaded and when the decompress, it appears not to be functioning correctly. Also, I cannot find any place in InstallaWare...

Thought so, good to hear it officially. thanks pat.

In doing the check, I included the nz(me.value,0) function in the dimension definitions. For example: Sub CalcRecordSt Dim lFlag as Long Dim sMessage as String Dim dQty as Double lFlag = 0 sMessage = "Noted Issues: " dQty = nz(Forms![Form]![Field].value,0) If dQty <= 0 Then lFlag = lFlag + 1...

That's precisely what I did. There is a subsequent form that must be processes through various stages. It displays the status of the previous form and the status of the current form, and has a record status button that pops up with the noted gaps in the record. And the status cannot be moved...

I didn't mean that it "doesn't work", I meant, it may not be practical in all situations. For example, supposed you are filling out a form that takes a while, like say, a 1040. So you get almost through with it, and realize you are missing something. You don't want to throw away the 20 minutes...

Thanks Paul, You have been very helpful during my little summer project. So I am going to keep sharing what I am doing with you for your insights. So I have two forms that are relatively complicated out of about 40 forms. I have tried several macro based checks but with a long form, unless...

Ok, I did what you suggested. I am looking at table record field values and running rules against them to see if there is an issue with the record, and displaying a status with conditional formatting. I am using a recordset to get the field values from the table. My issue is that when I click...

Hi All, I purchased an install app (installaware) to make my app available for beta testing via the web. I noticed in using this, that when I install the app in the Program Files sub directory on the client's computer (in this case, my secondary computer), the following happens: 1. Everytime...

Well said. So on the equivelant of stats, I have various status (draft, proposed, pending, executed, closed) and the user defines these. What you are saying is I need to still do some validating so that if a record "appears" incomplete, say, the quantity = the default quantity, or the homeruns...

It comes down to what the field is "required" for and its been a dilemma for me. Supposed you wanted to provide a sports team with a data on player statistics that would be used to figure out a players bonus. You would need certain info to create a record for the player such as ID, name, team...

I agree with you. My frustration with defining the rules in the table has been what happens when the user does something unexpected. I like to give users a lot of latitude when working with forms. The app I am developing has some very short forms where I don't mind the system telling users a...

I think this was because when I deleted tables and readded them, I accidently included the original system tables because they were in the list and I didn't know it case the list is in alphasort.

Good Morning/Evening, I have a question on tables in the front end. I am used to seeing what appear to be files that help connect the front end to the back end, but recently, I noticed they are expanding, replicating themselves with sequential numerical suffixes. For example, I have always...

Oh great, the above won't work because access writes to the database the second one of the form fields isnot null. I'm telling you, validating that a form is the way it is supposed to be is impossible in access. There always seems to be a way for a user to screw it up without access detecting it.