Search results

Hm....ok I got everything going. Except what is weird is that it calculates the total when you open just the subform. But it brings up an error when you open up the Orders with the subform. Hum....I will keep on trying here.

If you send me something that I can edit, I can inport one of my forms that I have done and then just change the fields to match yours. If you want that done I can do it. Just send me a database I can edit.

Ok, I looked at the database. Yeah, you are right it doesn't work right when you put the text box on the Main form. I know you want your subform to be in Datasheet view, but since you have so many fields and you have to scroll horizontally, it probably would look more professionally done if...

Perfect. One question to better understand the code....what does the Nz mean? And what event would be the correct placement of this code?

Says "File Not Found".

I appreciate your helpfulnes. Ok...I can do everything, but not unsure how to check if they are populated? Could you give me more information on that? I tried this code: If Not(IsNull(Me.txtCompany And Me.txtAddress And Me.txtCity And Me.txtState)) Then Me.btnSave.Enabled = True But this...

Just a simple problem that I can't seem to figure out. Background: I have a form and I have option to add a new company. Then when the user gets done filling out information they need to press Save. But the problem is that sometimes a blank record is saved... So what I thought was that...

Ah, sorry for the confusion. I wouldn't know the equation right now. I would need to see your database to figure it out. So if you send an example or whatever, I can see if I can figure it out for you real quickly.

Just click on the Properties of the field and go to Data and then Control Source and then click the elipses (SP?) and then create an equation.

If it is a particular tab on a particular field, put the code in the On Lost Focus event of that field....and then unlock the controls on your desired field in the On Got Focus event.

DoCmd.RunCommand acCmdCopy I think that is the code.... And then put: DoCmd.RunCommand acCmdPaste I hope that helps.

Maybe what I would do, but probably not the best way, is to create another text field in the mainform and then fiddle with the Control Source of that text field so everything you want to add from the subform is added. Hope that helps...

Alright. Good luck on the rest of your database.

This is how I do mine. I input the dates from a form. But on your report make 2 text boxes. Put this in the first one's control's source: =[Forms]![frmName]![txtDateFirst] and then put on the second's contol source: =[Forms]![frmName]![txtDateLast] That works for me. Fill in your...

PM me and send me your database. I can help you.

Make a query. Include the fields that you want to show in your report. Fiddle with the criteria in the query because that is the most important part. Then make a form based on the query and make some buttons to open up the report. Finally save the query as a report. And you should be good...

I just dealt with this for Active/Inactive companies. What I did was when I wanted to delete a company, I would press a Delete button, but the company would only be inactive. It would not be deleted. It my table I had an Active/Inactive column. So when deleted, that field would be changed to...

There is a problem with your IF statements. Or your End If. Maybe put End Select on a line above End If.

I have an iPhone and it is worth it by far. Phone, GPS, REAL internet, iPod? What more do you want. And with this new update for the iPhone that just occurred, you can download applications such as games, instant message clients, navigation, TV apps, radio apps.....the list goes on and...

Another question, say there is two "Does". One in one company, and One in the other. When you go to the next company, the code doesnt work anymore and highlights the first record again. Any suggestions?