Search results for query: *

The Excel object library is now selected and it works! Many Thanks

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...

Thanks I'll give it a go

dhookum Thanks for your help so far I have now created lists on my sharepoint site by exporting them and then linked the tables. I now have issues with my main table / form as well as others as although the linking seems to work fine I have problems with autonumbers My main table / list (now...

Thanks Unfortunately my organisation will not allow a network share which is the reason I am trying to run this from a sharepoint site

Many thanks I have Access 2003 I have tried to upload the access db to my sharepoint site but get the message that sharepoint will only upload files with approved extensions If I have to set up linked tables will it still work Thanks

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...

Okay I'll try that Thanks for your help

It's being used to set the value of a text box called first date and then run a calend as per faq 702 - 838

The combobox is unbound Perhaps I'm doing this in completely the worng way so thought that perhaps I'd explain what I am trying to do I would like the user to be able to select a month from an unbound combobox but when the form opens I would like the combobox to display the current month

Here is my value list January;February;March;April;May;June;July;August;September;October;November;December My second comment has a copy and paste error so apologies I currently have the following in the forms on load event Private Sub Form_Load() Me![Current Month].DefaultValue =...

John I have tried your suggestion in two ways The first being this Private Sub Form_Load() Me.Current_Month.DefaultValue = Format(Date, "Mmmm") Me.Current_Month = Month(Now()) End Sub The combobox shows the number 4 The second as this Private Sub Form_Load() Me.Current_Month =...

Excellent and many thanks

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...

Apologies as I din't explain very well I want to have a result that produces 2 or 0 based on the formula so I could have a count field that equals 2 if the formula is satisifed then count = 2 For example Start Date End Date Clash Ref Clash or Not Count Row 1...

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...

Thanks for this to explain further, the union query is then appended to a table which is uploaded to an exel temple. The excel template then carries out some conditional formatting based on the uploaded cell against a fixed value So if(uploaded cell > fixed value,1,0) Because the uploaded cell...

Here is the SQL for my first query SELECT [14 Day Outlook Fields Table].Reference, [14 Day Outlook Fields Table].[CAP Training], [14 Day Outlook Fields Table].[Template Created Count], [14 Day Outlook Fields Table].[Start Day], [14 Day Outlook Fields Table].[End Day], [14 Day Outlook Fields...

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...