Search results

I am in South Africa, but I don't understand why this matters! Are you implying that if I develop a database on a computer using regional settings in the mm/dd/yyyy format it will not work on another computer using regional settings in the dd/mm/yyyy format or yyy/mm/dd format. If you are, then...

This has probably been asked before, so please bear with me! Dim FirstTimeStamp As Date Dim SecondTimeStamp As Date Dim TimeInterval As Integer FirstTimeStamp =07/06/2010 11:54:33 PM SecondTimeStamp = 07/07/2010 12:24:33 AM Both of these are in the format: mm/dd/yyyy hh:nn:ss TimeInterval...

Using VBA, I need to import the attached Excel file into an Access 2010 database My problems include: * Access 2010 doesn't appear to have import funtionality of previous versions! * The first row of the Excel file has strange characters! I simply want to import the data into tblTempData which...

I did have Office 2000 on this machine but removed it when I upgraded to Office 2010

When working with graphs, I often get a Microsoft "configuration progress" splash screen say ing that Microsoft needs to do some configurations How do I get rid of this. It is really annoying! Using Access 2010

Is there a method to format a graph using vba? I need to create a line graph and, using VBA, would like to: * set line colour * set line thickness Bearing in mind that the graph will have numerous lines! Thanks in advance

99% of the tables in my database are linked to a backend database I needed to rebuild the frontend and had to remember which tables in the frontend were unlinked. All the unlinked frontend tables hold temporary data. So I thought I would simply create tables matching the unlinked tables, and...

found my answer at http://allenbrowne.com/func-DAO.html#CreateTableDAO

I have a need to create tables using vba (DAO) I have two tables, tblCreateTable & tblCreateTableFields After I have selected the table I need to create in tblCreateTable, I need to create a recordest of the table's fields in tblCreateTableFields and create the table. I understand how to...

I have been advised by some that I should create a temp table, put the InvoiceId into this table and include this table in the reports underlying query. I have done this. When I look at the data in the reports underlying query, the correct "filtered" data is returned. I have removed the code...

once Public Wclause As String

Changed to On Load event Same error, line in red Wclause = "InvoiceId = " & Me.lstSelectInvoice.Column(1) DoCmd.OpenReport "rptCustomerTaxInvoice", acViewPreview and if I use DoCmd.OutputTo acOutputReport, "rptCustomerTaxInvoice", acFormatPDF, "C:\CustomerTaxInvoice.pdf", False, , ...

I have change the If statement from: If Wclause <> "" Then to If Len(Wclause) <> 0 Then and still have the same problem!

I am upgrading a database from Access 2000 to Access 2010 In Access 2000, to filter a report I used the following: Wclause = "InvoiceId = " & Me.lstSelectInvoice.Column(1) DoCmd.OpenReport "rptCustomerTaxInvoice", acViewPreview, , WClause This worked well! I now want to use the Access 2010...

In my Access 2010 database I have disabled: * Display Navigation Pane * Allow Full Menus * Allow default shortcut Menus This gives the user a clean screen. If I open a report in preview mode, how can I show the Print Preview ribbon to allow users to actually print or close the report. And...

Is it possible to copy a table data macro from one data base to another? I have a database that I use for development. Once happy with the development, I copy the changes over to a live database. With the backend (data) database I have developed a database that compares the development...

Many thanks. Just what I wanted. I see that you added a query. What table did you add?

an alternative is to have Data macro do a LookUpRecord action upon a query that does this: SELECT WhoAmI(); Microsoft returns an error! I am only using a client side database Once I have the var data, how do I use it in the Data macro? I have taken the liberty of attaching a copy of me...

Hi AccessJunkie I am having a simillar problem, but without forms If I open a new thread, can you assist? I am asking because i need to know that you are still on this forum!

Is it possilbe to run a VBA function from within a 2010 Data Macro. I have a function called WhoAmI with returns the Id of the user I want to run this function from within the data macro.