Search results

Hi, Lately, there was an update of an external app that we connect our access database to, so all tools need to be updated, but some user are still using the older version of that external app. So the deployment was quite painful. I am now looking to create like a hub that stores all the access...

Hi, In a form, I have more than 20 combobox, and I would like to create a function so I on GotFocus, it will automatically dropdown that combobox. Any idea how can I make it work instead of adding a code individually to each combobox? Thanks

Hi, I have a table with multiple fields as Textbox, and one of the field is set as Listbox with values and multiple selection allowed. Using DAO, I would like to iterate and pull all data from all fields, including that listbox. sTable = "tblUser" sProjId = "5" Set rs =...

Hi, I have a form with many field and I would like to know if it's possible to populate the name of that field once we click on that field? Is there any fire event that capture each time we navigate through different field? Thanks

Hi, I need to reproduce a table as per below and I would like some feedback on how to design such table? Province of Employment | Participating employees | Male | Female BC AB SK MB ON QC NB NS NL PE Federal I'm thinking 2 tables: The first one with 12 columns, one for each province + PK id...

Hi, I added in my subform about 20 fields, and I want to change the tag property of that label to match the name of it's field. Is there a way to do it via a code instead of manually doing it one by one? Here is what I use but doesnt seems to work: Dim c As Access.Control For Each c In...

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

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

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

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

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

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

Hi, I am experiencing very low performance on the form of my database that is stored in the LAN of my company. On the main form, I have a combobox unbound but query using a code such as: SELECT tbl_user.full_name FROM tbl_user GROUP BY tbl_user.full_name; Is there any difference in...

My Table 1 is linked to Table 2: [id-PK] 1 to many [Date_id] Table 1: [id-PK] - [Date] Table 2: [id-PK] - [Date_id] - [Item] I have insert the Table 1 as subform on a form, so I am wondering if it's possible to filter the subform to only display record in table 1 only those that has record...

Hi, I have 2 tables, Table 1 that log the amount of purchase at x date. Table 2 log the price at x date. I have 2 tables. Table 1: [ID] - [Date] - [Name] - [Quantity] 1 - 1JAN2017 - APPLE - 5 2 - 31JAN2017 - APPLE - 6 3 - 28FEB2017 - APPLE - 5 Table 2: [ID] - [Date] - [Price] 1 -...

Hi, If my form is bound to a table, and the form is open, I add a new record to the table that is bound to that form, is it possible to go to that new record that is just added? I tried using the below but it says no record found. I guess its normal because the current form is open and did not...

Hi, Each programmer has their own method of working with access. But I am more concern about performance and accuracy of data changes. I have a form with a command button to open another form to view all cheques that was made to that member. There is no relationship between tables. Because...

Hi, I have 2 subform, once the data is changed in subform2, it will requery the subform 1 to the current date, but my subform 2 keep bringing back to the first record. Here is my code to change the date in the subform 1: Private Sub first_name_AfterUpdate() If Me.first_name <>...