Search results

Hello,, I have a code below, for some reason if i want to add the line "Order by" the code doesn't work. I'm not sure if it a syntax error. Any help would be highly appreciated Here is the code Private Sub CustomerList_AfterUpdate() With Me.ContactList .RowSource = _ "Select ID...

Hi, I'm trying to convert this code on my access database. This is a mapping code that transfer fields info to another table using a map table. I'm getting a runtime error 3265 when executing the code that points to the fields on the map as below Do Until rstMap.EOF...

Hi there, I am doing a lot a data cleansing, specifically addresses. Sometime I have database that addresses are written in a one column (i.e. PO Box 159 Queenstown). Is there a easy way to break the po box and suburb if they are separated by a single space. Checking for the last numeric on...

Hi there, I developed a job system database for our company and we've been using this for a while. I split the database BE and FE and copy FE on every workstation. My problem right now is the database is starting to run slow. I have read some article saying this "You can greatly enhance...

How can i break a text field that contains a name where each character in the name is will be on another field. eg: Firstname Marvin will become F1 | F2 | F3 | F4 | F5 | F6 | F7 M | a | r | v | i | n | Thanks

I created a new table on my front end database, my problem is i do not know how to put this new table on my backend database to be able to see the new table as linked. I try to run database splitter to do this and point to the my backend database but when I asked to replace the existing backend...

I would like to query a records to get the the records where number of character in a field is less than a certain number. For example If i used this criteria: Len([firstname]) = "8", then it will produce all the records where all firstname have 8 character. But if i used this criteria...