Search results

Damn I can type today.

Sorry, I should tell me reasoning for this. I work at a school, and I get the job of building db's. I buidling one for a program that wants to be able to track all their students. It going to work as an attendance sheet as well. They want to be able to schedule students, and track the attendance...

Exactly, I guess I just didn't know how to ask that.

I have a table, and form built. What I have is, two text boxes to allow the user to enter the Begin Date and the End Date, I also have check boxes that allow the user to select the days of the class. After they enter both dates, and select like MWF or TTH, have a generate schedule button. I need...

I am trying to figure out a way to schedule date. I need to be able to have a begin date, end date, time, and check boxes to select the days of the meeting. I basically want to take a student, put them in a class, enter the begin date, end date, times, select the days of the week, and have it...

Sorry for not explaining better. I didn't get a message box with an error number. I continued to get "The changes you requested to the table were not succesful because they would create duplicates values in the index, primary key, or relationship. Change the data in the field or fields that...

MsgBox DataErr did not work still recieved the same message. Thanks for the info on the composite key. That makes perfect since.

I have a table with two primary keys, SSN and EntryDate. From a form, I want a custom message box that tells the user that an applicant has already been entered, and not the long default message that access uses. I am using Access 2002 with the 2000 file format. I have tried a lot of stuff, but...

I have a report that has one subreport. On the subreport I have a text box that will count the records in that subreport. I have a control on my main form that pulls that number out of the subreport. This works fine until I have a subreport with nodata, and then my text box displays #Error. I...

I need help with code. I am just learning vb. I have a form named frmCustomers with a subform names subfrmTrans. In the main form I have a check box that I want to control the locking and unlocking of the subform. I can write code that will lock text boxes in the main form, but cannot figure...

I need to know how to open a file(same name and location everytime) word or excel with the click of a button on my form. I have limited VB and have tried eveything that I can think of. Any help will be greatly appreciated.

I have a subform that is based on a query that filters check boxes = no. I want a command button that will "refresh" the form and display any record that was not checked yes. I have tried many different things only to run into a brick wall. I know very little VB. All the tricks I try are...