Does anyone know of a function or other solution to remove a set number of characters from the end (right) of a string. The string as a whole has no set length. the only thing that is consistent is the last 3 characters. I wish to remove the three characters and...
this is the code where the NumLock is being toggled:<br><br>Private Sub Form_Resize()<br>SendKeys "{F9}", False<br>End Sub<br><br>Here is the code in the other place where the Sendkeys is being used Here the NumLock Blinks but stays on:<br><br>Private Sub Form_Current()<br><br>If...
Look at the query in design view. For each column in the query there should be a line for criteria. The line below that has an "or" label. Make sure that both criteria for "Date shipped" and "Status" are entered on the criteria...
I'm using the following line of code with the desired results hopefully a refresh on whichever form happens to be open:<br><br>SendKeys "{F9}", False<br><br>Seems to work great however it also toggles the NumLock.<br><br>Anyone have ideas as to why this may be happening?
Ok I should be able to import an excel spreadsheet into access by using the File...Get External Data...Import...<br><br>Problem1: Excel is not one of the file types I can import<br>Problem2: When I go to add/remove programs and try to add excel as one of the import items the check box is...
Ok I see how this could work and I'll try it but before I do, one question. The recordset that I open it should be a query that selects only the record I want "copied" yes?<br>
I need to know if there is any way to take the data from an existing record and create a new record with the exact same data. The only info that would change is the primary key which is an autonumber field.<br><br>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.