Search results

Hi, I have form with a subform. On my main form, there is a field "language", so I would like to dynamically manipulate all label associated to the field in the subform to change depending on the language chosen in the main form. Here is my code for a single field, but I want to be able to...

I get what you are trying to achieve here, but I want to be able to keep all the data of every month for audit purposes and not only import data that has changes. Basically, import all data on monthly basis, then like my sample database, create something that looks the query. I did the same...

Hi, Sorry, I have include a sample database with a query that I created it, but it's taking too long to load the query. Any other way to do so?

Hi, On a monthly basis, I need to load a list of client to the database. Is it possible to create a query to identify if a field [status] has been changed? or what will be the best way to do it in Access? Thanks

What is that free version you are referring to? Is it secure? My database contain many private information and wudn’t be good if the info Gets leaked out.

Each user front end is store on their local pc. The backend only store tables for data. Even just query a single table takes time when all user are in it. For testing, I went to the LAN and copied pasted a file of 30MB to the LAN itself and it went over a minute, sometime really quick. So I am...

Hi, I currently have a database that is used by multiple user. There is front-end and back-end. The front-end is stored on user local, and back-end on the LAN. However, it seems that our server is really slow that when multiple goes on it, it will slow down the database. It also happen that...

I think I know the issue. Since the listbox data has 2 same value, it will take the first one. "1PD" which make sense. How can I make the code to select the value of the listbox base on the 1st column and 2nd column? Thanks

I think it's better I post a video. See the 2nd listbox, it works. When I try to move to another selection, and I click no, it brings back to the previous selection. In the last part, when I try to move to another selection (the 1st listbox), after I press no, it takes to the first selection...

When I bound that listbox to 1 column, then it will work. But when I bound to 2 column, it doesnt not. Strange..

Hi, How do I force a listbox to select a record that has 2 columns? Here is what I am using when the listbox has 1 column: For iList = 0 To Me.lboClient.ListCount Me.lboClient = Me.lboClient.ItemData(Me.txtlboClientId + 1) Next iList But it doesn't work when that listbox...

Thanks. I was thinking the same. But by adding a new column in each of the local table: “Change_Update” which will tell if that record is “Update”, “Add”, or “Delete”. When a user delete a record from that local table, it will mark it as “Delete”, and filter it out from the subform. It wont...

Hi, I have a hard way to accomplish the following scenario. My database has front-end (stored form) and back-end (stored table). I used to let the user work directly with the back-end, but we had a lot of disconnection issue within our LAN, so I decide to download the data from the back-end to...

Hi, I am working on a database with backend data, and the form list all case in the back-end. When user open a case, it will download the data from back-end and store in local table. Reason for so is to avoid disconnection issue because the LAN is quite slow and bug a lot. Is there a way to...

I have got it.. Thanks

This is my main code that I use during that filtering: strWhere = strWhere & "([client_id] Like ""*" & Me.cboClientId & "*"") AND " How should I change this one so it works? Thanks

Finally it works!! But I though both can work because it's string..? Either " or '

Hi, I don't know where is the issue but I am having issue to display the result in my subform using the following query: Can anyone help on it? Dim strWhere As String Dim rsResult As Recordset strWhere = "SELECT * FROM tblWork WHERE client_id = " &...

Hi, I have a front end with local table data and back-end table data. The user will make changes in local table then push the data to the back-end table. However, sometime, the data pushed to the back-end was not saved for x reason. It could be disconnection from SERVER or anything so I am...

Each user has their front end that is linked to a backend database. Because multiple user is using at the same time, it tends to be very slow to access to the backend data. If i try to access late at night without anyone in it, the speed seems to be faster. The combo box is used to search for...