Search results

UPDATE: from below post... After running I got the error below, so I went into my %userprofile%\AppData\Local\Temp folder and deleted the .tff file that was there and ran again and it worked? I seems it allowed me to put the .tff file there but wont allow me to delete it? @arnelgp I'm testing...

@arnelgp thank you again! Its pretty cool what can be done with access or excel you guys/gals know your stuff! @Gasman , @theDBguy thank you as well....

I'm at home working on it and I have 2016, maybe that's why its giving me the error also? I have 365 at work...

@arnelgp wrote it hopefully he will jump in and take a look.... Thanks Anyways!

@Gasman the errors code line is in the image its highlighted in yellow....

@arnelgp I wanted to convert to using 128 Code Barcode instead of QR so I figured out how to convert the tables attached excel workbook to be able to retrieve 128 Code Barcodes from a different website because Google doesn't support it and it works. I'm having an error and I cant figure out why...

@arnelgp That my friend works perfectly! Thanks a million.......

@arnelgp I read your example the other day and I cant use it due to having to add/install files to my work PC so I searched for an alternative like in my example I posted. This will allow me to get around all that and anyone could use the .accdb. Thanks,

Hello, I'm using Googles https://chart.googleapis.com/chart? to be able to get QR codes from a text box [Text2] and it works just fine. I now need to be able to save the QR code to my desktop using a button. I currently found the code below HERE, but it brings up a open file window and allows me...

Interesting and good idea.... Thanks

Thanks everyone for the help that worked.....

Hello, I have a strSQL string in a function and I don't want it to look for certain words. One of my words has an apostrophe and I was wondering how to fix that? Do you enclose the ' with a "'" strSQL = strSQL & "WHERE tbl_YearCalendar.EmployeeID = " & empID & " AND tbluAbsenceCodes.AbsenceCode...

I followed this video tutorial for a Prevent Duplicate data using a composite key in the table between the year and employeeId and that solved having duplicate data. Composite Video Thanks,

@plog I get it now.... I read your initial post over and over and over a few times and sorry I jumped the gun or just didn't get it, and I get it now and it works. I thought you had to have the table in there as well and linked to EmployeeID and I didnt know that when you change it to Append and...

@plog I created the query like you said and changed it to an Append query then added the criteria pointing to the forms text box and added inactive false to not add records for employees that arnt there BUT it not doing anything when I run it other than showing a test record, I added for the...

Hello, I have a table (tbluBoughtPTO) that I want to auto add a record for each active (tbluEmployees.isInactive = False) employee (tbluEmployees.EmployeeID) and have the button on my form (frm_AddEditAccuredPTO) and on the form there is a textbox (txtYear) which I would enter a year that would...

@Solo712 I see.... Using a function looks to be better than a bunch of formulas in a query and works great thank you!

@arnelgp yep its right.... Here is another example that I know is incorrect BUT I have no idea how to write it... FlexDaysAquired: IIf([EmpDateOfHire]>=#1/1/DatePart("yyyy",[EmpDateOfHire]# And ([EmpDateOfHire]>=#4/30/DatePart("yyyy",[EmpDateOfHire],0,6)

@arnelgp the first calendar year of employment this scenario is for, there is no scenario after the first calendar year because they imminently get 6 days starting the first of every year after. Example: If I have an employee who started and their [EmpDateOfHire] is 5/2/22 so they would get 4...

How could I write one query formula for these guidelines below? Jan 1 - April 30 = 6 Days May 1 - Aug 31 = 4 Days Sep 1 - Nov 30 = 2 Days Dec 1 - Dec 31 = 0 days Scenarios If I have an employee who started and their [EmpDateOfHire] is 5/2/22 so they would get 4 paid days off the first year...