Recent content by FREDDY67

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...