Search results

I'm sorry for being difficult. I'm not sure what you mean. That field on my form says the same thing, ID for both the label and field. In fact, I didn't opt to have that ID field visible on my form.

I know you commented the inside functions already, but I'm still very new to understanding how to read the codes and if i'm grabbing the correct information. My table is attached with the fields. The fieldname of the attachment is simply the paperclip icon, so it's small things like that, that...

I've figure out that I named my module the same as my event..or at least changing the module name solved the error, but now I get the following error?

I've created a module, as you said, and created a click event, however, I get this error? HA. I'm no programmer, that's for sure. I have a new found respect!

I fixed that piece, but now when I attempt to run the code, the blue highlighted part comes back with this error box?

I've attached the following screen shot of an error. Also, I've replaced all field/table names to match, with the exception of the highlighted piece. I'm unsure of those two, and what and where to put the code? Any help? Thank you! J

Good Morning Arnel, I was looking through the forum, and saw your post here (http://www.access-programmers.co.uk/forums/showthread.php?t=283343&highlight=loadfromfile) regarding a pdf to save in an attachment field from a file. I wrote a post here...

I hear you. The report I'm running requires a signature at the bottom. I have my employees digitally sign the report (form) which I then attach to their attachment field for their employee record. Much of this is a manual process, and was wondering what, if any, Access can do to automate this.

What you're saying makes sense. I'm able to save my report as a pdf etc...but where might I go to figure out how to code something like that?

Good Afternoon, I have an attachment field in my employees table (tblEmployee) where I store unique documents to the employee (Loaned Equipment docs, warning docs, etc) and this works fine. Is is possible to save reports that I run specific to the employee to this particular employees...

Thank you for your time and explanations. Again, learn something new everyday.

It worked! Perfect. I do want to understand, but why EmployeeID? Because it's EmployeeID on my tablAIB that I'm trying to match? Edit: Also, is there a button I could create that I could press that would prompt me for the date I'd like to append?

Below is the sql code: INSERT INTO tblAIB ( ID, Period_Ending ) SELECT tblEmployee.ID, "5/2/2016" AS Period_Ending FROM tblEmployee; What should change? I'm confused.

Here is a copy..I had to delete quite a few tables/forms etc to get it to upload. The form is under frmEmployee (the form where my subform for tblAIB is) tblAIB is the table which I want to run the update query on... right now, I have a button to add a new record (pay period ending date) to...

The only item in my table that doesn't allow duplicates is the ID (AutoNumber)

I went through my employee table, and have no required fields. I then went through my subform table (tblAIB) which is the table I'm appending to and that has a foreign key field that is required (I can't remember why...) and attached is a copy of what that looks like. Could that be my issue...

What you said makes total sense after I went in and tinkered with which tables I play with and adjust. I now have the right set up (thanks to your advice) and I know I'm in the right direction, but when it goes to append the 42 records with the new additional pay period date..I get the following...

Good Morning, I have a sub form that hold pay period ending data for my employees. I also have a button on this form that creates a new record for the employee where I go in and add the new pay period ending date.... Is there a way to be able to make this button add that SAME pay period ending...

After playing with the code, along with your advice, I was successfully able to get my form to work in a more agreeable way! I find this forum VERY helpful! Thank you!

Good Afternoon, I've attached the following code to my On_Click event, however, it's not working the way I intended. When the form loads, it makes all of my Serial Number fields visible whereas I only want them visible if the drop down box has selected equipment highlighted. If I go into the...