Search results

I have a continuous form that opens with a summary of information and I have placed a control on it which opens up a continuous form which shows a 'detail' of the information. On the detail form I want to be able to run an SQL to update some of the information in the data and then requery BOTH...

Line 20 I tried to place a ' on line 20 so it would ignore the line but it returned the same error for line 30 so I did the same for line 30 and line 40 returned the same error...

This works very well except for the Send button beside the Properties adjustment. Clicking this will return an error Error 2467 (The expression you entered refers to an object that is closed or doesn't exist.) in procedure fCurrentForm of VBA Document Form_DcbFormSizer_V3 I like the...

I would be happy to help you back. I ran it again and when I selected dcbFormSizer_V3 as the Current Form it returned the same runtime error 2465 Application-defined or object defined error fFitToScreen = fCurrentForm.FitToScreen

O okay so all the end users are sort of like that, hahaha, I just thought I had a difficult bunch here. Ummm maybe I should sieze the opportunity to ask how to fix the width so they can not squash it to 1x1 pixel or stretch it so it would fit on their home 52" LCD television.

Thank you. When I selected TestFrm1 it returned a runtime error 2465 Application-defined or object defined error fFitToScreen = fCurrentForm.FitToScreen

Thank you vbaInet I will now be putting Me.Move 0, 0 Me.Moveable = False into the OnLoad event so that people can not booger around with the position of the forms. I am not at the point yet of the width and height being fixed. I am not going to try to put the thing with a message that "The...

THANK YOU! I put Me.Move 0,0 into OnLoad event and YAY BINGO that is perfect perfect this will stop people from boogering up where the form is on the screen. O the mdb does not open, the zip is fine.

Oh well. I tried to open that zip and it gave me unrecognized format error and would not even open in access2003.

Thank you vbaInet. I went and turned AutoCenter to No and moved the form and saved it and it is where I want to place the form, even on the worst screen in the building. For the Move coding I can get Me.Move (Left = 0) to work but Me.Move (Left = 0, Top = 0) does not it gives me a error...

I tried to search this but all the answers seemed to lead to people making a form fit different size screens and being centered, actually all I want to do is to have my forms open up in the top left corner of the screen. Hopefully this is just a setting to either find the top left or something...

Thanks for all your help but I have changed strategy. Just gave it some deep thinking and decided that if there is only one text box that the end user needs to go back to I will make it a one and only text box in a subform. Now it works because there is only one place that focus will set to...

ooooops - yes it is Text5 and not Text1 as I first said. I actually copy and pasted from my VB the second time so that is really the real text box name. I am not getting any error message at all and I tried debugging by stepping through the entire code in case there is somewhere that it takes...

I just tried it and it still sets focus to the combobox and not the textbox. I tried DoCmd.GoToControl ("Text5") DoCmd.GoToControl "Text5" I have been trying to run the whole code in both AfterUpdate and OnExit events. Everything else works except placing the focus back to the textbox.

I have tried to search this out but have found conflicting suggestions and still have not found a solution. I have a form with two fields, one a ComboBox and the other a text box, both are unbound and two controls, one is to close the form the other is to close the application . On entering...

Thank you HiTechCoach - I looked at those links you posted and the second link has provided me with a sample that I might be able to work with if I can get it to work on my application. They are in Access2000 and I am stuck using Access2003. Well it might not be stuck because Accees2007 seems to...

I searched and did not find an answer so maybe this is something newish. I have a textbox on a printed report made from contatenating some fields and what I want to do within the textbox is to have just a portion of the text print bold if it matches a certain condition. Can I have the...

The only tricks I know of so far are these two. In design if you click on the label in the toolbox, before you place the label you can change the default settings so all the subsequent labels you place will have that as an initial setting for all the labels. If you use the wizard to build...

With Access2003 go in reports, click on the New button and use the wizard to make a Columnar report.

To round down you can subtract half of then next decimal place. So you can use Round([ILL]-0.05,1) But you should maybe use DatePart function to convert hours to decimal or you are converting 3/8 into 1/3. ((DatePart("n", [ILL]) / 60) + DatePart("H", [ILL]))