Recent content by ya5irha55an

Hi all, i hope someone can hlep with the following: I have a table like: Date 01/01/2005 10/06/2007 12/12/2004 01/03/2006 02/03/3006 I would like to create a query which calculates the difference between the date in each row and the date in the previous row. So the difference between date in...

Yes, all fields are set to double- still no luck.

Hi All, I hope someone can help me with this odd little problem! I have a query with 2 fields, one called 'list size', which contains 4 digit numbers, and another calculated field called 'list size per 100', which has the simple formula '[list size]\1000'. The problem is this field rounds the...

Hi, I wonder if someone can help me with the following problem: I have a table with 2 columns,start time and end time, both containing time values in a four digit format, eg 0930 being 9:30am etc. I have made a query to convert these into the standard format (eg 0930 becomes 09:30), using...

Hi, I wonder if someone can help me with the following problem: I have a table with 2 columns,start time and end time, both containing time values in a four digit format, eg 0930 being 9:30am etc. I have made a query to convert these into the standard format (eg 0930 becomes 09:30), using...

Thanks- I am planning on startgin to learn vb.net soon, was hoping it would be similar at least to VBA, I hope its not too different :( If anyone can suggest any books, websites etc I would really appreciate it!

Hi all, I am a VBA in Excel/Access user, to a pretty high standard and am wondering how much of a jump learning other VB languages would be such as .NET or VB itself. Could anyone advise? Thanks in advance.

Hi, I hope someone can help me out with this problem: I have 2 tables with identical stucture, and no unique ID number. Both had identical data, and the databse was then copied onto 2 laptops. Now further data was added onto each. I want to now merge the three databses (ie original one, and 2...

Thanks, thats works perfectly!

Hi All, Sorry for this question, I know its simple but im not very experience with Access: this question is exectly what I am looking for, I also have an autonumebr which I would like to begin from a number other than 0, but I am not sure how to use this code, where do I put it?

Hi, I am hoping someone can help with this problem. I have a table which has an autonumber field, set to increment by 1. I would like this to start not from 0 but from, say 1000. Is this possible? Thanks in advance!

Not quite- I dont necessarily want their to be no duplicates, but I want there to be a warning if a duplicate is being entered- most of the time this will be an error if someone is trying to add a code which is already there, but not all the time. Thanks anyway tho.

Hi, I have the following problem which I hope someone can help me with: I have a form which is used to enter data into a table. One of the fields is 'Code'. I want the form to check when data is enetered into this field is it already exists, ie if the code is already present in the 'code' field...

Hi, I have a form which is linked to a table. The table contains the field 'Code'. The form is used for entering data into the table. I would like to write some code so that when the 'Code' field is filled in, it checks if this code already exists in the table, and if it does a message comes up...

Thats brilliant, thats a lot! One further question, having done this i have noticed that the time values in my original table are not all in 4 digit format, eg 07:00 is 700 but 12:00 is 1200. Is there any way for me to do a count of characters, so i can adjust the left/right functions to...