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 derfloh 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: pmo
  • Order by date
  1. pmo

    Return to First Record After Cycle

    Thanks AceMan1...You are brilliant. It works perfectly. Thanks for your help. I don't necessarily fully understand the code...but it works.
  2. pmo

    Return to First Record After Cycle

    Thankyou. All is working well, the database moves to each record in order then starts at the beginning when required. Is there a way that the VBA can be changed so that the next record that is chosen is random and not in the order of the query that feeds it? Whilst it works this would improve...
  3. pmo

    Return to First Record After Cycle

    Thanks PHV and TheAceMan1, It works perfectly. I would like to think I could assist you one day but at my skill level it is unlikely. Thanks Again
  4. pmo

    Return to First Record After Cycle

    Thanks TheAceMan1, I am not even sure how i would put your suggestion into a macro. I have workied out how to create a procedure..It looks like this- Private Sub Form_Timer() DoCmd.GoToRecord , , acNext End Sub How would I add the line that checks if it is the last record than returns to the...
  5. pmo

    Return to First Record After Cycle

    I am very green with access and really only using macros at present. I am wanting to cycle through all of my records in form view. I have been able to do this with a simple GotoRecord Next on a timer. The problem is when it cycles through all records I get an error because it is at the end of...
  6. pmo

    Export to a spreadsheet file won't work

    When I export using the outputto function in my macro it works fine until I click the "show database window" in the startup screen. I don't want the screen to show in my database but when it is not shown I get an error and the macro can not be run. If I show the database window everything works...
  7. pmo

    How do you add numbers in a text field?

    Zameer, Thanks for offering your help. I may have sorted out the problem. My field was a mixture of numbers and letters. When I attempted to add there was a mismatch because of the numbers and text entered. I have filtered just to include the numbers and it is now happy to add up. Thanks...
  8. pmo

    How do you add numbers in a text field?

    My field is set as text as depending on the entry a number or a letter may be entered. I would like to run a query that adds the numbers together for a particular field. Thanks for your help...
  9. pmo

    Memo field truncates to 255 characters

    Dhookom, Thanks for responding to my problem. Since commencing this thread further investigation has shown that the table in which the query was based only included information that was already truncated to 255. This appears to have been created when using an output macro to an excell...
  10. pmo

    Memo field truncates to 255 characters

    My memo field in a query is being truncated to only display 255 characters. When this query is used in my report the same thing happens. The field is set to memo in the table. Can anyone help please? Wayne
  11. pmo

    How to check if a table exists

    Roy, Thanks for responding. I was substituting "tblName" in the code for the table I wanted to delete. All works now. Thanks also ByteMyzer. Wayne
  12. pmo

    How to check if a table exists

    ByteMyzer, Still having trouble. Your help would be appreciated. This is what I have at the moment:- Public Function DelTable(ASCCopyT) For Each tbd In CurrentDb.TableDefs If tbd.Name = tblName Then CurrentDb.TableDefs.Delete ("ASCCopyT") End If Next End Function I get an error that says...
  13. pmo

    How to check if a table exists

    Thanks ByteMyzer, I will give it a try. My knowledge of code is limited but this is of great assistance. Thanks Wayne
  14. pmo

    How to check if a table exists

    I am wanting to delete a table in my database if it exists. I am able to delete the table if it is present but errors if it is not present. My code so far is Public Function DelTables() strFile = "ASCCopyT"**********I need code here that identifies the table*************** If...
  15. pmo

    Can't edit subform

    LittleSmudge, Thanks for the information. I now understand. My database does exactly what I want it to do..for now. Thanks again. PMO
  16. pmo

    Can't edit subform

    LittleSmudge, Thanks for the information. It works fine. I tried part of this previously but with little success. I was leaving out the .Form section of the code. What does the .Form mean or do?
  17. pmo

    Can't edit subform

    I have a form called "ParentF" with a datasheet subform called "ChildSubF". "ChildSubF" has all allow edit,filters, deletes etc set to "yes". My "ParentF" has allow edit set to "No". On opening, both parent and child forms aren't editable which is the way I want it. I have created a button and...
  18. pmo

    User Name to appear on a form

    Dean, Thanks. This is exactly what I have been chasing. Wayne
  19. pmo

    User Name to appear on a form

    thegameoflife, Thanks for your help. I have success.
  20. pmo

    User Name to appear on a form

    Thanks "thegameoflife". My knowledge of code is almost nill so I had someone work through your email with me. Apparently your function will retrieve the computer logon user name. (Is that correct)?? The one I am chasing is the user that has logged onto the sucure access database. I...

Part and Inventory Search

Back
Top