Search results

  1. spacepro

    Music DB

    Hi Hay, Glad you are ok. May 24-28th is the sunny trip to scotland. Little one is ok, started to teeth now (six and a bit months old now)..Doesn't time fly. Anyway good to talk, speak to you soon and we will drop into perth sometime soon. Take care Andy
  2. spacepro

    EDI Transmissions

    Thanks for the info Pat and GSM. Andy
  3. spacepro

    Music DB

    Hi Hayley, Long time no speak, how the hell are you? Answer: I think!!! ;) Don't format the filepath as a hyperlink, store it as a text string and format the text box on your form by changing the text color to blue and underline it, so that it appears to be a hyperlink visually, then either...
  4. spacepro

    EDI Transmissions

    Hi Pat, Thanks for the reply. I currently use the transferspreadsheet command in vba to import the current excel spreadsheets, but the customer is talking about transmitting via EDI. We are setting up a project team, as this is new to us but I was just curious in what sort of format generally...
  5. spacepro

    Date Time expanding

    Ok, In the underlying table set the default values and the formats at table level Date Field > Format is Short Date , Default Value is Date() Time Field> Format is Short Time, Default Value is Time() Do the same on the form. When you click on the txtbox the date will just show and when...
  6. spacepro

    Screen shots

    Ghudson, That is an excellent utility for capture. Thanks for that. Always used Irfanview and other image editors. Thanks Andy
  7. spacepro

    Compile Error Procedure to Large

    No. I am using XP Professional and don't have any probs. I converted it to 97. Do you want it in 2000? What errors are you getting now? If still no joy i will send you my email address via PM. Andy
  8. spacepro

    Compile Error Procedure to Large

    I don't get the error message. Download the db(97 version) Here Just import them into your db. Take a look Let me know how you get on. Andy
  9. spacepro

    Date Time expanding

    Why would you be using a combo to display the date and time? And are you using the Date() and Time() functions as the default values? Andy
  10. spacepro

    Boolean Criteria

    Just put TRUE in the criteria section. Andy
  11. spacepro

    Compile Error Procedure to Large

    See the txt file attached. Just copy and paste the code into the module and try that. Andy
  12. spacepro

    Freeze pane in Excel from Access database

    Try something like: Sheets("Sheet1").select sheet1.range("B2").activate activewindow.freezepanes = true Change Sheet1 to your worksheet name. Hope this helps Andy
  13. spacepro

    EDI Transmissions

    Hi All, Just wondered if anyone has any experience of data being transmitted via EDI(electronic Data Interchange). I am wondering what sort of format it generally is transmitted in and it is something that is up and coming and I will need to amend the data import facility of my db if the format...
  14. spacepro

    Compile Error Procedure to Large

    Ok, with your current code if you move all of the code for the cmd button and copy it into a module like this: Public Function CallButton() Your code goes here.... End Function Then the code for the sub: call callbutton This will call the whole function in the same way. You will have...
  15. spacepro

    Compile Error Procedure to Large

    The reason you are getting the error is because you have defined the if statement, but not closed the if statements by using : End If I will have a look at the db to see if we can change the code to reduce the if statements. Andy
  16. spacepro

    search button

    Hi Red, To post a db, zip up the db and when you post a new thread, scroll down the page and there is a button 'Manage Attachments'. Click on the browse button, and select the zip file , then click upload. The attachment if below 100k will display in the attachment section of the post, then...
  17. spacepro

    search button

    Firstly please take my comments in a constructive way, as they are not intended to offend. One table is bad practice and design. Do a search on normalisation and db design. Secondly Queries are not time consuming or difficult.You should be using queries in some shape or form in the db. If...
  18. spacepro

    Screen shots

    Try Irfanview here It is freeware and you can capture the screen by a hotkey (f11) or by timer and it will capture the whole screen or the foreground(current window) Andy
  19. spacepro

    Compile Error Procedure to Large

    Any chance of the db to understand the reason for the code? Andy
  20. spacepro

    search button

    Sounds like you need to create a query and not a search function. You can then base the query on the report. Try breaking down your questions and solve the first part and the others will follow. Post an example if you can. I would create a query based on the fields and if necessary reference...
Back
Top Bottom