Search results

Hi DES, I have made a simplified version of the database to replicate the problem. Putting the requery where you suggest causes an error report to be sent to microsoft as soon as I try to open the parent form. What drives me crazy about this is that running the query that is the combo box...

Hi, I have a Sales Order form with a Line Item subform. One of the fields in the subform has a combo box to be used to lookup the item's location. Each item can have more than one location and there is an Item Location table. The row source query looks at the item number of the current...

Use the code below. =IIf([Forms]![Parent Form]![Order_Item].[Form]![Prod#] Is Null,0,DLookUp("[Price_Case]","Wine Stock","[Prod#] =" & Forms!Order_Item![Prod#])) Just substitute the name of the parent form.

Geo, I believe I know why, but it's no help. In the past, Access had no round function. So I wrote one. My round function gets the same results you are getting. To narrow down the reason, I tested the Int function, because to round a number correctly you must convert it to a long. This is...

What exactly are you trying to do?

Smev, Send me your email address and I will send you the code. Mike

Do you know the formulas for calculating the monthly payments and how to apportion each payment to principal and interest?

Smev, Do you have VB 6? If you do I can send a simple loggin program I created just to play with encryption. I did it because I had read somewhere that it was difficult to reliably secure a loggin for SQL Server because someone using Query Analyzer could still read the loggins and passwords...

Hi, Your second table will work just fine. You will be adle, using the aggregate functions, to get the average for each customer or for each question. Mike

Thanks Shep. I am using both a frontend and a backend. Regarding one frontend for each user I will give it a try. I had considered that before but your suggestion reinforces the recommendation. What I had been thinking, howver, was that, even if you use one frontend file for more than one...

See my reply for "Incrementing Values?" in this forum.

You might encrypt the data in the lookup table and then decrypt it when you pull it out to make the calculations. The key will be in the code which will be unreadable when compiled to an mde. The data in the table will also be unreadable to prying eyes. You will probably have to add an cipher...

Now I'm assuming that your table contains other info besides the family ID, for example a father and a mother. After the user enters the name of the father and the name of the mother, he clicks a button to store the new record. The following sub will run. Private Sub Button_Click Dim FamID...

Hi, Why don't you create a SQL statement in your code that will return the last ID in your family table? You can increment it by 10 and then append it with the new record. Mike

What kind of amortization are you talking about? Fixed assets or loans. Please provide little more detail.

Hi, I have a situation where I have one mde on a server and four clients. So they all are using the same front end. I have implemented security so folks have to log in. The database has patients ( a patient table) with a treatment plan called a case (treatment plan table with a case number...

I was in situation where we tried the Windows Scripting Host. That seemed to work. But we set it up to compare a client file date with the date of a copy of the same file on the server. If the date on the server was later than the date on the client, the mde was copied down to client...

Say your form has a birthdate field (txtBirthdate) and an age field (txtAge). In the After Update event of the birthdate field put the following code: txtAge.value = Age(txtBirthdate.value)

I know of an instance where the Access database is referenced by a link on a web page. As long as the folks had MS Access installed on their machine, it worked. However, they did not do any data updates.

Hi, Does anyone know which one is more likely to get corrupt - an MDB or an MDE? Thanks, Mike