Search results

This approach seems compact, I'll study it. Thank you.

Thank you for the suggestions It works. However, I don't understand why " ' " as hightlighted is present at the following partly script & txtDaysNotAvailable & "',#" & txtApptStart_Dt & "#,#" & txtApptEnd_Dt & "#,'" & txtRemarks & "');"

Thank you for the suggestion. I made few modification for the script to make it work CurrentDb.Execute "Insert into tblTNewAppt (TRef, AppointedBy, RankCode, JobPosition, Company, Honorarium, Allowance, FCF_No, Budget, DaysNotAvailable, ApptStart_Dt, ApptEnd_Dt, Remarks) " _ & "VALUES (' " &...

Hi, I've a question of insert into a table with the following codes. CurrentDb.Execute "Insert into tblTNewAppt (TRef, AppointedBy, RankCode, JobPosition, Company, Honorarium, Allowance, FCF_No, Budget, DaysNotAvailable, ApptStart_Dt, ApptEnd_Dt, Remarks) " _ & "VALUES (' " & lngID & "', '"...

I don't quite understand what you're driving at. would you kindly advise on this? Thank you.

Further to add an automatic increment number into another table, I need to add the rest column values at that table as well. The script is as follows: CurrentDb.Execute "Insert into tblTNewAppt (TRef, AppointedBy) VALUES " & "(" & lngID & "," & txtAppointedBy.Value & ");". However, I got...

Thank you for the suggestion. Sorry for the misleading.

I know. My concern is that if the query is the most appropriate approach. NT100

My query is as below frmTProcessNewAppt SELECT tblTutor.LastName, tblTutor.FirstName, tblTutor.Alias FROM tblTutor INNER JOIN tblProcessTNewAppt ON tblTutor.TRef = tblProcessTNewAppt.TRef ORDER BY tblTutor.LastName, tblTutor.FirstName, tblTutor.Alias ; Note: All records in...

Hi, I've a table "tblTutor" which contains tutor's key (TRef, an automatic incremental number), Name, Address, Email, etc. and a "tblProcessTNewAppt" which has "TRef" field from tblTutor as a foreign key. "tblProcessTNewAppt" table also contains the rest of this tutor's appointment matters...

Great! It works excellent. Thanks a lot I've a question on this update. Does it also work in network environment as I've read @@IDENTITY is an alternative but can't work fine in network environment.

Hi, An access form is created for the user to add records. My code to handle the input is that once "SAVE" command is pressed, I'll use a recordset and a ".AddNew" command followed a ".update" command to save the input into an ACCESS table - tblTutor, for example. (the key of the newly...

Got the concept clearly

No. I don't think so.

Links invalid.

Thank you for the reminder, I'll close in due course. Thank you again.

I'm working on ACCESS database, I need to send out an Outlook email to different recipients with their individuals attachments. What would you suggest to do this? Is it possible to do without VBA, if VBA is used, how? NT100

No, I mean the table look of listbox in a form.

A table look of a listbox is uploaded as attached.

Hi, I wonder if listbox can be setup as a table-like structure for display values of a single column data. Best. NT100