Search results
-
M
Report showing "ID" not name
Employee ID is autonumber (so that will do it, itself) Employee Name is employee's name..... How do I "add your employees so that the ID in the table is the same as the Employee name"??? (I'm confused for some reason.... thanks for the help.) -
M
Report showing "ID" not name
Is the Employee ID set to Autonumber? I can't set the name. I'm just confused on when it says "set the Employee" to autonumber.... on the table... is that the EmployeeID? Thanks. Melanie -
M
Report showing "ID" not name
The field in the schedule table is a lookup field for the employees. -
M
Report showing "ID" not name
No the field is not a lookup field. (WRONG! my bad!) -
M
Report showing "ID" not name
Here is my report: The employee field is in the header so the report can group by employee. (I'm not seeing any option to change the bound column) -
M
Report showing "ID" not name
I have an Employee Table with the employee's ID, FullName, etc. I then have a table that pulls in the Employees Name, then they schedule after that with times, etc. I then created a query to pull each employees name, then their schedule for a specific date. Then, from the query, I made a... -
M
Query Patient names and list appointments
I have a table with the following fields: Patient | Appt. Date | Time Staff goes in and puts in the patient, apppointments and times. Some patients are entered more than once as they have more than one appointment per week. (The patient will be entered in a separate record for each separate... -
M
Macro to update dates in table (add 7 days)
ahhh.... Thanks for the info. always good to learn from mistakes! -
M
Macro to update dates in table (add 7 days)
I think I have it now.... disregard my questions. I am going to have them run an "update" query on the Appt_date field and then I input the DateAdd function there. Thank you for the DateAdd information...... highly appreciated. Thanks. Melanie H. -
M
Macro to update dates in table (add 7 days)
one more thing to do..... I do need it to update all the Appt_Date fields in the entire table all at once. Is there a better way to do this? If it is on the form.... does that only update that one form? Thanks as always. Melanie -
M
Macro to update dates in table (add 7 days)
Thank you. I have the field from my Table now on a form. The date field is called "Appt_Date" The type of field is Date/Time and the format is Short Date. I draw the button, right click on it and go to build event/code builder. The following is the visual basic code: Private Sub... -
M
Macro to update dates in table (add 7 days)
can you tell me how to add the code to the button? dateadd("d", 7, valueToAddTo) I can't seem to figure out how to get a button on the table. Thank you..... very much. Melanie -
M
Macro to update dates in table (add 7 days)
dateadd("d", 7, valueToAddTo) Can you tell me how to make the button on the table? I'm not sure what do do with the code above? Thank you.... I should be able to figure this out.... so I appreciate your help. Melanie -
M
Macro to update dates in table (add 7 days)
dateadd("d", 7, valueToAddTo) How do I create a button and have it on the table? (I'm not sure how to make this happen so I do appreciate your help.) Thank you. Melanie -
M
Macro to update dates in table (add 7 days)
I have a table where users, in the date field, type in the date of an appointment. What I want to do is, next week, be able to run a macro that will automatically add 7 days to that date. Is that possible to create for the table? Thanks for any suggestions or ideas!