Search results

I will try to have an index for the case_status and see how fast it will be. Thanks

If I force to get all data to the combobox On Load then the time to load the form will be too long+new data are added to the table. So I have to requery the combobox every time which wont help the issue.

Right, I have removed the GROUP BY and it does help a bit. But I have another combobox with "case status" which group all the case status of a table linked to a back-end. In this case, I need to use GROUP. When I click on the combo box of the "case status", it takes about 25 secondes to show...

There is no indexes on full_name.

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

Right, but the date is generated automatically, and the items is only if we have orders. Unless I supress the date on daily basis which I don't need I need to since it doesn't impact anything, except creating useless record, but I might need that date in case of retro items.

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, Sorry, I have missed the info that I need to populate to a control in order to use it to Link Master Child subform. See attachment.

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

Great to know that!! :)

I did try to add a new record using that same command button then go to that new record, even with a Me.requery after adding the new record. Still doesnt work. Any idea why?

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

The form is already boundsd to a table, but then use filter to pull all cheques related to that member. At the same intance, its multi uset envrionnement, another user can also perform the same thing on another member. So we will have 2 user accessing the same table located in backend, but use...

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

The only issue with using a .bat is the user is able to know where the main file is saved. That's why I don't like using .bat, I rather integrate code within my front end to lookup in the backup for version, if there is a new version in the backend, it will copy the new version of the front end...

I figure it out by recalc the subform after the requery then reposition the cursor.

It doesnt work. There is a main form with subform1 and subform2. The after update of a field in subform2 will update the field in subform1 and requery the subform1. The cursor in the subform2 will move back to the first record which is not what I want.

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

I have though about this but the database is used by multi user, 50+. It might have conflict to save the data back to the LAN by multiple users.

Hi, I have created an access database with linked table to a backend database using DAO code. We are in discussion to move the backend table in the LAN to mySQL server, so I am wondering how thag works? Will my DAO code will still work? or I have to modify all my DAO to ADO? Because we are...