Search results

Hi All! I wish to transform a sub to a more useful one since I'll use it sevearal times in different contexts. The sub showed below opens an Excel-workbook and clears worksheet nr 1 from its data. What I have in mind is to declare two arguments for the sub, one argument should be the...

Hi All! How can I select a column with arbitary lenght of datarange with VBA-code? Say there is a column with 10 fields in an Excelworksheet and I wish to select them all, how do I do that? I've tried this; Worksheets("Blad1").Activate Worksheets("Blad1").Cells(1, 1).Select...

Hi All, I got a problem with the value of a control when I try to implement it to a SQL query. I got two cases, the first work but not the second. The first collect a number from a control, the second collects text from another control. I call on the controls in the same way, Me!Control1...

Hi All! I need help with a SQL query. I got two tables (tblPXtime and tblBudgetTime) with columns and relationships that can be seen in the attachments. From these tables I’d like to extract the date and time, in such manner that all date and time from tblBudgetTime should be collected...

Hi All! Before I export data from Access to an Excel sheet I want to clear that sheet from existing data. How do I do that with VBA code?

Hi All, what do you think about data analysis inside ACCESS? Is it preferred to export data to EXCEL and do the work there or would you work inside ACCESS? I’m working on a database that a user should control solely from ACCESS, hence no exports to EXCEL where he/she needs to do hands on...

Hi All, I’ve got a problem to get a form to work properly at a distributed FrontEnd. This is what I did; I created a DB and split it with the Database Tools > Access Database command (Access 2007). I placed the BackEnd on a server and kept the FE at my computer. I tested the Fe to be...

Hi All! Is there someone who knows how to make somewhat nested query to two tables? My goal is to; Two tables which both contains dates and times should be queried such a way that each date from the first table is matched to corresponding date in the second table. What I’ve tried...

Hi All! I'm in a situation where I have a Excel file with a budget for a project, and I think(!) I need to split the imported (excel -> access) table into two tables. Please take at look at the attached file, where the red section is the column heading, the blue section contains info about name...

Hi all! I have a problem regarding a Append Query. I’m using Access 2007 and have just played around with it 2 weeks by myself. First I created a query that just appends two fields from one table to another. If I open the query in design-mode and execute it by the “Command Ribbon” it works...

Hi All, I’ve got a problem to make use of some functions I found in a reference book. I believe that the VBA code I found is current and up to date. I’ve posted me question to the author but it would be nice to see what you all think about this… Please take a look at this extract from my...

Hi all, I’m new to Access and trying to learn from books. I got a question regarding how to handle imported tables. The situation is like this, and I'll try to be as precise as I can: Every month two different Excel sheets should be imported to Access. One lists all employees time in their...