Search results

Hi, I have data in a tblTemp imported from Excel, and I will need to merge them base on 2 field. If they match, then merge some other field together. Right now, I am adding the first record from tblTemp to tblData, then compare the 2nd record from tblTemp to tblData, then if the 2 field...

If the excel file is imported to access in a tblTemp then you extract all required data to a main table. Will you work on the data directly or have another field for edited data so that raw data will be still kept in the main table for future reference?

Thats what I thought too. Thanks for the suggestion

Hi, I am thinking of designing a database for the report that I am working in excel to a database. Every month we get a report with cumulated data of members. If there are new members they will be added to the excel report. My question is simply: What is the best way to manage the data for...

Thank you!

Can anyone explain the diference between: While not rs.EOF And Do Until rs.EOf ?

I have export all the data from excel to my tables tblTemp to tblData, so now, I will need to complete the clean up. There are duplicates data from my tblData that I want to delete them. However, they are not in ascending order. I Wonder if I can sort them in by field, then remove all...

When you guys export data from 1 table to another, do you use For Each field or you bring each field 1 by 1 by it's name?

Hi guys, I just have a question for most of you that have experience on it. I have a data file in CSV. I have used in the past excel macro to extract that CSV file to meet my requirement which is to keep wanted and delete unwanted rows from that data file in excel. However, I notice...

I have used VBA to calculate the whole thing. Dépends what you want to do..

I solved it ;)

Hi, I have 3 tables: tblAmount: Contains all the items and the price for each items. Item - Amount tblCommission: Contains all employee name and the pourcentage commission for each employee. EmployeeName - Percentage (Total 100%) tblCalc: I created this one to input the result...

Now the tool bugs again. I don't think it's necessary to spend more effort on this. I am now thinking of 2 other ways, can you provide your feedback? The user will have their own frontend. On the main form there will be 2 button, 1 for add data, 1 for view data. In the add data form, the data...

Yes i did.!

Hi, I have made a quick sample to check the possibilities of the problem. I have created a new database with a backend of a sample table connected to the LAN, and subform without any coding. So the data entered by the user and me will feed to the backend. The test went well and even at high...

I have a feeling that it's the LAN problem. The speed that takes to save the record to the backend in the LAN for each user. The interference of the connectivity causes that. I will be leaving on vacation this thursday, so if I cannot find the fix, I will have create 1 table per user... :/

I did not have the chance to do all that today. What I've said earlier what the experience the whole time last week and this morning until the crash. I had to stop the user to use the database to enter new data today until I find the fix.

The error does not appear when only 1 user add data. I didn't have the chance to have my user testing it yet. It's also hard for me to retest that way as my table are related to another table. I will have to manually readd all the related data which is long. I will test it tomorrow with another...

Do you think changing the continuous back to dataview will solve the problem? I did make a test, and it looks like quicker in dataview than continuous.

How about the data?? Everytime that happen, it replaces all the data into #Error, so I don't know what the user had input in there anymore. I am losing data.. Here is the last error I received: