Search results for query: *

Can anyone please help with the following I am trying open an excel application and worksheet through a function but I get the error Compile Error User - Defined type not defined. The problem is is that my code did work and now doesn't I have carried out some research and think it may be...

Can anyone please help I have recently completed the development of my Access DB and would like to load on sharepoint so it is accessible to a number of users but really not sure how to do this (being a novice) I've searched the internet and there seems to be lots of confusing information and...

Can anyone help with the following I have an unbound combobox called 'current month' with a value list of each of the 12 months. I would like to set the combobox to display the current month when the form opens as a name (not a number) so have set the format of the combobox to mmmm However when...

Can anyone please help I am trying to calcuate between rows in a query and 1. not sure that this is possible 2. If it is possible I'm not sure how to do it As sample of query results are shown below Start Date End Date Clash Ref Clash or Not Row 1 03/04/2010 24/12/2010 10...

This is driving me insane so if anyone can help that would be great I have a form which I open in acedit mode which then based on the record and user logged in I have a Dlookup which sets the value of an unbound control. The value of this control then determines if the record is editable or not...

Can anyoner help I currently have a union query which produces a time format as 00:00:00 in its results despite the fact that the two queries that form the union query produce a time format in 00:00 I'm not sure why this happens but would like to change the format back and not sure how so any...

Can anyone help with the following I have a query in which the first column is based on a start date, and end date and all dates in between. I have some ideas on how to do this but would then want to transpose this and export to excel. Depending on user seletions the excel columns of my target...

Can you please help Is there any way to concatenate values from a control on a continuous subform and set an unbound box on to the same form For example If I have a subform with a combobox 'A' set to limit to list and a default value of 'None' The user selects as follows Record 1 - 'Tea'...

Can anyone help with the following I am trying to fing a way to group records based on a reference and concatenate the results of a number of sub tables To try and explain, the select query would like like this Reference Sub table result 1994 Wash up 1993 Take out dog...

Can anyone please help. I have been trying to export data from a saved query to excel with no luck I have tried using the output to and transfer spreadsheet method to an excel spreadsheet but get a 'Null Pointer Problem in excel so I now have code which opens the spreadsheet and the...

Can anyone help with the following I have a a form set to continuous forms where the value of one control on each record should be set using a unique reference for each record. When one control produces the results, all controls on all records show the result even though they should not I...

Can anyone help I currently have some code for creating an email which works fine until I change my mind and cancel the email I was getting a msgbox pop up saying send action cancelled and now my access hangs and when I try to close access it says You can't exit Microsoft Access right now as...

Can anyone help I am running a a number of queries on one table and cannot update the records To explain I have a table with a number of fields 2 of which are start date and end date The using enters a start and end date on a form and the query is designed to pick up any record start dates or...

Please ignore my previous conditional formatting problem as I have now resolved it I have a new problem as follows I am using a Dlookup on my [Clash or Not] Control on a continuous form. The Dlook up looks up a query and sets the results for all text boxes on all records, despite the fact that...

Can anyone please help with the following I am trying to conditionally format a form text box [A] based on the results of another text box called [Clash or Not] on the same form. The [Clash or Not] text box uses a Dlookup to set ts value, which works fine In the conditional formatting detail...

Another one I am trying to identify a clash of two records based on dates As an example to explain lets say I have a car and and Record A shows That between 20/01/2010 and 22/01/2010 my wife has arranged for a service Record B shows I then want to use my car from 19/01/2010 to 21/01/2010 so...

Hello Can anyone help with the following I am trying to set the value of a text box on my form based on the result of a query I usually create a subform based on the query and then set the text box on the form to the value in the subform on an after update event So for example when I select...

Can anyone help I am trying to set the row source of a control on my form based on criteria selected in a control called [report format] but I get the message Invalid use of property I am using the following code If Forms![Under 500 Selection for Spend Report]![Report Format] = "In Progress...

Can anyone help with SQL to find the month name of a field in my query called "Date" I can find the number of the month with Month({Date]) But thought I would be able to use the following to find the month name MonthName([Date]) I get the message saying its too complex to be evaluated Thanks

Can someone help with this one I have a combo box called [name] with a list of names that sets the current date on another control called [date] on the [name]afterupdate event If the user selects a name from the list it works fine If the user uses the autofill facility by typing in the first...