Search results

Afternoon, Some time ago i downloaded a beta version of an Access database called Time & Billing by Dreamweaver. I have found the message which provides a download link but this now takes you to a 404 Page. I am now in the situation where i need a Time & Billing application and would like to...

Hi all, I have a question concerning code that i would like to add that runs each time the database is started but is only actioned if the date matches. For example on or around the last day of each month i want some 'housekeeping' tasks to be completed automatically and in the background and...

Hi, Can somebody help me please? I use Outlook 2003 and for some reason it has started playing up. Whenever i start up, periodically whilst running and on shuting down Outlook, it does an automatic send / receive as expected. My problem is this, it is trying to send 2 emails from the outbox...

Hi, I am after some advise / assistance on a task i am about to start. Amonst many other text boxes etc on a form, i will have 2 list boxes and a text box. The user will make a selection from each list box and dependent on those selections, a single letter will be automatically put in the...

Hi, I am currently developing a database for my employer and plan to use tabbed forms in some instances. My employer has asked that the DB use the same colours used in Company literature, web-site etc. Setting the background colours for non-tabbed forms is not a problem but it appears that...

Hi, I have been using the Me.Line facility in the OnPrint Property of a report to draw (surprise, surprise) lines in my reports and it works fine, an example of which is: Me.Line (0, 978)-(0, 14300) Me.Line (1150, 978)-(1150, 14300) These draw vertical lines and using the same appraoch but...

Hi, I have the following code associated with the onclick property of a button that is (supposedly) designed to check if the Date box is empty and if it is brings up a message giving the user a choice of whether to accept the empty box or cancel the Close Form to allow them to update the...

Hi, I am attempting to implement the 'Retrieve selected items in a multiple selection box' contained within the Microsoft Knowledge Base Article 827423 to allow a multiple selection and passing of selected data to a text box. Initilly it seemed to work really well, but for some reason it has...

Hi, I have a need to include a Date in the format of yy i.e. 06 in the Page Footer of a report. Simple you would think but for the life of me i just can't seem to get it? If i have a text box with =Now() its fine, if i try to change it to Date() it asks for a Parameter Value for Date, if i...

Hi, I have been using the following code (thanks ghudson) to backup and zip a database. Public Function BackupAndZipit() 'This function will allow you to copy a db that is open, 'rename the copied db and zip it up to anther folder. 'You must set a reference to the 'Microsoft Scripting...

Hi, I have the following code which i found on another thread on this forum (thanks to original author) which is attached to the On Click of a button which prints the report corresponding to the details displayed in the form. Dim strCriterion As String Dim strMsg As String, strTitle As String...

Hi all, Thought i would put this in the Forms Forum since it has the highest number of views. This is to say thank you to all who contribute to all the forums and to those who take the time to answer / respond to my requests for info. I have learnt more in the short period of time i have been...

Hi, I have used the following code to create a duplicate record when up-issuing a certificate: Private Sub DuplicateRecord_Click() Dim sReferenceNumber As String Dim sProject As String Dim sItem_Name As String Dim sItem_description As String Dim sPart_Number As String Dim sManufacturer_ID As...

Hi, I have moved this thread from Forms to here since i think it is better suited here. Within my database i have a requirement to produce a number of invoice type reports. However because my Financial Year goes from 1 November to 31 October, so an invoice produced today - 15 November would...

Hi, I have recently been given a project at work which i will be starting soon and as a bit of forward palnning (dangerous i know) i am giving some thought as to how i will implement certain elements of it. One such element is the production of a Compliancy Certificate, this will detail the...

Hi, I have a database that produces a number of different reports by selection of a 'Create Report A', 'Create Report B' etc buttons on a form. On some occasions selection of one of these buttons may result in a number of different versions of the same report be created. At present when i...

Hi all, i am fairly new to the use of VB so (1) I am not sure if this is possible and (2) i wouldn't know where to start really so any help is greatly appreciated. I guess that in order to achieve whet i eventually want to (assuming it is possible that is) will be based on using some element...

Hi, Can anybody help me please, i suspect that this problem has a simple answer but a search on the forum didn't really answer it. I have developed a Database for my brother who runs his own business. Within this database he has a number of Tables including one for maintaining / recording his...

Hi, I currently use Bullguard V6 which is ok as an anti-virus / firewall package but it is due for renewal soon and i am thinking of replacing it with an Internet Security Suite, preferably one with built anti-spyware. Any recommendations? Any to avoid - already discounted Nortons through...