Search results

database splitting is the best way to go here, An splited db Would outperform a non splited database on a server hands down anytime, anywhere. It will also resolve the problem of what I call fast deployment. You would have to be sure about the structure of the back end and release a Front end...

maybe the answer on your other post can help you.

Sometimes when I face this type of problem what I do is that I define a "Dummy" Field in the query that is the record source of the report, that is, creating an Empty field in the query (see Example attached) and the SQL counterpart SELECT tblSample.Id, tblSample.First, tblSample.Last, "" AS...

You can just import the 2nd table as many times as you need it in the query screen and do the join for each field.... But, I think that the real problem is Normalization Here, for that type of Operation there shoud be a table with three columns: Table 1: Id------FailNumber------FailCode Table...

Well what I usually end up doing in these Cases is just creating different crosstab queries and then creating a query that puts all the information from those Crosstab query in one, joining the fields using the rowheader, wich will be the common set of data in the query.... It works quite well...

Yes you can get a query that portraits the information that way, use the Crosstab query wizard and play with the query a little, there is available help here and in access about crosstab queries, after some time you will get the hang of it.

You will have to create 2 different reports, one for the company info and the other for the Average info. In the Report footer of the first report insert the 2nd report. so you will always see the individual company info and the average as only one report...

first check that you are referencing the right table to append to. Second check that you are referencing the right fields to be appended.

Ok, in this case I would create a query on design view with the data in your table and set the query to group by Supplier counting the number of individual orders and ordering the results based on that count. that way you will get Supplier Product Count of Orders SUPP1 CHEESE1...

I understand your problem, I would not use the year as Primary Key though, I always use an Access generated Autonumber as PK. To answer your question, I would set up a lookup table with the companies information and the other table with the imports from excel... That is only two tables and one...

This might be what you are looking for...

I would set up another table for Comments with a One to many relationship between the table and the original Comment.

Well I have not heard anything about MS Access dissapearing from the market anytime soon.... I am sure ACCESS Is a product that produces profit, as it is, and will be around for a long time, anyway only Bill Knows that, but I guess that in a near future, JET (MS Database Engine) will be...

Working on a little template to show.... Give me a couple of Hours so we can show you the diffrence between Excel and Access...

following SJ McAbney suggestions: First Do a table with the names of the people that are going to be included on the DB. most likely you will need for that table: 1 column called lngEmpId set it to Autonumber and convert it to Primary Key 1 Column called strEmpName set it to text If there is...

Well I have used other methods to select records on subforms, including checkboxes, and this one seems require the least amount of processing power. There are many threads here about how to increase performance on a DB, most of them are just personal preferences, but there are some that are a...

Here's my method This is what I do: 1. In the subform, set up an unbound textbox, call it: txtActive 2. Be sure to include the Primary key of the record in the subform, make it invisible (let's call it txtPK). 3. On the Main field of the subform: in the GotFocus Event: Me.txtActive =...

Here's how a person that does not know too much about ACCESS (like me) will do it: 1. Design a Query for the top 100 2. Design a query for Last Record of the Top 100 Based on Qry 1 3. Design a query with records that have the same score as query 2 4. Do a Union Query between 1 and 3 There...

Keep Databases In Sync Hi Guys, This is the method that I use: Roger's Library Example In short: Database has to be splited FE/BE FE on Client's Machine, BE on File server - Nothing new Here. Master copy of a FE on the File server Also. ( This will be the current version of the FE)...

Fizzio: Thank you very much for the prompt response, this indeed does the trick!!!!!!! :D I am going to start checking on the web as to how can I over ride the Save as/ Open dialog box once the link is clicked and how to mask the link just like we do here on the forums, so the person will...