Recent content by marvin67

Thank you very much for your help. I did add continuation line but i think i miss spaces and i do not understand much this continuation thing. I followed your layout including all the spaces and it work. I have a limited knowledge about coding since i learn this stuff through self studies. I...

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

Thanks for enligthening me on this one. I have exported my tables in mysql and link the tables to my front end, but this code didn't work. I think it is something to do with adding record in the table if it has an autonumber field on it. I will try to run again the code and check what is the...

Because I am trying to move my tables to mysql server. My understanding is DAO won't work on server environment. So i have to recode my dao to ado before going to the server route.

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

Bookmark Formatting, is this possible? Hi there, I have word document template where i have multiple bookmarks. The value of the bookmarks is generated through a form. The problem I have right now since some of the bookmark are numbers in value, if the value is for example 100.00 the word...

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

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

Thank you very much for your help. That's works!!! :)

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