Search results

Adam The only way I know of is to use 'SendKeys' which can cause problems but personally I haven't encountered any problems with this example, more experienced users will be able to explain the issues with 'SendKeys'. I have attached a small db to show code in action, I didn't write this code...

Hi You can use DoCmd.MoveSize, here is a link to explain http://msdn.microsoft.com/en-us/library/bb238004.aspx As it explains the measurements are in twips & in your design view your form will probably be in centimetres, if you multiply your size in cm by 566.929133858279 it will give a fairly...

This form acts as a report to analyze the data in an excel manner showing cyclic patterns, it is populated from a table that only ever contains data when the form is in use. So yes this table contains repeat data on temporary basis, I felt it would be more efficient to loop through temporarily...

Not the correct way (I will use whilst I look for a better solution), but by placing an extra if in the original it works as required. Private Sub DisplayStaff() Dim rst As DAO.Recordset2 Dim strSQL As String Dim i As Integer Dim intYear As Integer SetCalendar strSQL = "SELECT * FROM...

Hello It is a Single Form & I am using Access 2007, the table contains a record showing the type of jobs or combination of jobs carried out each day in a period & on the form the textboxes represent days. Whilst at present the period is 100 days & I could represent each day by a field in the...

I have a form with 100 textboxes on & I want to loop through table records & colour the textboxes which meet the criteria. The textboxes are named 'txt1' , 'txt2' & so on to 100. The code below works to a degree but not correctly, when I use the code it changes the colour of the first textbox...

Brian Like you say it's each to their own, thanks for showing the datediff examples & the difference in 3 & 4 is the bit that bugs me with the function. The reason it became noticeable is I created a db with command buttons that act like spin buttons to select dates & the duration would alter...

Brian This is just down to personal preference, the dates all calculate from the first day after the start & include the end date; ex1: 28th feb 2010 to 28 March 2010 This calculates 28 days in March & as March has 31 days it returns 28 days. ex2: 28 march 2010 to 28 April 2010 This...

Namliam Cheers for the info, I did my own diff in the end, if the date variance is using a greater amount of days in the start month than the end month it uses the start month to calculate that month & actual days in months for the months in-between, & vice versa (I added total days in...

Namliam Thanks for the reply, I did know how it calculates the diff but it just doesn't work very well in my opinion eg. 29/12/2009 - 28/2/2010 = 1 month 30 days 29/12/2009 - 1/3/2010 = 2 months 1 day The actual gap between the dates increases by 1 day but datediff increases the difference by...

My pal has a business which operates on calendar months, but the datediff function in access can't cope or I can't get it to cope, eg. Date 1 = 28th Dec 2009 Date 2 = 1st Mar 2010 Access datediff returns 2 months 1 day, when in calendar month terms you have 3 days to end of Dec & the whole of...

Hello I am also learning, could someone please take a look at the attached db & see if it follows the rules of data normalization & if it does not could you comment as to where I am going wrong. UberMonk my apologies for misleading you. Thanks Freddy

UberMonk The error is nothing to do with the code, you could have a look at http://bytes.com/topic/access/answers/451336-problem-occured-while-microsoft-access-communicating-ole-server-activex-control. I have attached a small db with working code. Freddy

UberMonk I am not an expert but this is how i would do it, behind your command button do something like this; DoCmd.OpenForm "Issuing Form" - Opens Issuing Form. Forms!Issuing Form!Book Title = Me.Book Title - Places Book Form - Book Title data in Issuing Form. DoCmd.Close acForm, "Book Form"...

Darbid Thanks for your guidance, I spent a while messing around with the code but just kept getting more & more frustrated. So I have been trawling the net looking for outlook help, & on "http://msdn.microsoft.com/en-us/library/aa220100(office.11).aspx" I came across the GetDefaultFolder...

Darbid Many thanks for your reply, I apologize for my ignorance but I can't figure out where your code fits into the original & what gets deleted from the original? Sorry I'm a relative novice. Cheers Freddy

I have come across the following code to export e-mails into access, the problem I have is that I wish to export the inbox & bypass the folder selection process, any help would be appreciated. Sub ExportMailByFolder() 'Export specified fields from each mail 'item in selected folder. Dim...

Curtis Many thanks for your reply, whilst your post didn't solve the issue it put me firmly on the road to another solution. Now when the db opens it checks to see if Outlook is open & if it's not I have added code to open outlook minimized in the system tray, so the send/receive problem is...

I have a contacts db from which the user can send/read e-mails, the read element is sourced from a table linked to Outlook. The problem I have is that unless outlook is running in the background the outlook automated send/receive service is not running & thereby not updating the db with new...

David Thanks for the advice, it's appreciated. Freddy