Search results

Re Kenin's post (I can't make it work) I've had a play with this and I can't make it work. Does anyone know how I can get it to output to a text box on a form. What i am trying to do is to update files in various folders on my hard drive. I can do the updates ok that's not my problem. What...

Thanks for help Thanks Lagbolt and Kenin for your help. I will give these ideas a try. Kindest Regards Tony

Hi Everyone Wonder if anyone can help with this one:- All I am trying to do is bring up one folder in access, so that I can view it's contents. The folder is called old_Files I just want to click on a text box event, and have the folders contents appear in the box. That,s it (I dont need to...

Re Filecopy My Dear Friend You Sir are a Gentleman and a Scholar. Thank's ever so much for that snippet. It works perfectly and is so simple to use. Wishing you a great Christmas Kindest regards Tony

Hi Guys I wonder if anyone can help? Is there a way of copy and pasting a file such as a Word document, Spreadsheet, or Database, from folder (A) to Folder (B) on your hard drive using Microsoft Access. For Example: If I have a Word Document with the filename Doc1, already saved in a folder...

Superb, Thanks For Your Help Hi HTH I used the following code and it worked perfectly:- Private Sub overdue_Click() On Error GoTo Err_overdue_Click Dim stDocName As String stDocName = "Overdue" DoCmd.OpenReport stDocName, acViewPreview DoCmd.RunCommand acCmdFitToWindow...

Hi Guys Wonder if anyone can help? Is there a way to control the size of a report when opening it with acPreview, so that you can control the size of what pops up on the screen when the report opens. For instance, something like:- DoCmd.OpenReport stDocName, acPreview, "fit" Thanks in...

Thank's for the code Hi G Hudson Thank's for the code it is really neat Kindest regards Tony

Thank's For Help Hi Waz and Robert That works just fine Thank's for all of your help, it was very much appreciated All the best for now Tony

Hi Guys Im' Pulling my hair out at the moment trying to get my forms to re-open in the smaller view after ive closed them. Ive tried Cmd.movesize which works ok occasionally but when you turn your back the next time the darn thing opens maximised. Is there a simple command to get the window...

Hi Everyone Does anyone know how to disable the vdu output to the screen when loading multiple forms etc. I have an annoying flicker when my main form is reloading. Thanks in advance for any help, Kindest regards Tony

Hi Everyone Does anyone know how to disable the vdu output to the screen when loading multiple forms etc. I have an annoying flicker when my main form is reloading. Thanks in advance for any help, Kindest regards Tony

Hi Everyone I wonder if anyone can help me with code that i can use to copy a single record from table1 to table2 that i can use in a subroutine. Thanks in advance to anyone that may offer some help Kindest regards Tony

Re Reports Hello my friend Thanks for your reply. I took your advice and put the contents of my form into a report and it worked well. Then I closed the database, reopened it and the Report margins had defaulted back to 24.99. Any more ideas? or do you think that I might have a glitch in my...

Hi Everyone I wonder if anyone can help me please. I have a form that nearly fills an a4 sheet of paper when printed. For this reason I have to set the margins from 24.99 down to 5. This is ok and the form works well and prints out properly about 75% of the time. Occasionaly when I open the...

Good day to you all I am calling the search replace dialogue box by clicking a command button. Screen.PreviousControl.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 Is there a way to dictate the size and position on the screen where the box will open. I have tried...

Hi Everyone I am setting up a database for someone who is not very computer literate. This being the case I am trying to automate as much as possible. Is there a way to create say a Command Button with some sort of On-Click code where I can call for the Mailmerge Wizard. Even better would...

Brilliant Thankyou Col and Scott for your help. I have been able to form an input mask, but for both quickness and simplicity, adding < > to the format property works just great. Kindest regards Tony

Hi Everone Is there a way where you can set the state of the caps lock when entering a text box something like Me![box1].capslock = true. Really appreciate some help with this one as i am struggling. Kindest regards Tony

Hope this may be of help to you Hi Colin For a practice run:- Open the database select Reports Button Select New Button Select Label Wizard Select your Table or Query from the dropdown box Next the first label that is offered to you Next the Font Type and size offered to you Double click the...