Search results

Hello All, Few Questions!! I have a front end access database that has linked tables that reside in a SQL Server Database. I have about 300 + users using the database at any given time. I want to grant them access to the tables using an Active Directory group which they all reside in at...

Hello All, I have a database that has been split with forms , queries , reports etc.. in the front end and just the tables in the back end file. I've decided to move the back end to SQL Server 2016. I used the SSMA tool to copy the tables to the SQL server and link the tables to my front-end...

Hi guys i'm trying to establish a connection to my back end SQL Server using ADO ...but for some reason i am encountering some errors ... I get the compile error:syntax error and it hightlight the ADOConn.ConnectionString line.... i also get Compile error: Expected: end of statement when it gets...

Hello All, I found this code online to be able to connect my front end to my back end SQL server tables... without having to create a DSN on each person's pc that is using my front-end. I just don't know where to put this code? in the start up form? in a module? Sorry i'm not to savy with...

Hello All, It's been awhile since i wrote in here. Here is my scenario. I have a query that has several IIF statements based on the FTE count. I want the return result to be formatted as a number so when i do my total field it gives me back the correct number. Right now if i do a total based...

hello all, I am trying to lock a sub form based on a checkbox on my mainform I was able to get it to lock but when I click on one of the cells of the subform after it's been locked I get error message 2185. Please see pic ! My code is as follows on my mainform (on current) event and I also put...

Hello All! it's been awhile since I've posted.. you guys are always helpful. My problem: Trying to get two records that have the same ID# and same fields to show on the same report. Almost like a continuous form. I have attached images. Thanks in advance!

Hello All, Its been awhile since ive been on here. You guys are always really helpful. I have a timekeeping report in which I want to format or force a zero value if a certain project number is picked. For instance on Monday John Doe charged 6 hours to project NNNNN but on the report rather...

Good Afternoon, I've looked all over the net for answer but couldn't find one. You guys never let me down. I want to be able to email a report to several individuals and have only the data that pertains to that person attached in the email? Is this possible? regards, JB

Hello All, Does any one know a good system or app that is free to automatically update the front end of a database? I found this one but its giving runtime error message 3078 and cant figure out how to fix it. http://www.btabdevelopment.com/ts/freetools thanks in advance!

Hi All, I have an unbound text box on a continuous form that displays my description from my combo box.... and it works fine but when I click on the next record or put the cursor on another record field it disappears how do I make it appear regardless where my cursor is? Hope this makes...

Hello All, I used the code in the link below to get the login id returned on a form but I am having trouble now that I rolled out the database the code gives an error if the user has older than 2010 and even on a new machine that has access 2013 what is the best code to use? to return the log...

Hello!! I'm trying to figure out how to by pass error 3021 No current record I know I can put the code below just don't know where to put it. If Err.Description = "No current record" Then Resume I attached a pic of my code that is causing the error .. and its okay I just want to by pass...

Hello! I have a timesheet form that pulls from a query that pulls from a table I want to clear my daily charges and reset back to the default value of 0 when my form opens ... can't figure out the code.. . Saturday, Sunday, Monday , Tuesday , Wednesday, Thursday, Friday thanks a mil...

Hello all ! happy new year! I've been trying to create a cascading combo box for a few weeks now and I get the same darn problem... The selection on my (unbound) first combo dictates what u see in my (Bound) second combo... my problem is what ever I choose on my first combo it defaults to...

Good Morning All ! First off happy new year!! I want to be able to update a date field in my form with a command button based off the date the person picks off a combo box in my header... is this possible?

I have a combo box with a list of employees I want to restrict the user/employee to be able to only pick his name from the combo box? Is it possible? Thank you in advance!

Hello I have a timesheet data base and I wanted to find a way to restrict employees from editing other employees timesheets only their own timesheet... .is it possible with access 2010?

Hi All, Happy Holidays!! How do I create new records based on the results of a query? I opened the query results in a form then I want to have a button that basically creates new records based off the query data ... is this possible? :banghead: Thanks in Advance!!

Hello All, I'm trying to figure out what is the best way for me to go about this issue I have for my timekeeping database. Basically each employee enters their timesheet based on weekending date... I want them to be able to (if needed) to use the previous week's time charges and either...