Search results

I noticed when posting a reply that it was post number 999996 so thought I would commemerate post number 1000000 with this thread. I'm not sure which number the first post was so not sure how many actual posts there have been but it seemed worth remarking upon in here. So happy one millionth...

Scientist have successfully created the first self-replicating, synthetic bacterial cell. http://www.zdnet.com/photos/scientists-build-first-synthetic-bacteria-photos/425927 I now admit intelligent design does exist thought it seems to be distinctly human and not divine.

Hey folks, I'm having a play around with class modules and one of the things I am wanting to do is add some constants. So I have a property called 'volume' and I would like the only values that can be assigned to this property to be "Gen1", "Gen2" ... "Gen6" but I'm struggling to find any...

Wondering if anyone is doing any of the problems from http://projecteuler.net/ It's a set of a mathematical puzzles aimed at improving your maths and coding. Some of the stuff is well beyond me but if you enjoy this sort of thing it's well worth taking a look.

I'm doing some stuff in excel and some of it is going to be easier to get results of calculations by using sql rather than coding excel functions. For some of these calculations I am wanting to use the following sort of sql. select stuff from table where stuff not in (select things from...

Any chance you could get rid off the required one minute delay between reporting posts?

Hey folks, I have a SQL backend database from which I extract data from. One of the tables I query is the auditlog table which I use to look at how long it takes tickets to move through a particular process. This is a reasonably large table with ~2 million rows. I only want to extract records...

This is generic code that will create and arrange graphs in excel from access, you need to output the data to graph into excel first. Parameters: cht_sourcedata: The first cell of the data you want to graph passed as an excel range cht_title: The title you want for your graph x_name: The...

I've got a table with a self join which represents a tree structure that can have variable depth. I want to get a spreadsheet view of this for project review meetings. I can do a bunch of nested queries until I get all the branches but i would like something a little more dynamic, i.e...

I've created a form with three list boxes and a combo box. The combo gives a list of locations. One list box gives the details of items kept at that location. The other two list boxes are intended to show a list of items and documents that are currently not kept at that location. There are...

Hi folks, I have the following sql statement in my code. strSQL = "INSERT INTO tbl_iss_num (doc_tbl_fk, Issue_num, Date_Released) VALUES " & _ "(" & fk_ver & ", '" & Me!txt_ver_no & "'," & Date & ")" When I use db.execute (strSQL) the value inserted into the table by the...

Hi Folks, I am trying to pass variables to a sub which creates a pivottable. The following line of code works: pt.AddFields RowFields:=Array("BG_DETECTION_DATE", "BG_SEVERITY"), ColumnFields:=Array("BG_PROJECT_DB", "BG_USER_01") I want to create multiple pivottables so I created a...

Hey folks got a small problem with some code I'm using that results in the following error message: "Run-Time Error '1004': The pivotTable field name is not valid. To create a pivottable report, you must use data that is organized as a list with labeled columns. If you are changing the name of...

Hey folks, Bit of an embarassing this one. How do I change the way the VBE displays dates? currently it's mm/dd/yy and I'm wanting dd/mm/yy.

Hey folks, Not sure if this is the best forum but decided to put it here anyway. I have a Access query that reads: SELECT bleh FROM blah WHERE something > 10 Then in Excel I pull the data across using: Set qdf = db.QueryDefs(qryName) Set rs = qdf.OpenRecordset and paste the data using...

Is there anyway to have fields which are empty display a 0 instead of being blank when using a crosstab query? Solved by a pointer to the nz function in another thread.

Hi Folks, I am attempting to import a table using the following vba: DoCmd.TransferDatabase acImport, "ODBC Database", _ "ODBC;DSN=rem1;UID=guest;PWD=guest;" _ & "DATABASE=Remedy", acTable, "HPD_Help_Desk", "tbl_hd1" When I try runing the code I get run-time error 3011 The microsoft jet...