Search results

I came a across a similar thing just yesterday, took me ages to work out but it actually quite easy! I did it in SQL Server, you should be able to do it in an Access Query though. SELECT [ID], MIN([Date]) AS MinDate FROM [Table] GROUP BY [ID] (You can use MAX() as well) Save that query, then...

yes, Do you want it in SQL or VB

Hi Nile I'd advise storing the date as a date field, access will perform calculations differntly to date fields as it will to numbers, I know the school year is different to a normal year but when your manipulating the data you can make allowances for this by perfoming calculations, there are...

Are the multiple records stored like this: Name: Dave Smith Department: TR1 Date of Entry: Jan,03,03 Amount Adjusted: $300 Date Due:Feb, 28,03 Name: Dave Smith Department: TR1 Date of Entry: Jan,03,03 Amount Adjusted: $300 Date Due:Feb, 28,03 etc.. If so I would advise, with there only...

You can't find the data acces page on the web? or the data access page can't find the database?

Thanks FoFa, I figured it out. Some of the new columns in SQL Server were of Bit data type, Access trys to pass a null value to it and that's where the conflict happens. Soultion: Make sure all Bit data types DO NOT allow nulls and set the default value for the bit data types to '0'. Then...

I have a hybrid SQL Server/Access db. The table sit on the SQL Server but I use Access as a front end. I been developing the database while it's been in use, so I have a copy of the database which I work on and the original that someone else updates data with. I've been makeing changes to the...

That'll explain why it never works for me :rolleyes: being form Manchester......do you happen to know if Manchester Uni's venue is the Academy half way down Oxford Road. I'm going to a gig on Thursday and it's ages since I've been there.

I am doing, but I'm being lazy, the rectangle covers about 15-20 text/combos which is what I'm hiding. Instead of writing code to toggle the visability of the text boxes I just put a rectangle there to hide them all.

I use a rectangle to hide text boxes whena certain condition is true (lazy I know) but it doesn't hide one of the boxes, now it just so happens that the one it doesn't hide is the PK. Coincedence? Is there a way I can send it to the back?

As an after thought, I discovered that you can set conditional formating on controls by right clicking the control.

personally I like quick and drity *for a girlfriend* probably why I don't have one! The only nice solution would be to code it, a combination the method I suggested and microsofts automation. 39 queries is really unworkable, it'll just make a mess of your db. You could probalbly work a loop...

You could create a query for each count that would give you the value and link that directly in excel?

Hey TrainMan, What you need top do is, in VBA create a recordset for each variable A B C, the code will be the same just "...WHERE = 'A'..." etc. You should look throught h help files under Recordset, you should find everything you need. There are a few ways of counting the records, one...

I don't know how to *select* files to import by OnClick, which is what I think you want, but I have a feeling the FileSystemObject will allow you to move files, at the very least it'll let you Read/Create/Delete which will have the same effect, but probably take alot longer. Here's a sample of...

I have a query with product code and name (who ordered) this is grouped so that multiple orders by the same person are simply added. I have a text field in the orders table for "Special Requirments" when the query is grouped then any special requirments are treated as a *new* group. So...

Try stickignthis into it vbcrlf (Visual Basic Carriage Return Line Feed) you can also use (I think) Chr(10) & Chr(13) which is exaclty the same thing

SQL2 = " SELECT Contract.Contract, Item.ID, Item.Description, Item.SWL, Item.DateOfLastExam, Item.Defects, Item.DateOfNext, Item.DetailsOfTest, Item.Location, Item.SerialNo, Item.DateOfManu, Item.Interval, Item.Remedy, Item.DateToFix, Item.SafeToOperate, Item.Tested, Item.FirstExamination...

I think you need sometinhg like this stLinkCriteria = "orders.supplier = '" & txtSupplier & "' AND [subformName]![fieldName] IS NOT NULL"

I don't use lotus notes but I use this as a macro in Outlook. Might work? Sub Napolina() Dim olApplication As Outlook.Application Dim olns As Outlook.NameSpace Dim myItem As Outlook.MailItem Set olApplication = CreateObject("Outlook.Application") Set olns = olApplication.GetNamespace("MAPI")...