Search results

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...

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 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

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...

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...

I would like to make a database that is used to sign in and out so the amnount of tim spent in a lab can be tracked. I had some good beginnings but am confused about how to make sure someone has signed in before they sign out. Thanks

I would like to make a database that is used to sign in and out so the amnount of tim spent in a lab can be tracked. I had some good beginnings but am confused about how to make sure someone has signed in before they sign out. Thanks

I have a main forms and 2 subforms. When I add data to more than one I get an error that sayd eomeone else has tried to update the same record and I have to choose update or delete changes. How can I hae them so I can go into all 3 forms and make changes for each record. Right now I have to...

I have one main form with 2 other forms off it. I can move back and forth with command buttons but noticed that when I go to the subform I a not on the same record. I saw posts about Master/child links but I cannot find that option on the data tab on my form properties. I am using Office XP...

I am using a sign-in program that was written by another person. It is just an Access database that tracts time and what class people sign in for. I need to add a sign-out option for one class. Any ideas would really be helpful. I am not sure where to start. Thanks

I have 2 col and one or both may have date in it. If there is data in B I want to use that but if it is empty I will use A. I have a statement that is doing what I want for B but if B is Null and I want A all I get is Error#. What I have to do is count how many of each level and if they have a...

Can you make a report that pulls data from more than one query?

I have a database that I have given to 5 different sites and now when I get a copy of each file back I want to combine all the totals and run 6 different queries on it. I do not want to append because I still need each separate also. I started a UNION query and it seemed to be working until one...

I have created a database to keep track of students inour programs. There are 6 complicated queries I spent a long time making. I have given this to our 4 other sites and they have all entered their data. When I get all the files together is there anyway I can run my queries and reports and get...

I thank you for the reply to my previous post. I have one more. I will put up what I did: NumCompLevColD: IIf([Posttest Score]>=[Pre-Level] And [Withdrawal Date] Is Null Or [Exit Date] Is Not Null And [Posttest Score]>=[Pre-Level],"Completed Level") Okay I want this col to put the word...

How can I use more than one IIf I want to have it enforce that 2 different cols are Null and use ,= on a third col. I seem to get only 2 out of 2 working because I must be typing it wrong. I tried And I want it like IIf([field1] And [field2] Is Null And[filed3]<= [field4],"Same") I know that...

I have 2 columns that contain results of testing. I need to show whether there was a gain or loss in scores. I have a code (1,2,3,or 4) instead of the text to make it easier. I need to have my query compare the two and tell me if the difference between the 2 is > < or =. I am new to Access and...