Input mask

[mara]

Hi,

I am not too sure whether this is possble, but if anyone could help it would be much appreciated.

At the moment I have an Input Mask on my table for drawing numbers for 15 drawings per form, being >##\-aaaa\-##\-#####\-##
When the form is then completed it ensures that all fields for the number is completed. When the work is completed externally, we are sent a spread sheet which contains over a hundred of these numbers, only they only send the final 7 numbers of the drawing that are pasted into the database.
It is easy enough to correct the begining of these, but is very time consuming.
If I paste in these numbers without changing them, it alligns left so the numbers are in the wrong place. I have tried setting it to allign right, as well as reading left to right but neither put it in the correct place. Is there any way using VBA or any other format settings that when pasted will put this writing in the right of an input box? or am I best to delete the input mask?

Sorry if that was confusing, Please Help
Happy Holidays

 

[vbaInet]

Did you say they are numbers? Why the > in the format then?

If it's Left aligning then the numbers in your spreadsheet are most likely set as Text.

 

[mara]

The four "a"s are apart of an alpha numeric codeing, which in the case of there being letters for that particular part of the drawing (which gives us details on an address), I wanted them to be auto capitalised. The numbers are set as text. Because there can be letters inluded in apart of the numbers.
I was searching for a way so that when pasting in results (of only the last few numbers) in the form, these numbers are the displayed in the right spot, which was at the end, as when pasted, or typed in, it automatically moves those numbers and places them at the begining of the input mask.
I have decided to drop the input mask.
Thank you for your help.

 

[vbaInet]

It should fill from right to left. There must have been something causing that behaviour.

 

[mara]

It does, but when you paste in the results it was turning those backwards. I don't know wether it is just a bug, or whether there is something else in the settings that needs to be changed. for now it isn't that important so I'll have to play with it a little. thankyou.

 

[vbaInet]

Alright, there's no point spending anymore time on this, but if you want you can throw me a test db and I'll see how the copy and paste works on my end.

 

[mara]

Sorry about my belated reply, I am not too sure how to upload things, but it probably isn't worth the hastle at the moment. but thankyou.
Just another question if you could help?
I have a text box on a form that is used as a search to show specific results for a query. Once the query results are found, I often have 1 or 2 or 3 results out of thousands displayed on a form which shows the first result and has control buttons to navigate through. Only for each result you have to press the next buttons just to be sure there is no more results.
I am trying to find a way to put the number of results on the form, preferably showing "Result 1 of 2" ect, but am happy if I can just get it to say "3" results.
I tried a using page numbers and this code:
=DCount("*", "<your query name>")
Pasted into he control source of an unbound text box.
Would you have any other suggestions?
Thankyou so much again.

(This website seems to have bugs in it's text box? It wont seem to register half my keystrokes, Don't know whether I am the only one who experiences this? )

 

[vbaInet]

If you place a textbox in the Footer or Header section of your form, you can put the following in the Current event of the form:

Private Sub [COLOR=Red]Form_Current()[/COLOR]
    Dim rs As DAO.Recordset
    
    Set rs = Me.RecordsetClone
    
    rs.MoveLast
    
    Me.[COLOR=Blue]TextboxName[/COLOR] "Result " & Me.Recordset.AbsolutePosition + 1 & " of " & rs.RecordCount
End Sub