Search results

A simple internet search uncovered this: http://word.mvps.org/FAQs/MacrosVBA/DeleteFiles.htm

Hello: Your welcome!

Hello: Here you go....... http://support.microsoft.com/kb/296246/en-us Regards Mark

Hello: I'm not sure what version your using, but the below works for XP and 2003 and maybe 2000 Regards Mark Sub AllQueries() Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentData ' Search for open AccessObject objects in AllQueries collection. For Each obj...

Hello You can use the MsysObjects table and get it from there. the digit 5 is the constant for queries. SELECT MsysObjects.Name FROM MsysObjects WHERE (((MsysObjects.Type) In (5))); Regards Mark

Here you go..... http://www.mvps.org/access/datetime/date0006.htm Regards Mark

http://www.fmsinc.com/products/startup/

Hello: On your report there should be a Property called PageHeaders: Make sure that it is set to "All Pages" Regards Mark

Hello: I believe you need to set the RecordSource property of your report to your SQL statement! rDelivery.RecordSource = Your SQL Statement Regards Mark

Hello: Please see enclosed attachment Regards Mark

Hello: For SQL, I would ask the most basic task of returning all records from a specific table. If they REALLY no SQL they would no the short cut to do this. For instance, ' SELECT * FROM tblEmployees; would return all records from tblEmployees. The key is the Asterisk symbol. Regards Mark

Great! Also I glad I was able to respond to your message in a timely manner. I accidently stumbled on to it looking for something else. Regards Mark

Hello Enclosed is an example of how to determine the X and Y values of the mouse pointer. I hope this explains it: Just two lines of code in the MouseDown event. Regards Mark Private Sub Detail_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) 'Determine the X...

Hello: I just saw your message today July 23 2007. I will look up my example and post. Regards Mark

Hello: One way to accomplish this is to have a duplicate check box field in your table next to the original. Then when some checks your check box on your form, use the AfterUpdate event of the first check box field to update the duplicated check field. You will have to do this with VBA code...

Hello: If you had a control named TEXT1 on your form, the below code would put the cursor at the beginning of the text box. This would go in the Form Current event of your form. Regards Private Sub Form_Current() Me.Text1.SetFocus Me.Text1.SelStart = 0 End Sub

Hello: Here is an article with an example: Regards Mark http://msdn2.microsoft.com/en-us/library/aa218286(office.10).aspx

Hello If you are familiar with VBA you can use the SelStart property do this. It cancels the selection. Its in the help section. Regards Mark

Hello again. A good way to trouble shoot the problem would be to start with just your primary table and ONE subordinate table in the relationship. Then run your form with just that to see if it completes the record and lets you advance. Then add the next table and do the same procedure...

Hello The problem most likely is that your complete record as defined by your relationships in incomplete. You have a blank somewhere thats not getting filled in. Regards Mark