Search results

Hello: You need to put a statement telling it to update the field on the subform you wish. As of right now, you have a statement that updates the primary form only. Regards Mark

Hello I forgot to mention that both forms must be open when you execute this command. Regards Mark

Yes: Utilize Forms!YourForm2!YourTextBox.Text = "YourText" from a command button or other control on your first form. Regards Mark

Hello Merely add or subtract the zone constant. http://en.wikipedia.org/wiki/Time_zone Regards Mark

Hello Your welcome and good luck with this! Mark

Hello: A couple of questions: Is the checkbox bound to a field in a table? Also, the proper way to accomplish what your are doing is place the code in the AfterUpdate event of the checkbox control AND in FormCurrent event when you move to a new record. You need to test the value saved in the...

Hello Try test2 query. Regards Mark

Hello: An example is enclosed Regards Mark In the DefaultValue property box, type [comboboxname].ItemData(n) where n is the row that you want to use as the default. The ItemData property is zero-based, so type ItemData(0) if you want to make the first row in the list the default.

Hello Run the query titled chassis in your DB and see if this does what your asking. Regards

Hello: Simply set the default property of the combo to the value you want. Regards

Use CDate(070707) Regards Mark

http://support.microsoft.com/kb/304104/en-us

http://forums.techguy.org/business-applications/577046-solved-ms-access-report-can.html

Yes that can be done. You will need a relational database design with at least one table holding your technicians and another holding the job assignments. Regards Mark

Hello My take would be to use the full line of code to call a method or sub-routine. This business about the shortcut way of specifying things is bad programming form. I think Microsoft made an error of letting folks do this. Regards Mark

Hello In the design mode of the report merely check to see what table field your text box is "bound" to. This would be the "Control Source" property of the text box. Regards Mark

Hello: There is a performance hit when using aggregate functions in Access. So I would imagine it would be compounded over a network. http://www.thescripts.com/forum/thread533318.html is a link to an alternate approach Regards Mark

Hello: I do not know the answer to that, but here is another link on DSN vrs. DSN-less http://www.stardeveloper.com/articles/display.html?article=2000120101&page=1 Regards Mark

Hello: Please see this link: http://www.powerasp.net/content/database/dsn_vs_dnsless.asp My opinion is that it is best to connect directly than indirectly, but each camp has cheering section Regards Mark

Hello: May be this link can be of assistance: http://support.microsoft.com/kb/208295/en-us Regards Mark