Search results

I've applied a function (CSql) to sDept = CSql(txtDept.Value) to handle empty value in the textbox and rebuilt the sql as follows sAppt = "UPDATE tblTAppt SET ApptStart=#" & txtApptStart.Value & "#, ApptEnd=#" & txtApptEnd.Value & "#, JobPosition=" & sJobPosition & _ "...

sJobPosition = Nz(txtJobPosition.Value, "") sAppt = "UPDATE tblTAppt SET ApptStart=#" & txtApptStart & "#, ApptEnd=#" & txtApptEnd & "#, Completed=" & chkCompleted & _ ", AppointedBy=" & sApptedBy & ", RankCode=" & fraHSR & ", JobPosition=" & sJobPosition & ", Dept=" &...

I've textbox in a form which is an option for data entry. I encounter a problem of SQL update from an empty value textbox to the table with VBA. Welcome any suggestions

Thank you for SQL construct. Is there any alternative to implement the SQL? Best.

I've the following SQL and update. sAppt = "UPDATE tblTAppt SET ApptStart=#txtApptStart#, ApptEnd=#txtApptEnd#, Completed=chkCompleted, " & _ " AppointedBy=txtApptedBy, RankCode=fraHSR, JobPosition=txtJobPosition, Dept=sDept, Company=sCompany, " & _ "...

Hi, I built a main form, a private variable and a subform. If the user clicks to select from subform, I'll assign that private variable declared in main form to the value of the selected item in subform. The work is listed below frmTutor ' this is Main Form Option Compare Database Option...

Thank you for the suggestions. I decided to withdraw the use triple state of check box. It causes a lot of difficulty in implementations. Best.

I know. What alternative solutions does MS Access handle the business requirements ? Thank you

How? Have any alternative solution?

I use VBA to build a form and need it to be refreshed (to clear all controls) once the user click a option of option group in it. I can't make it work to set the checkbox to null when I refresh the form even I set the control to triple state. I've read a lot of posts and white paper and found...

That's great! main form is default view to "datasheet". However, subform can't be displayed in main form's default view of datasheet. Can I set default view both main form and subform to default view of "datasheet"?

The end users prefer the excel-like format. tblTutor -> ID, LastName, FirstName, Specialist (=key in tblSpecialty), ID LastName FirstName, Specialist 3 Carol Miguel 2 5 Tim Buffet 4 tblSpecialty -> ID, SDesc ID SDesc 1 Specialist 2...

Hi, I need to use VBA to build an interface for display the reccordset in excel-like format, it allows a selection of a particular entry in the recordset for editing and its associated one-to-many values display in a subform. I would be grateful if you've any idea/sample for this...

How come the query pops the following error. Operation must use an updateable query

I want to update "Fellow" field in tblTAvail_FPA from the records in qry_Fellow_unique I built a query update (qryU_fellow) in ACCESS 2016. That's UPDATE tblTAvail_FPA SET (FPA.Fellow = -1) FROM tblTAvail_FPA, qry_Fellow_unique INNER JOIN tblTAvail_FPA, qry_Fellow_unique ON...

Thank you for the suggestion. I need to study it. It's a good inspiration.

I have no idea on this. Your suggestion works for my situation. Thank you

I have a tblTutor(Key: TRef) and tblTAvail(foreign key: TRef) tables. tblTutor: TRef(key), FHKAM_FM(boolean type) FHKCFP(boolean type) tblTAvail: TRef(foreign key), SessionNumber I need to make a SQL to link the tables and list their columns and a boolean column, say "fellow" column (type...

"New" means "New (blank) record" in the sub-form's navigation bar. Pls. see the attached photo. The user clicks this "New (blank) record" to controls of this "new blank record" on the main form. Then I can validate the values entered in the controls. The attached photo also shows the...

I have a main form and a subform, I wanted to know what method will be triggered when i click new in the subform. I would be grateful for any suggestions. NT100