Search results

i thought i could do this in crystal reports... what you have described sounds like access...

I use Crystal Reports to report on an MS Access Database, but each week i am having to amend filters to get the data i want. I want to set up a form that pops up when i open a report, that will allow me to enter parameters for my data required. i want to filter on: Year Week Etc... I have...

ok sorry for that, i made the same mistake as usual...i assumed everyone knew what i was talking about!!! Truth is more often than noti don't even know what i am talking about :) Definitions are as follows: Teams - are the teams that will make up a fixture/schedule Fixture - a fixture will be...

I am after someone who can help me with a project, don't think it will be too difficult for someone with a bit of savvy, but way to complex for me... here is what i need at this stage.. I need help to correctly design and link up my tables. I entered the info into them as best as i know how...

I have a number of checklists for my machinery i have attached a couple of check sheets I have attached my table structure and an example of my check list in XLS format i need to track which of these checks are being carried out each week.. I have created 3 tables so far, 1 called tLine and 1...

I have a very simple database that keeps a track of line performance figures, i have attached a part of it as an example: In my lines table are 8 production lines in my log table i need to keep a track of the data, what i would like to happen: i need a form that when i open it all the...

I have a report which i am trying to format, I want every other row's details to alternate colour which i have done (See below) I also have on my report, a checkbox and a text feild (not sure if i could use a rectangle and format that instead , it doesn't do anything i just need it to change...

Hi i am trying to delete all my queries in one go, is there an easy way to do this using a macro, module please?

they are just text descriptions

I need some advice on the best way to set up a table please. I am trying to put together a downtime log, we use items referred to as “Events” An “Event” is a stoppage on the production line An Example of an Event is “A101” this would represent “Jam up on Line” I have set the table up as...

data not showing where no records I have 2 tables... tblEvents tblFMForEradication i am trying to run a query to generate the number of events that have happened for each code that appears in the tblFMForEradication table. however when i run the query i only get 17 records returned wheras...

don't suppose you have a link to the download do you?

Is it possible to do this? if so what kind of connections would i use? and how would i connect?

I am trying to build a very simple but effective database that I can use to monitor who is working where within my factory. I have set up a series of tables have linked them up the best way I know how, I dare say I have done this wrong but I have done it anyway (open to suggestions on...

i have just bought a pocketpc pda phone, and i want to use a simple database on it... 3 tables 1 query 2 forms 1 report what is the easiest and best way to use an access database on my pocketpc

I want to add a bar code feature to my database for the following reason, I want to use it as a search facility when looking up a member, each member will have a unique ID which I would assume would be turned into a barcode font. When I scan the members ID card I would like the details for...

i am looking for an outlook style planner in Ms Access for a booking sytem i am trying to put together, can anyone point me in the right direction of how best to tackle this please. I have scoured the net for samples, and have come back to the most helpful place on the net :) for more...

is it possible to have a query carry out a running total, so that it counts the record above and the current entry..... example Record 1 Total 10 Running total 10 Record 2 Total 10 Running total 20 Record 3 Total 30 Running total 50 Record 4 Total 5 Running total 55 as i said i need...

does anyone know where i can get version of this that i can import into MS Access 2003? or something which acts the same? cheers Andy

Can someone point me in the right direction of how to protect a button using a password please cheers Andy