Search results

Hi all, Just want to know opinions on this matter. Previously I have my FE sitting on a network share and users create a shortcut to this file. This has the following benefits : Small filesize/footprint on user PC Customisable icons (:P) Possibility of just having one shortcut for all...

Hi all! I have been tasked to design something which I currently think is a challenge to me so hopefully someone could give some pointers :) What I have now is an MS Access 2010 file which generates a report by querying data from an SQL server. I have a make table query in this db which...

edit: never mind found a way to upload file now :) Can you please have a look when you can mate? Really appreciate it!

Thanks again for your reply! I think I've got the formula bit sorted mate. I must have unticked the "Preserve column sort and layout" sometime in the past. What I did it go to the very first row and made sure the formula is copied down till the end and saved the table. I think this should work...

I am using Excel 2010 and it seems the "Automatically fill down formula" option is not available? http://www.mrexcel.com/forum/showthread.php?t=312541

This is what I get when I right click on one of the worksheet containing Query data

I have attached a screenshot of the main spreadsheet to roughly illustrate what I am trying to achieve. Hopefully this will make things a bit clearer to you...

Thanks for the quick reply :) Hmm, my tables are not converted to Data Ranges at the moment so I can't see this option when I right click. Should I convert them? I have 5 worksheets which basically are results returned from 5 different MS Queries... In some of the worksheets I have addition...

Hi all, Pretty new to this side of things in Excel so I hope someone could help me out. We have an old spread sheet where we populate job information manually. However now that we've moved onto a database based system, there is no need to populate (most) of the field automatically. The...

Hi all, I am using the following code to update my FrontEnds. It seems to be working fine most of the time but I find that for larger FEs sometimes it will fail - thus creating a lot of backups of the FE on user's desktop. As I understand it, this code will check for the source file and copy...

Hi all, I am working in MS Access 2010. I have a login form for that is set to load from the "Display Form" property of the Current Database tab. Basically the login form loads first thing when the database is opened. I have created a function that checks the server for latest FE version and...

Hi, Thanks again! Tried this but it is possible that the query would return more than 1 value. Using my example above it will return 2 unique values as there are 2 surcharges <= today. I think I need to create another query to then grab the max date of this query and return the surcharge percent?

Hi! Thanks for your reply. Correct me if I am wrong but your solution seems to just grab the latest date from the surcharges table. The problem is sometimes there will be future dates entered into the table. My function basically searches through the dates to match the most recent surcharge...

Hi all, I have a table of Couriers and a subtable of Surcharges linked to the Couriers. The table structure is as below: tblCourier -PKCourierID -fkSurchargeID -txtName -bolActive tblSurcharges -PKSurchargeID -dteDateActive (the date surcharge starts) -dblPercentIncrease My function...

Thanks for all the answers! I think 90% for the end users will not be savvy enough to hack into connection string as I distribute the FE as an ACCDE file. I also know how to build in a Shift bypass etc but thinking back I would have to update all the queries and reports in the FE to include the...

Hi all, I have a database built using MS Access 2010 which is a split database. Everything is working fine until some users found out the BE location. *Someone* then managed to change some user details in the tables. Luckily I have backups but I really want to prevent this happening again. I...

Hi, My client gets sent a daily/weekly spreadsheet that have basicalyl the same format but the data and filename differs according to dates. What my client wants to do is virtually "cut and paste" the selected data from this Excel spreadsheet and dump it into an MS Access database I have. I...

Ah ok... in that case your solution will work better :)

Hmm, don't quite understand you here. Do you mean the user enters a date and you want to output the week starting and week ending dates? Try something like this : Dim tempDay as string tempDay = Weekday(Me.txtUserDate) Select Case tempDay Case 1 ' Sunday Me.txtWeekBeginning =...

Have you tried the OnChange event? This triggers as you enter data into the field.