Recent content by Costefran

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