Search results

Clearing form info I tried that yesterday and it did not stop it.

After informations is entered and a button is clicked to submit the information I can use the back/up arrows and page up to see what was entered even though the form is cleared. Is there something in the properties of the button that is clicked to submit that will make it impossible to see the...

Page Up and arrows displaying previous info I tried setting Data entry to Yes but it did not work. The back arrow, up arrow and pagr up all do this. Thanks

Form Prob Thank you Larry I will try that whenI get to work today.

I have a database that keeps track of vositors to our center. A student recently complained because after signing in he hit pageup and his social security was displayed. Students enter thier number and pick a subject and class from drop downs and thenclick sign in. Is there something I can...

I only posted it in the other spot when I realized only certain types were not working and I thought it might mean something different.

Hiding Queries Yes I did try sys and usys and checking that system files are not displayed. This is quite frustrating. Thanks for trying.

Hiding Queries Yes I have checked hidden. It seems only the crosstab queries are showing on the wizard list. I may delete and rebuild them. Can't think of amything else. Thanks

I am having a hard time hiding only my crosstab queries. Select queries are fine but the crosstab seem to be hidden until I look with create a query with wizard and them they are on the list. Any ideas? Thanks

I am trying o secure a DB before giving it out. I have unchecked hidden files and set the properties for all my queries but a few still show when I use query by design. Why do some work and others do not? Thanks

Thanks so mush. This is exactly what I need. I will now read the security stuff. Have a great day!

Much thanks to you both. I will try it when I get to work in the morning and let you know. Since you were so kind to answer this may I ask you about another post that has had no replies. I want to protect my coding on queries and reports when I put my combine DB on the server. Can I do this...

Thanks for the help but unfortunately you are all WAY over my head. I have never used a modual. I was thinking I could put this in box on the report so that I do not have to update 4 times for 6 databases. What exactly would I do ceate a module and then just put the name of it in the box on my...

It sounds likt it will but I must be missing something. I get an error saying Access does not recognize =GetCurrentDBName() Thanks for your time

I have 6 users that I maintain DB's for. If I want to change a report I have to copy it into each and change the name of that location each time. Is there a way to use a command like you do with dates to have the file name in the header automatically? Thanks

I made a DB that is used by 6 people. At the end of the year I get hem all back and use a combine query to add them together. I want to secure my queries and reports so no one can view my code but they can print a report if they want. I have 4 built in reports that I would like to limit but do...

I tried that and that is how it is set. Any other suggestions?

Why would I get dumped out of Access when I try to run a query? It runs if I am in a zipped file and it is read only but not when extracted. all other queries are okay.

I am updating a database that I made awhile ago. I have been zipping and emailing it and it is usually read only till I extract it but then is okay. Now one query will not run it dumps me out of Access and I see a file clled locked-record with the files name. I have tried deleting and remaking...

How do I seperate in and out? Is there a way to pop up a mesage if they click sign out and have not signed in? What about more thanonce ina day? thanks for your response