Search results

Hi does anyone know if theres any tutorials on how to create a form in access to insert/update/delete data from a table in sql server?

I have created a stored procedure parameter query and using access created a report that runs the procedure and creates a report based on a parameter entered: 1) I wanted to know if I can specify a default paramter so if I do not input it returns all records? 2) Can I create a stored...

I wll try it out thanks what do you mean by form module? build event?

control source for venue is blank and date is set to CourseID

they work correctly and are populated with the correct data

for venue combo the row source is SELECT dbo.tblLkup_Location.* FROM dbo.tblLkup_Location this cascades to combo for date and is populated with venue after update event Me.cboDate.RowSource = "SELECT dbo.tblCourses.Course_ID, dbo.tblCourses.CourseDate FROM dbo.tblCourses " & _ "...

when I save the record the details have been sucessfully passed to the sql server, I have created a text box and d lookup on the same form and it returns the saved data, but the cascading combo boxes clear is it because there is a row source on only one of them?

I have a cascading combo box that successuflyl returns data from sql server tables venue and date, when I save the record it saves the values but when I re open the record for a particular patient the combo box values are cleared and do not display patients appointment venue and date although it...

I have a table created in sql server linked to my adp project, I have a field course_id I have a form to create new courses when I click the button I get an error saying course_id is null value, how can I program in vba so that the value auto increments when I click new course button.