Search results

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...

I got the linked table situation sorted, that was just a typo so the program created its own table. For the imprt i was hoping there was a solution available to open a windows dialogue like you do in explorer and select the file to import?

I found this solution, but what if I wanted to choose the file location dynamically? Dim trz As Integer Dim strCSV As String For trz = 1 To 511 Close #trz Next trz trz = FreeFile Open "c:\Export.csv" For Output Access Write As #trz With...

But what if you wanted to choose the file location dynamically?

HI, I am looking for a solution to export to CSV. I have tried many examples around google but cant seem to get them to work My query has more than 65,000 lines. Can anyone help? This is the code that I am using: DoCmd.TransferText acExportDelim, , "CombinedBills", strFile

Hi, I am using the following code to import my spreadsheet into Access but I have a split database main.adb and main_be.mdb. How can I modify this code to put the data into the linked table? DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel7, "tblCustomerDetails", "myfile.xls"...