Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Costefran
  • Order by date
  1. Costefran

    Compile Error User - Defined Type not defined

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

    Compile Error User - Defined Type not defined

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

    Access DB on Sharepoint

    Thanks I'll give it a go
  4. Costefran

    Access DB on Sharepoint

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

    Access DB on Sharepoint

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

    Access DB on Sharepoint

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

    Access DB on Sharepoint

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

    Set current month on Combobox

    Okay I'll try that Thanks for your help
  9. Costefran

    Set current month on Combobox

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

    Set current month on Combobox

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

    Set current month on Combobox

    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 =...
  12. Costefran

    Set current month on Combobox

    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 =...
  13. Costefran

    Set current month on Combobox

    Excellent and many thanks
  14. Costefran

    Set current month on Combobox

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

    Calculate against dates in rows in a query

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

    Calculate against dates in rows in a query

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

    Forms not editable

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

    Format time in query

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

    Format time in query

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

    Format time in query

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

Part and Inventory Search

Back
Top