Search results for query: *

I have a subreport that list monthly deposits by area and then a field in the report that sums all the deposits. Some months there are no deposits but do to the calculations it will show each area with a zero balance. I would like to hide the Subreport if the field that sums all the Deposits...

I did try cancel but not after each msgbox.I will try that. As for not working it allows me to enter in any amount in the allocation subform and doesnt do any thing. I can just go to a new record in the main form it doesnt seem to run the code not even a error debug?

I enter a check amount into the main form cutCheckAmount and in a sub form I am allocating the check to the corresponding departments. On the subform I added a txbxSum I need the txbxCheckAmount to equal txbxSum before it will allow me to precede either with closing the form or entering in a...

Oldnewbie Is there a way to create an action button or key stroke so when they hit the alt key it activates somthing in the page this way it basically disables the alt print screen combo.

If I have to post some info can I disable the print function, and the alt button so they cant print screen it? I have been told I have to give them access to veiw the information but I dont want them taking it with them. Is this possible through Flash. Any help would be appreciated. Thanks Tmat

I have a form that has a list box. You chose from the list and it populates text boxes that are used in two queries. I have a subform that uses these two quires for its data. The subform does not update or change unless I close the form and reopen it then the info appears in the subform. I tried...

I have a form with a list box and you chose a class from the list it populates text boxes that feeds two queries there parameters. Q1-non preferences and Q2-qualifications then I run another query to find unmatched professors between the two this tells me who can teach the class. My dilemma is I...

That did it! Thanks Tmat

I have a drop down list of a few fields that populates text boxes on a from that no one Sees I use these text boxes to populate a criteria field in a query. I am trying then to run the info in the text box through this function but my function is not correct and I cant get it to work. I don’t...

It was running fine then I copied it to another dbase and now it keeps hanging up On Set recClone = Me.RecordsetClone I was using it in 97 and I am trying to use it in 2000 on a form. Any help would be appreciated. This is part of it. Thanks Tmat Private Sub Form_Current() Dim recClone As...

I have created a query that shows me who is qualified to teach courses but I have another table with personal restrictions. What I am trying to do is eliminate any one from the qualified list do too their restrictions. I have tried linking and changing the joins and parameters I get some results...

That worked perfect.Thanks for the help.

I have this one field that contains data like this Field 1 what I need DE DE CTT111 CTT CY22 CY BRBB BRBB WHCH201 WHCH What I am trying to do is determine if there are any numbers in the field if so then extract the letters to the left of...

Thanks for the Example Would have never of got it other wise. Thanks so much for the help. tmat

I am not sure what you mean? I tried creating two queries but I am still running into the same problem. I must be missing somthing? Tmat

I am trying to create a unmatched query using the wizard but it only allows me to match up one field. In my case the Primary Key is three fields. I have tried to add some fields in the SQL but its not working. Any help would be appreciated. Thanks Tmat

Thanks for the response it seems as if I have the wrong bootdisk still. I went back to the web page I got the 95 boot disk from and its for 95 or 98. I will have to locate one for win95. The only one I made was from after upgrading to win98. I should also find out what version of win95 I have on...

Ed when I fdisk the c drive When it asked me if I wanted to format 2gig or better I said no and then I deleted all the partions working my way up to the primary once done deleting I then added only one partion. At that time it said to exit and reboot for it to take, I assume because there is...

I believe its a 1.2GB thats what the documentation said. You are right with guessing that I compressed my hard drive when upgrading to win98. I did try to reformat using what Ed said but it kept telling me parameter missing or somthing like that. So I formated /v /s and it took and I used the...

I have a Packared Bell P133 w/16MB Ram 1.2GB hard drive qaud CD. I up graded to win98 and added some other programs and it started acting crazy. I figured I would clean my hard drive and reinstall win95. I boot with a flopy it reads my cdrom an at the a:\ I type fdisk and go through the setps. I...