Search results

Ok i will try cleaning up the code a 100% hope fully it will work after that :) Thank you

not all of it there might be a module or two that wouldn't compile, but if i fix that would it work? Cheers

Hi there, I am getting an error when i try to make an MDE file I have a database that is split into forms and back end tables. I get an error that i have too many forms or modules( i only have around 30 forms) , is there a limitation to the number of forms or module you can have in order to...

Sorry guys, my mistake, it worked both way , i was getting that error as i had not removed the old indexes. Cheers , much appreciate your help:)

Tried doing that, and it doesn't work, i have unique index on the combination of the 2 columns and i tried keying same data in the first column and different data in the second column, but it gave me errors :confused:

Actually i have 3 columns in this table, i can not make a natural PK in this table as it would have to be a composite PK made up of all 3 coloumns, the problem is in some records the value in the 3rd column is null, and can't use a combination of the 1st two columns as they are repeats in few...

Hi there, I have a table, where the PK is an autonumber, but i also want to put a unique constrain on a combination of two columns to ensure that someone doesn't input the value(combination of the two columns) that all ready exist in the table , is this possible in access? Cheers

I Just read up on the nz function on the MSDN and and a few other sites and i still didn't get it until i read your last post,you made it clear. :D thanks again

Hi duluter, Thank you so much this is exactly what i was looking for, so just that i understand the nz function will return a 0 even if the record does not exist for the employee? as i am starting out in access and don't have much experience with access would you recommend a good book on...

Hi Everyone, I have this sales tracking dB where i track sales and return for the ee's , I am trying to write a query where i would take the total sales for the month and the total returns(returns categorized by electronics and non electronics) and work out a %(i.e. in the dB employee DBOS has...

Hi Bob, Many thanks for your help, after playing around for quite a bit i finally got it, initially i had added just the Mechanics and Car_Service Tables in the Design view of query. It showed the two links initiated by and completed by from car_service to the mechanics table then i tried your...

Hi Bob, I tried the query below and it gave me weird result SELECT Mechanics.First Name,Mechanics.Last Name, Mechanics_1.First Name,Mechanics_1.Last Name FROM Mechanics AS Mechanics_1, Mechanics INNER JOIN Car_Service ON(Mechanics.Mechanic ID = Car_Service.Service Initiated By) AND...

Hi Bob, Thank you for the quick response i will try the query tonight and see if i get it right, ,its good to know that help is at arm's reach Cheers :D

Hi All,:confused: Can anyone please help me understand out of the two schema's which one is correct or are they both correct, which one will be easier to write SQL queries against, i tried writing an SQL query against Schema1 that would give me the CAR ID, Service Initiated By's first, last...

Makes sense Is the model i made ok though or is there any other way to store the data? Thanks again

Hi there, I am practicing database design , and i have come across a situation in a practice database that i am designing where i have 3 tables , EMPLOYEES, TEAM_MANAGER, SALES and i have a report for total sales for each team manager for each month. Initially i had one to many relationship...

Thanks guys This is great help, i better start reading on that Cheers

Hi Bob, may be i did not explain properly, in order to keep the data current wouldn't i have to run the query each time, or does the query refresh itself, rather than manually running the query , i could say maybe have it updated as soon as i open the a form or the database, make sense or am i...

Hi there, Thanks for the quick reply, so i guesss than i will have to write VBA code to keep the queries udpate? Cheers

Hi there, I am developing a new dB and i am trying to link a table from an existing database, my problem is that the table in the existing database is not normalized, so i am trying to normalize the table in the new database and link fields from the existing table, is there any way that access...