Replies

aarrgghh!!
thanks for that input – that was what i was wanting to do, however i still can’t figure out the printing problem. i even added the “file” drop down menu with the options for Print, Page Setup, and Print Preview. (see attached file) when i am previewing a report, there are no options in this menu (comes up with a little gray dropdown with nothing in it at all). when i go back to a form, all the options are available again. there are 2 different print buttons available: one that automatically prints the whole report and one that lets you change settings (number of copies, page x to x, etc.). That is the one that i would like, so the users can change print settings. The funny thing is that only the first one stays visible for the reports. i can’t figure out what in the world is happening. Any more help would be greatly appreciated.

sorry, no different then previewed.. that’s what i meant to say. i actually came to the realization that i want the menubar for use ONLY with the report. you said something about binding a menubar to a report… how might i go about doing that? i think that is exactly what i would like to do. i did not put any code in the report to manipulate any toolbars. the only setting i changed was in the startup option to show a default menubar.

thanks in advance

charlotte,
sorry for not being very clear… here is exactly what happens: i have a custom toolbar that is the only toolbar to be shown when the db is running. it includes Print Preview, Print Setup, Page Setup, Zoom, Help, and Close. if i open the db without the startup options (holding shift while opening), i can go to the reports i have created and preview them. All of these options on the menubar are available. if i open the db normally, all of the options are visible while i am on the main menu, as well as on any other forms. i can click on the main menu option to bring up the same reports as before, however once the report is loaded, the print icon just dissappears from the menubar (the menu actually shrinks because of the missing icon). here’s the funny thing… if i hold shift while selecting the report from the main menu, the print button will still be visible for the report until i release the shift key. once i release, it dissappears. this only works this way on my machine. i have not set up any permissions (that i know of). On the main menu, i use a call to find out the user on the system and display menu options depending on who is logged in.

hopefully this cleared some things up. thanks for your help and please let me know if you can figure out what in the world is going on )

thanks

Hi Mark
I just recently used the procedure you provided to change the screen resolution. Things look pretty good, however while the resolution is changed, the taskbar at the bottom of the screen is gone, and the access screen only goes down to where the taskbar *should* be. Everything goes back to normal once i get out of access. I am running access 97 on Win2000. any help would be appreciated.

thanks

hey, thanks everyone

this compilation puts everything together into something i think i can understand. i will try it as soon as i can. i never would have thought to open the new table in exclusive mode – good idea. i will let you all know how everything works out.

i am not too concerned that much with database security. there are only a handful of people that know how to access the background of the database (using shift + click). our system now is basically one form with one table and anybody can get in to do anything they want. security hasn’t been too much of an issue yet. it is kind of in a controlled environment and gets backed up nightly.

thanks for your advice

ok,
i guess i have gotten off track a bit.. i will try to start over. what we have is a database keeping track of the job numbers we take out for new jobs (perhaps like 02005A). we have 5 principals (owners) who enter these job numbers. they must all be permitted to enter information, and i need to find out how to prevent two people from entering the same job number. right now, i have a form for entering these job numbers. the form goes out and finds the last used number, adds one to the number and automatically inserts that number into the job number field. this is working very well if only one person is entering information. there is no more than 500 or so new job numbers in any given year, so really the chances of two being created at the same time is quite low. however, there still is a chance, and i need to make sure it doesn’t happen.

here’s what happens as of now… if two people have the db open to add a number, both instances will see the most recent number, add 1 to it and give the same number. if one finishes and clicks ok to enter the job number before the other finishes (at least by a few seconds) when the second accepts the data, it will say the job number is already in use.

if they click ok at the same time, there will be two instances of the same number in the table. if i set that field to the primary key, it will add whichever number is added first and ignore the second (without any warnings). both instances are not good. i have also tested record locks to all the different settings, and i am not getting anywhere.

any more help would be greatly appreciated and let me know if you need more info. i could also probably send you the form i am currently using.

thanks again

hi,
i started to read the article you sent me to… and i must say that most of it is way over my head. i think if i jump in with both feet, i would surely drown. perhaps you might have some insight that may make this matter a bit easier to comprehend…

i do worry about your statement that you made: “But if two people have been given permission to add/edit the data, then there is nothing to prevent both of them from doing so simultaneously”. this is exactly what i mean and really the only thing i need to prevent. other users viewing certain data is not much of a concern.

thanks for helping someone with no security experience.

thanks for your help..

i printed that article out and i will read it thoroughly before i decide what i will do. thanks again for your help

thanks charlotte
i will assume you referencing the issue of “who can see what”. it seems that what you are recommending could very well work. however, i have no clue on how to do such a thing, and what i have set up works as of now. would you still suggest converting what i have done over to your method? remember, i would have to learn how to do what you are proposing.

the real issue is only allowing one user to enter records at a time.. not sure how to accomplish this. i don’t know exactly how access handles this on its own, perhaps you can help

thanks

thanks for your reply…
what i have found is a little function in “Total Access Components” (an add-on to access) that will find the username on the particular system that the user is logged in to (using Novell Network). i have a table for employees, which also includes the username each employee has. i also included what level of access each employee should have (user, principal, and administrator). my main menu checks all this and only displays certain menu choices depending on which group the user resides. i think this will solve my problem of user-level access..

the problem i have to figure out now is how to only allow one person to be entering new job numbers, and only allow other users to view job numbers and such while the first person is connected. doesn’t seem that hard, but i haven’t a clue on what to do. any further help would be appreciated.

thanks

hey, thanks
i don’t completely understand all of the first paragraph, but the second paragraph seems to work. thanks for all your help.

if i only have 2 fields (one calculating year to date times, and the other calculating last week times) everything works fine. if i drag a field (in this case “EmployeeTime’) from the table to the query design grid, it gives me the error;

“You tried to execute a query that doesn’t include the specified expression ‘EmployeeTime’ as part of an aggregate function.

the error occurs when i try to execute the query. any insight you might have would be appreciated

thanks, that does answer the first question.

now, just waiting for someone to answer the last question…..

thanks for your help

thanks for your help. i have 2 questions..

how do you use a “between ___ and ___” in this function (i am comparing dates)? access tells me i have invalid syntax or the wrong number of arguments. i am trying to use something along the lines of

YTDSubtotal: Sum(IIf([daterecorded] is between #1/1/2002# and #12/1/2002#),[employeetime],0))

but it, along with my other attempts are not working. i also would like to use now() in place of the second date, but it doesn’t like that either.

the next question is:

How come i can only display this field in the query and none of the others? i need the rest of the fields as well.

thanks for your help

hey, it works! wow, that was simple.. thanks a bunch