Search results

Wow - How did I miss this info. :) initial testing seems to work correctly. You are a life saver! Thank you very much. sam

Could someone explain this? (problems in code - this is a sample from the debugger) ?int(39.564/13.188) 2 ?int((13.188*3)/13.188) 3 ?int(35.256/11.752) 2 I am beating my head against the wall. (sorry - adding - this is access 97) Thanks sam

this is access 2002 sp3 - mine was 2003 sp2

I have a friend that has a database problem. When she tries to run the report wizard on a table - the tables show up in the "tables/queries" drop down list - but none of the fields show up in the "available fields" list. She said it started happening out of the blue on all of the machines...

Thank you - That worked. I though had to run a select query before the update to only give me top 1,000,000 records at a time that where not updated - so the update query had to run 4 times (3.6 million records). I could not update them all at once. - same error That had never crossed my...

I am trying to change a field lenght of a large database (access 97) It is at 50 right now and want to change it to 25. When I try to change it and save the table I get a error when the bar is about 3/4 the way accross the bottom. then This is error 3183. In the help it says that the TEMP...

Thanks I will try that. I am leaning and already started re-writing the form so the function is done in a query. I think this is going to be a better solution. I can sum and count the one table and link it to the main table. then do the calculations in that query. I am making the function...

Guess I don't quite understand what you are saying. I have a subform that in the footer has a control source that has =Count(*) also in the detail it has =Sum([ppfoot]). one counts the records in the subform and the other sums the some data. The problem is I have a function that I wrote that...

I am having a problem that had been run into before. I have a couple of calculated fields in a subform. One sums a field in the subform and one counts the records. I have a function that I wrote that takes all the data from the main and subform and does a calculation. If I do a refresh and...

Thank you - That is all I needed to know sam

That is what I am doing right now. Just was wondering if there was a better way. thanks sam

I am sorry I didn't post that I am using access 97. It doesn't appear to be an on_dirty event available with 97. I manual put an on_dirty event in the form code and it didn't work - I sould have known when it didn't capitalize it. Is there something similar for 97 or am I doing something...

I have a from that estimates a price depending on hundreds of variables. I have a button right now called calculate that runs a function I wrote that does all the calculations. What I would like to do is if anything changes on the form the function will run. I would rather not put the...

I have about 20 querys that run every 5 minutes that pulls/updates info out of our navision accounting software. We just converted to navision the begining of the year so this is relitivly new to me. We used to use SBT(vfoxpro) which allowed us to use an odbc link on every computer to get the...

Very cool idea. thank you - I will try it and get back to you sam

As you can tell I was self taught. :) The main thing the temp hold is for is so that if someone types a space the and the form requerys the space is stripped out of the list box. So the hold keeps track of the last change so if after the requery the size of the text didn't change it assumes a...

I have an odd problem. I have a form that is pretty intense. It is a costing form that allows users to pick operations needed to do a job as well as material and such. It calculates it on the fly and gives a price per part each time someting is changed. Now here is the problem. In the print...

Thanks I looked at Fizzio first example with the which is scary close to what I am doing. I attached an example using fizzios data and my code in form1. If you double click on the company name it will open the customer form. Notice the space bar works in my example which doesn't in fizzio...

Well I just found out that access 97 has a limit of 64000 records or so in the combo box control. I have a table of customers that I needed to have a combo box that workers could start typing in the name of the company and it would show up in the box. The table has over 600000 records. Time...

Here is something that I have found. I have a form that lets you type in a die number and then finds that record on the form. Also on the form is code to make up a file path to a autocad drawing stored on another drive letter. It then allows you to click on a button to view that autocad...