Search results

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, You may want to take a look at this: http://vajentic.blogspot.com/2008/08...reated-in.html

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

Yes Sir it is. I need it for the main window hide macro i have running

Its okay guys. The following resolved it. To ensure that DAO is used within an Access 2000 (or greater) database you need to: open a module; select Tools -> References from the menu; find and check Microsoft DAO 3.x Object Library...

Hi all, Any ideas why I get the following error? Uploaded with ImageShack.us

If you have a form open already though the report defaults to the background for some reason. All I wanted was the report to be in the foreground. But an advantage would be to have it in a form so I can have controls etc

Hi all, Understand that when you want to preview a report it isnt always in focus. By that I mean the report pops up and the form you were using goes into the background. So to prevent this someone has told me to using the snapshot viewer control within access. I have tried to find out...

Hi there, I have two tables: tblAccount Fields: pkAcct_Link, AccountNo and tblCustomer fields: fkAcct_link, DateFrom, DateTo, Consumption I want an SQL to do the following: Insert into tblaccount (dateFrom, DateTo, Consumption) VALUES (01/01/2001, 02/02/2022, 8688756) The problem...

I have a form with various fields. When the form opens a majority of the fields are NOT enabled. I then have a command button "Edit" that makes the fields editable with the Me.field.Enabled = True command. When I try to mimic the save edit I get an error message stating you cannot disable a...

This is what the command btn vba looks like: Private Sub BtnPrintSavings_Report_Click() On Error GoTo Err_BtnPrintSavings_Report_Click Dim stDocName As String stDocName = "rptSitesLogSavings" DoCmd.OpenReport stDocName, acPreview, , [savingsid] = " & me.savingsid"...

I have a subform like so: Main Form = frmSitesLog Subform = frmSitesLogSavings The subform has multiple calulation fields within it that will be transferred to a report. The name of my report is rtpSitesLogSavings The form is controlled by control name SavingsID and so is the report. I...

Its okay dude I figured it out using the IsLoaded function

Hi Guys, I have a two part question. First one is, if I have the following code: InvoiceCounter = 0 InvoiceCounter = DCount("[CRCInvoiceID]", "tblSitesCRCLastInvoice", "[tblSitesCRCLastInvoice].[fkAccountsID] = [forms]![frmSitesCRCMain]![frmSitesAccount]![AccountID]") Counter_txt...

Does anyone know of a free Custom Ribbon creator for Access 2007?

Hi there, I have been using the following to professionally deploy my database: Access Runtime for 2007 Developer Extension - Deployment package. What I want to know is? Is it possible to deploy a split database. Putting the main tables DB and Frontend in a location under "Program Files"...

Its okay I worked it out. Just use the Cascade delete and update functions in the Join type.

Hi, I have a form that comprises of Sub forms within tab controls. I have placed a delete button on the main form to remove any unwanted records. There is a problem with this. You are not able to delete a main record when a child record exists in related tables. How can I achieve this using...