Search results

Is there a way to document in access how forms, querys, tables work for users. It would be nice to create a word document in access some how with explanations.

Can some one tell me what is wrong with this query? Acts like it will not run. DELETE * FROM dbo_idfy WHERE PEOPLE_CODE_ID NOT IN (SELECT dbo_ACADEMIC.PEOPLE_CODE_ID FROM dbo_ACADEMIC INNER JOIN dbo_idfy ON dbo_ACADEMIC.PEOPLE_CODE_ID = dbo_idfy.people_code_id WHERE...

I have an MS Access that is the front end and link it to a SQL DB through the tables. I am wanting to only show the oldest date in a class year if the same person is listed more than once. Tried Min in the Total Criteria and it did not work. I can post the sql if needed.

I have a query that returns all the records sequentially some what. It will list the records like 1, 10 1000, 1001 It will jump like 1200, 12, 1201, 1202 instead of 1,2,3,4,5,6,7,8,9,10 It will list 1, 10, 1000 Any ideas? Here is the query to list all records. I have gon intot he report...

I have a query that finds duplicate records and the number of each duplicate there is, listed below SELECT dbo_INV_INFSVC.CS_NUM, Count(*) AS Expr1 FROM dbo_INV_INFSVC GROUP BY dbo_INV_INFSVC.CS_NUM HAVING (((Count(*))>1)); What I need is to let the user know if there is a record in the table...

Three tables: tblPeople, tblApplicants and tblLegislator. tblPeople PeopleCodeId LastName FirstName 1000 Smith Harry 2000 Sooner Amber 3000 Fillpot...

I have a command button that runs an append and delete query. The append query works, but the delete query does not work. I currently have this working in another form and duplicated the query's but changed the form name to it would work on this form. At a loss as to why the delete query tells...

I get this error when I am testing: I enter a value in the text box for a new record, I delete the value and try to move to another text box or move forward/ backward to another record. Error reads: You have tried to assignq NULL value to a variable that is not a Variant data type. Any...

I use this code to validate for numbers in a text box: Private Sub txtCS_NUM_BeforeUpdate(Cancel As Integer) If Not IsNumeric(Me![txtCS_NUM]) Then MsgBox "The data must be numbers only" Cancel = True Me![txtCS_NUM].Undo End If End Sub How can I change it to validate for text?? and is there a...

I am having a inout mask problem. I have a text box where a date needs to be, this is the format ##/##/##. When I put short date as the input mask I can not move off of the text box when I enter numbers into the text box

I have tow separate functions to validate for either numbers or text. Is there a way to allow a text box to get both. I want an "a" tp proceed the 5 digit number? I can post what I have for validation so far that works if needed. Bill

Is there a way to let the user know that the data already exists if they are entering data into text boxes?I want only one record of each person in the db.

I have a field titled Dorm_Plan. When a student leaves it says clear for them in the field. I am trying to display the students that are currently here. I have used Not"Clear" in the criteria for this field, no luck. Is there something better to put that would work. I want to display everything...

I have a command button that performs an update query on a table in a subform. When you click the command button and check the table that is being deleted, it works just fine. The subform still shows the data in it that was deleted in the query. Is there a way to refresh the form to show that...

I would like to hide and unhide a subform with the click of a command button. Can I create command button thru a wizard and change the code to do this? me.hide.subform name me.unhide.subform name

I want to be able to type in a text box a serial number and have in another text box a slot number auto fill. Then I want to type in an id number that will auto fill a students name and housing. I want these to be added to each other in a table.So that a particular student_id and name wiil have...

I get this error when I try to add a record.: Can not add record(s); Primary key for table_name not in recordset I put the primary key in the query but it did not solve the problem.

When you advance the record selector to a new record and only enter text in one text box rather than five is there a way to have a message bax come up and say you need to enter text in all text boxes?

I have the code to make a subform disappear, but yet it does not when the text boxes in the subform are empty as you scroll through the records. Any one have any suggestions?

How do you hide a subform when there are no records in it. If it is linked to the main form and you are scrolling through records and nothing is in the subform, how do you make it disappear. I have done this before, but have forgot how to do it