Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

...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 Len(strFile) > 0 Then DoCmd.DeleteObject acTable, "ASCCopyT" End If...

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

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?

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

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

thegameoflife, Thanks for your help. I have success.

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