Search results

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

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

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

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

I have the following code running from a simple click event: Private Sub btnWeeklyReport_Click() On Error GoTo Do_Nothing DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "WeeklyReport", txtExportFile MsgBox "The tables have been successfully exported to " &...

Hi, Have two tables: tblAccounts pkAccountsID fkNUmberID tblNumber pkNUmberID NumberDetail I have a form which had the tblaccounts created using the wizard. I then remove the fknumber field and replace it with a drop down combo box. My question is! How do I lock the value selected in...

Is it possible to have a pop reminder system and task management area within Access, something similar to outlook but completely autonomous. For example I have lodged a job and I want my system to remind me to check on it on a given date?

Hi there, I understand that you can use the following in the immediate window to password generate ?EncryptKey("Password")635 586 600 600 604 580 601 591 ?DecryptKey("635 586 600 600 604 580 601 591 ")Password But I want to do this in a form with a on click event using maybe an unbound...

I have been searching the internet for an example of how to make a form that I can use to select query criteria from. For example: Form Select accounts with "Gas" or "Elec" or "Water" In a drop down box then maybe have two fields with date from and to perios for the active dates. Any...

How would I make this following code an IF OR statement? Code: =IIf([Sum1]+[Sum2]+[sum3]=3,"Sorry this is not a valid claim","Valid Claim") So the Or would be [Sum1]+[Sum2]+[sum3]+[sum4]

Hi, I use the following code on my search box. But I want it to goto the searched record in the form not filter it, how do I achieve this? Private Sub cmdSearch_Click() If Len(cboSearchField) = 0 Or IsNull(cboSearchField) = True Then MsgBox "You must select a field to search."...

Hi, Is there anyone that is able to tell me whats wrong with the following: =IIf([OriginalAmount]-[RebillAmount]=0,0,(Nz([OriginalAmount]-[RebillAmount]=0,0,Nz([OriginalAmount],0)/(DateDiff("d",[dteOriginalFrom],[dteOriginalTo]))*365)+Nz([CashReturn]))

:confused: Hi there, I have a table that stores account numbers and other data. The account numbers are the primary using a number field with long integer. The problem I have is some of the account numbers are too long for the long integer max field size. Can I use a text field instead...

Hi all, I am trying to get hold of the Access 2003 Developer Extensions. I cant seem to find them anywhere. Can anyone help?

Hi there, I have managed to implement the common dialog API on my form which allows me to select a file name and store it in a field. The problem I am having is I have a continuous form and when I populate the field with the file name it changes all the other fields to the same. Is there...

Hi All, Does anyone have any experience using the common API in access. Im trying to achieve the following: Unbound Field showing the location of a file two command buttons = Add a File location / View the file in the unabound field Any help will be great Thanks Chris

Hi there, I have a form that the user completes but they may want to store a related file on the server in the same form. How to I create a button to browse the file and then store it in a default location on the server? Chris

Not importing from Excel properly Hi there, I am trying to import some data into one of my tables and I have the following issues: The PK field namely SitesID is a number (long interger) type. On the spreadsheet im importing the number is typically 6-7 digits long. When I import they...

Hi, I have finally completed my database and the tables are completely normalised. The task I have now is that all of my data is contained within an excel spreadsheet and of course the columns in the spreadsheet relate to various tables that are linked. What would be the vest method for...