Recent content by chrisguk

Thats a fair point, but as the accde is only "read only" how can I surpress this message?

Hi, I have Access 2013. I compiled my DB "accdb" to "accde" but everytime I open it just under the title bar it always says I have no rights to edit and should save as. This happens also with my ACCDB. One point to note in Server 2008R2 this does not happen but in Server 2012 it does. Any...

Ok I did that and still nothing. I have posted my query design below: Uploaded with ImageShack.us

Hi there, I put the query below together but when i run it, it returns nothing. I know some of the field values are blank but I still want it to return the data that is present. Any ideas? SELECT tblSitesHost.HostDetail, tblSites.SiteCode, tblSites.SiteName, tblAddress.Province...

One last thing TheChazm before I depart this thread. If you are going to stick with Access FE and BE you may want to consider the following: 1. Make a persistent connection between the front end and back end. This can be achieved by doing the following: Make a table called...

Hi many thanks for your reply, this option looks great. Are you able to post a Access 2000 version for me please?

I have a database that contains a list of items with a code assigned to them. Every other week I receive activation numbers for these items on an excel spreadsheet. Without type each on into the database is there a way I can automate the process using an SQL statement insert into, also I...

No need to go as deep as C#, try out .Net with Visual basic Express. Its far easier and a easily deployable application platform. You will see great rewards from investing your time in it. Also if you are thinking of using SQL Server then .Net apps are perfect. You can deploy the .exe to all...

Even though its a linked table the backend tables are being utilized locally on the computer to eliminate bandwidth issue's. It does a record by record sync when the users close the forms. This is actually very fast and extremely accurate as I control my own numbering system. The above...

Personally and I have done this many times in the past. I would be using MySQL or SQL Server as my database for internet/intranet use. Access has a limit to the amount of people that can log in at any given time. I think its something like 20 but dont quote me.

Hi, Not sure how familiar you are with VBA but you could use the following. To access VBA from your application just hit Alt+F11. I assume you want to assign a command click function too: Function Impo_allExcel() Dim myfile Dim mypath mypath = "c:\importxls\myimports\" Do myfile =...

I think first of all before you engage with building forms you should normalise your table structure better. We will find the management of it easier in the long run plus the performance will be better. You can find some good examples here...

See this post it may help you with what you want: http://www.access-programmers.co.uk/forums/showthread.php?t=31517

Hope the above helps and I know it seems a lot of tables for little data, but as your data grows you will see the benefits. I too when I first started out had to learn the hard way. I thought I produced this great database until an MVP ripped it to pieces. I always use the rule that if there...

I am not sure your table is normalised correctly see below: [Table Structure] *[ID] - Number - Primary Key - Indexed One index - [Personnel Number] - Number ----------- [Course Number] - Text - Course numbers should be stored somewhere else as there could be many course numbers to one person...