Search results

I am just after abit of advice. I administer databases for my company - (SQL Server with MS Access Front End). Quite often I receive calls from users regarding a Reserved Error Message they receive when running reports. Is there anything in particular that would cause such as message? Thanks...

I have set up a query that includes: An assignment start date An assignment end date and in addition a column has been set up to show me a Start Date where Assignment End Dates are Null i.e all live assignments. When I enter a date only results for that particular date are visible. Can...

This may well be a simple question. I have set up a Form to report Client acitivity by department Code for a given month. Users have the option within the form of selecting a Department Code. These department codes are derived from a department Code Table and set accordingly within my Row...

i am using access as a front end to SQL Server 2005 and link tables via ODBC. Today when I run a query (normally works fine) I receive an ODBC Failed message box. I have tried opening each link table connected to the query and can open fine. can anyone suggest other reasonf or this failure?

Within a query i am trying to run historical pension values based on 3 fields from a table: Value Year Period Period: Is aligned with the accounting year April to March rather than Jan to Dec. So I cannot define Year as 2005 and period 1 to 12. I am looking to define year as 2005/2006 and...

have set up a header in a report to pick up address details from a query. The formula I have written works fine for all but one field: Job Title. The only field that may contain null values. If job Title is in use then the report works fine i.e Mr Joe Bloggs Company Director Access Ltd...

Having one of those days!!! I have a simple query populating fields from 2 tables and would like to add a further field to my query (not in tables) In this field I wish to hard code in 2 values. Can anyone suggest the best way of doing this? Thanks Paul

Thanks alot

Wondered if someone could assist me. I am exporting a query into a .csv file using the following: Private Sub Output_To_CSV_File_Click() On Error GoTo Err_export_Click Dim AString As String AString = "Export_Occupancy_" DoCmd.TransferText acExportDelim, "", "ChildCare Vouchers For...

Thats great thanks

Doc: [doccode] & "" & [docnum] doccode and docnum being the 2 seperate fields

I have 2 seperate fields within a select query (In this example Field 1 - Country and Field 2 Number). I have combined the 2 together into one field. However a space appears within my results i.e Field 1 Country Field 2 - Number ----------------- ------------------- England 4 USA 10...

Its seems as though no MS expression assumes that an age calculation is based on a 12 month cycle. The result I am actually looking for is for example: Date of Birth = 01/12/2004 Age In Years = 1 Age In Months = 1 Age In Months is calculated against todays date and based on assumption...

Sorry i meant how and where to add the function? So that i can recall from The Select Query.

Sorry never done this before...I have my code, and now need to add a function? How do I do this? Once function created, I recall this via the Build option in my select query is this correct?

Ok stupid question time :-) I have an existing Select query and wish to include these calculated fields. How can I install this code within my select query? Thanks

This is true, however I do not wish to use VBA for a simple Select Query and having read through the other example this just confused me :-)

I have a Date of Birth field in format DD/MM/YYYY and wish to set up 2 new fields one that calculates Age in Years and another that calculates Age in Months. Thanks

Sorry what I mean is that my database contains alot of VBA and I worried that by Copying and Pasting I will lose or disrupt most of this

thanks for your reply. Is there an easy way to import tables/Queries/Reports and Forms apart from Copying and Pasting? thanks