Search results

Hi Everyone Is it possible to recover a form that i have accidentally deleted Thanks for any help Tony

Thanks Gemma Works great Kindest regards Tony

Hi Folks Is there a way to put a cross instead of a tick in an access logic field. We have just paid a lot of money at work for a scanner that only seems to recognize crosses. Thanks for any help Kindest regards Tony

Assign a printer to a specific report Hi again Yes there is, Try this:- Public Function AssignReportPrinter(strDoc As String, strPrinterName As String) As Boolean On Error GoTo Err_Handler 'Purpose: Set or remove a custom property for the report for a particular printer. 'Arguments...

This will bring up the print dialogue box Hi There Try this Dim stDocName As String DoCmd.RunCommand acCmdPrint stDocName = "Your_Report_Name_Here" DoCmd.OpenReport stDocName, acNormal This will bring up the printer dialogue box where you can choose from a list of installed printers...

Try This Hi Have you tried: Me!Text62.Visible = False or Forms![name_of_your_form]![Text62].Visible = False I have not got 2007 or vista but maybe the syntax required is a bit less forgiving All the best Tony

I think it goes something like this Hi Mailman I think it's to maintain the correct syntax for the Rnd function In Access, the Rnd function allows you to generate a random number (integer value). You can specify the random number to be a value between 2 user-specified numbers. The syntax for...

Great advice from the Mailman Hi Mailman Thanks for pointing me in the right direction. I ended up with this and it works just great:- LRandomNumber = Int((6 - 1 + 1) * Rnd + 1) Me![MyEndDateRandom].SetFocus Me![MyEndDateRandom].Text = DateAdd("d", LRandomNumber, [Myenddate]) Thanks again my...

Hi Everyone I have a program that has an end date field called MyEndDate. It is formatted as a short date dd/mm/yyyy Does anyone know a way that i can return this date after being randomly increased or decreased by 6 days either way, into another variable called MyEndDateRandom. Ive tried...

Thanks Rural Guy Thanks Rural Guy I will give that a try and get back to you Kindest Regards Tony

Hi Everyone I have a database that holds all or our students details. It is on our network and is shared by several tutors. It has come to my notice that some tutors who are new to the database are accidentally overwriting other tutors records. Is there a way to check to if any of the...

Hi Sue Hi Sue Sue I will create you a blow by blow account on how to do this but it may not be finished this evening. Regards Tony

You could turn it off manually Hi You could turn the reporting off manually:- Click Tools Click Options Click Edit/Find Tab Remove the tick from Action Queries and that will suppress the annoying action query reports. Regards Tony

I dont know if this will help Hi Have a look at this http://www.access-programmers.co.uk/forums/showthread.php?p=564251#post564251 Regards Tony

A Good Solution Hi Put this into a command button, or wherever you want. I used a button called Command 16 Private Sub Command16_Click() On Error GoTo Err_Command16_Click 'Dimension the Variables Dim xlApp As Excel.Application Dim xlWkbk As Excel.Workbook Dim xlSht As Excel.Worksheet...

Useful Material Hi Have a look here Jim http://www.functionx.com/access/ Regards Tony

Hi Try this site and use the free option:- http://www.dreamsubmit.net/ It does Google for free as well as about 50 other sites Regards Tony

Does it have to be in VB Hi Can't you just open the table or query that you wish to export, click Tools/Office Links/Analyze it with MS Excel, and when the spreadsheet opens save it as a workbook. If you must automate it I think it would be easier to set-up a macro and use a Command button to...

Does it have to be in VB Hi Can't you just open the table or query that you wish to export, click Tools/Office Links/Analyze it with MS Excel, and when the spreadsheet opens save it as a workbook. If you must automate it I think it would be easier to set-up a macro and use a Command button to...

copy and paste Hi Cant you just select the table by clicking the + sign at the top left corner of the table to make it go black, right click on the black part and select Copy, open the second word document, position your cursor where you want the table to go and click Paste. regards Tony