Search results for query: *

Hi, I am trying to write a trigger, whereby it gets todays date, which is pretty easy, but I also want the date of the monday of that week... So if I inserted some thing tomorrow I want the date in the date column as 6/12/04, and a weekstarted column with 5/12/04... I have no idea how to go...

Hi, I am having a few problems with the formatting of dates using a SQL trigger.... I get todays date, no problem, then I add a day to it, try and format it and it comes across in a totally different format, for example... I want the format to be 12/12/2004 and it gives me Dec 12 2004 12:00am...

Hi, I have a form that requires the user to import some data from an oracle database into an access table. This is controlled by a simple form that when I press "import" it pulls all the required information from the database accross. This bit works fine.... However the next step requires...

Hi, I am using Access to format some information before inserting it into an Oracale Lite database. I can quite happily access the information, format it, but when I try and insert or update it back into the database I get the following message. Run-time error '-2147467259 (80004005)...

Hi, I've got this code, which quite happily collects a list of DSN's from the PC, but I want to place this into a drop down list on an Access Form... Any ideas? Thanks Jamie Private Declare Function SQLDataSources Lib "ODBC32.DLL" _ (ByVal henv&, ByVal fDirection%, ByVal szDSN$, ByVal...

Hi, I am trying to insert the following into a table, which is working fine..... Update = "INSERT INTO TEMP (ID, POLLING_NUMBER, NAME) " Update = Update & "VALUES (" & curRecord & ", " & rt.Fields("POLLING_NUMBER").Value & ", '" & formatName & "');" But when I try and insert an individual...

Hi, Does anyone know how to create a DSN for Oracle programatically using VB? I have found code snipets for SQL server, but nothing so far for Oracle.... The reason for doing this is that I have (potentially) 400 or more seperate DB's to use at any one time and the prospect of setting these up...

Hi, This maybe a simple question, but I am trying to create a query to update a record within a database with a huge number of columns (somewhere around 200+). My trigger so far is as follows, where it updates a record with a new date, but I need this to update each column. I read a number of...

Hi, A quick question which I hope someone can advise me with. After using the forums I am starting to get a better understanding of how things fit together, but would like to get some decent reference books.... Any suggestions of a "SQL bible"??? Thanks in advance Jamie

Hi, This is my first attempt at a trigger and I seem to be having a bit of a brain freeze! I insert a record into a table with basic user info, a trigger then grabs the newly inserted information and puts it into a second table for later use. However whenever i do this it takes everything...

Hi, I am a little new to all this and am currently tearing my hair out. I have a function that needs to be called multiple times and looks like.... function LoadInc(theField) { inctxt = new Array(); inctxt[0] = new Array; inctxt[0][0] = '' inctxt[0][1] = '10'...

Hi, I am currently working on a simple document retrieval system that indexes documents, stores the images as tif's then after choosing the relevant image, click on image name and up pops a display....... But tif's don't seem to work with VB?? Or am I doing something wrong. I have used the...

Hi, I have a question that is probably very easy to do, but I can't think how. I populate my database using OCR technologies, which converts all the characters to upper case. Which I am happy with from a data storage point of view, however, when I am generating letters using Reports, having...

Hi, I have a form, using the tab controller to split my information, into two sets, ie first page is client information, whilst the second page contains image controls. I have a search window that allows some wildcard searching, which then returns, say three records. At this point I want to...

Hi, I am using a make table query, which is working nicely. This will then create a form, but the one problem I am having is how to convert an image name, eg 1234556.tif into a hyperlink..... so once the user has gone through the data, can click on the image and have it open in whatever...

Hi, I was wondering if anyone know how to do this.... I run a query to generate a new table, where if there is a null value, then a value of '0' is output is a processed data column using this command in the query designer First_Ob_Output...

Hi, I was wondering if anyone had done this before??? I have a query that returns a set of values for an audit. Which I have set up and its working correctly.... But instead of displaying the actual values, eg a weight of 80kg, I just want to acknowledge that this value was recorded (show as...

Hi, I have a quick question. I have a pretty basic database, where you can search via a drop down menu, this then returns that record and populates a bunch of list boxes with information. So my questions are 1) I need to make a query for each list box to display the value, which seems a...

Hi all, 1)I am having a little trouble with refreshing the view of my form, i.e. I select a number from a combo box, this populates the rest of the form with data. However the only way I have managed to refresh this so far is by using the requery function in macro.... there must be a faster...

Hi, I have a form that will ultimately have several hundred text boxes and radio button which link to the database by an incident number.... So when I select the number I want to query, the database is queried and text areas populated... This works fine and with a smal number of objects it is...