以连续形式更新多个选定记录 [英] Updating multiple selected records in continuous form
问题描述
嗨社区,我需要帮助完成一项对专家来说必须相当简单的任务。但是对于像< g class =" gr_ gr_113 gr-alert gr_gramm gr_inline_cards这样的新手gr_run_anim标点符号只能替换为非数据-GR-ID =" 113" ID = QUOT; 113"> ME< / g取代;
它正在制造噩梦。
我需要一个表格,其中< g class =" gr_ gr_195 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace"数据-GR-ID =" 195" ID = QUOT; 195" I标记< / g取代;可以从表中选择X个记录,并将
a日期戳记放在这些所选记录的相应日期字段中。
我已将日期字段命名为"Date_Selected"
也许某些按钮
+10(此按钮应选择前10条没有日期戳的记录并输入当前日期)
+ 50 (此按钮应选择前50条没有日期戳的记录并输入当前日期)
+ 100 (此按钮应选择前100条没有日期戳的记录并输入当前日期)
+ 500 (此按钮应选择前500条没有日期戳的记录并输入当前日期)
清除
I然后想要使用查询将所选记录导出为excel。
我将非常感谢专家的帮助。
提前致谢:)
您是否考虑过使用"是/否"字段来选择每条记录?然后,您可以在表单上的复选框的AfterUpdate事件中使用VBA来指定日期或将其删除,具体取决于是否选中此框。
仅我的2美分..
Hi Community, I need help in a task which must be fairly simple for experts. But for a newbie like <g class="gr_ gr_113 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" data-gr-id="113" id="113">me</g> it is creating nightmares.
I need a Form where <g class="gr_ gr_195 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="195" id="195">i</g> can select X number of records from the table and put a date stamp in respective date filed of those selected records.
I have named date field "Date_Selected"
Maybe some buttons with
+10 (this button should select first 10 records without datestamp and put current date)
+50 (this button should select first 50 records without datestamp and put current date)
+100 (this button should select first 100 records without datestamp and put current date)
+500 (this button should select first 500 records without datestamp and put current date)
Clear
I then want to export selected records using a query to excel.
I will really appreciate the help from experts.
Thanks in advance :)
Hi,
Have you considered using a Yes/No field for selecting each record? You can then use VBA in the AfterUpdate event of the Checkbox on the Form to assign a date or remove it, depending on whether the box is checked or not.
Just my 2 cents...
这篇关于以连续形式更新多个选定记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!