Search results

Silly Question of the Day, Does anyone know where I can get a csv file of quotes by famous persons etc, The boss has decided that it would be a good feature to include a random quote everyday for the database users. Hawk

The reason they don't like access is that it is 1) not the most secure application We have a lot of people who like to meddle with the databases 2) we are using access 97

Thanks for that guys, certainly going to require a lot of thought. As I understand it the company I work for is wants to move away from access databases and move over to a server based system. My gut is telling me that C is more practical but that VB is easier to learn. Will ponder it as I...

Morning All, The company I work for has decided to send me on a MCDBA course and has asked me to choice which one of the elective modules I wish to do. My choices are Visual Basic .NET for Web 70-305 Series Visual C# Web Applications 70-315 Series Microsoft .NET Applications 70-316 Visual C#...

Ok, Sorted had the form on data input, Thanks for all your help :)

Ok, Am now at this stage but does not seem to building the string Dim PList As String Dim rs As DAO.Recordset Set rs = Me.RecordsetClone Do While Not rs.EOF PList = PList & "Item: " & Me.Item & Me.Product & Chr(13) & Chr(10) rs.MoveNext Loop ' clean up rs.Close Set rs = Nothing The...

Hi All I am currently building an email using the code below, ugly but it seems to work in general. the problem i am trying to overcome is the fields [DailyExceptionReportV3]![Items subform5].[Form]![Item] and [DailyExceptionReportV3]![Items subform5].[Form]![Products] only give the...

Cheers, Fixed Minor Glitch with the following change Function AdjDate(AnyDate As Date) As Date If AnyDate = ("01/04/" & Year(AnyDate)) Then AdjDate = CVDate("01/04/" & Year(AnyDate)) Else If Month(AnyDate) < 4 Then AdjDate = CVDate("01/04/" & Year(AnyDate)) Else AdjDate =...

I need to use an update query to calculate the following 1st of April for each of 3000+ records, the only exception is if the Start Date is the 1st of April in which case the date will remain the same. Examples StartDate AdjStartDate 01/03/08 01/04/08 10/09/06 01/04/07 15/04/08...

Hi I have checked and it is a General Module, also name is correct on query still no joy, I have however solved the problem with >=#05/03/2008# And Between DateAdd("m",-12,Date()) And Date() which seems to work. Thanks for your help.

Thanks for that however I am now getting undefined function in expression as an error. ??

Hi All I need to modify a date query that currently looks like Between #05/03/2007# and date()) I need to set it so that from the 05/03/08 it starts reporting a rolling 12 months Which would normally look like Between DateAdd("m",-12,Date())And Date() However as I am on leave when this...

Thanks :) Missed that one Hawk

Hi All, Have a problem with the Toolbox functions when in form design mode; they have suddenly stopped working this afternoon. For example add button no longer brings up the wizard asking about the various options, combo box wizard no longer appears. Has anyone encountered this before? Have...

Hi All I have an update query that uses the Environ("Username") command to populate a field, however I am encountering the following Issue This database in Access 2000 however the operating system various from computer to computer. The query works on Windows XP systems, but does not work on...