Recent content by mb1980

Hi all, I have created a database and rather than use a FE/BE for different users there is only myself who modifies and another set of users who run reports) I have set it up with a switchboard for me :) and a form I have designed for the reports. Now the way I have worked it is that I have an...

Ok it seems making my own from switchboards is the way to go, can you possibly point me in the riht direction to do this. Sorry if im asking silly stuff here, im just a bit stuck. Thanks :)

tbh I would like to stick with switchboards atm until im more competent, is there a way of having a different sboard for each fe ? Many thanks.

Hi all. I have set my database up and have a nice switchboard setup for myself. Now what I want to do is give other users access to this but with a different switchboard. I have set up a front end back end with 2 fe's now I thought ill change the sboard in one fe and that will be hunky dory, but...

Thanks. Im not quite sure how to do this tbh :(

Hi. I have setup my database and switchboard, on my switchboard I basically have 2 areas, Amend/add and a reporting area. I am hoping to be able to create another switchboard just for the reporting side of things and maybe password the amendable part off. Is this possible?? any ideas how to do...

I am running a report from a query that has 2 yes/no fields in it, The report pulls through all information for the first field when at yes, what I am after is a total for each field so that it totals up every yes, if that makes sense lol. Example the first yes box has 20 fields pulled through...

Just to advance it a bit, is it possible to have a drop down menu instead of typing in? I would ideally like to have the field list I am choosing from and also another field shown, example the code for which I am reporting on and also the description of this code.

I have everything setup how I want it on my database, now what I really need is to be able to design one page where I can access everything from, my forms, reports etc so that instead of going through all the different parts to input things or run reports it can be done by different users by...

Yes indeed, thank you very much :) that has sorted it for me and I have exacly what I want. Much appreciated

SO!! Joke :) I could do with some advice though as I am a bit stuck with this basic task lol, at the minute I am running a report from a query and just going into the query and changing the one field to run each report, ideally what I need is to open the report and choose the field I am changing...

I am running a report from a query and I am looking to be able to select the criteria in the query when I run the report, if that makes sense. Basically I guess I want to be able to type in the criteria to run the report off instead of going in and amending the query every time I wasnt to change...

Is it possible to pull a record from Access to microsoft access task? ANy answer on this would be appreciated :)

Hi, I have setup a report to run from a table I have created, now what I want to do is set this so that I can choose to see only certain items on the report, example: I place order details onto the table and want to view one order on the report, how do I set it so hopefully I can choose which...