Search:

Hi Everyone,

I need a little help...

I have a visual basic 2010 windows application, with a user control in a form, the user control display's data from a database table call sm_tblProduct. ...

Hi Everyone,

I am looking for a way to open a few thousand letters in preset locations, all have a 6 digit file name. and scan the letter for a specific date then scan the letter for specific...

Hi everyone,

I am trying to pass a selection of parameters to a cursor useing t-sql on MS Server 2005

I am not sure how to do this, so far I have the following

DECLARE cur_test CURSOR FOR...

Unfortunately, very few of us are knowledgeable about T-SQL, and even fewer are comfortable with triggers. In principal, you should be able to do what you describe, although I'm a bit fuzzy on some...

Hi everyone,

I'm really stuck with this one, in my head it seems like a simple task.

Language T-SQL Platfom: SQL Server 2005

Background:
I have read access to a view of a table via a linked...

Why not run an update sql statement?

UPDATE [dbo].[tbl_Discharge] SET [Ward] = Left([Ward],CHARINDEX('*',@Ward)-1) WHERE [Download_Date] >= GETDATE()

Many thanks Hans, Works great.

Why do you use DATEDIFF here?

Take a look at the CHARINDEX function.

Thanks Hans,

Thats cut down on some code, but I still can't get it to work, it only works if there is only one row that...

Hi everyone,

Firstly, Like the new look, very nice!

I have a table [dbo].[tbl_Discharge] with a column call [Ward] at the moment the column contains data like F1*WSH and PACU*WSH etc, I am...

Hi everyone,

I am trying to creat a view of a table but include an if function on column 'WARD' the primary table is called tbl_Discharge and the table with exclusions is called tbl_Profile_Detail...

Thats Great Hans Thanks,

Is it also possible to put use an UPDATE and INERT trigger in one trigger. i.e. If INSERT THEN do X else if Update then do Y

Kind Regards

Hi all,

I am having a bit of trouble with my trigger (see below), is there a way of identifing any column update i notice
that * does not work at the point 'IF UPDATE (*) but I have many columns...

Hi everyone,

I am not sure where I should post this question so please forgive me if it is in the wrong place.

I am currently creating a database using SQL and will either be using VB or...

Ok Hans thanks,

I can't get you a stripped down database to 100kb or less, in the db you have there is a table called tbl_IR, imagine a from that display's that table the form also has a subform...

Hans,

It's the same a the previous db I uploaded (but I can't find the post) the table is called tbl_IR

Thanks

Hans,

Thanks for the reply, you are correct it should I had noticed that after I posted it but this did not fix the problem I get the same problem

Thanks

Hans,

Thanks for the reply, DoCmd.Copy is not available so I tried RunCommand(acCmdCopy) and
(acCmdPasteAppend) but this didn't work either.

I have gone with using the following but there is...

Hi everyone,

I have a database that stores current project details, some of these records are recurring events, on the form I have a simple yes/no check box to identify its a recurring event and...

Hi,

Thanks Hans, I was definatly making it more complicated than it needed to be! I had found another formular that worked using a sumproduct + sumproduct but your way is much cleaner, thanks

Hi,

Heres part two this is the backend with the data.

The form is in the first download and called frm_Dashboard_IA I have highlighted the problem combo in red

Thanks

Thanks

Heres part one of the striped down database

Thanks

Here you go

Hi Everyone,

I am trying to find out how many customers are in the department at any one time, there arrival time being between x and y (15 min blocks) and there departure time being z
...

Thanks Hans, I will do. And yes it was helpfull I have only just had time to test it out but works gret now many thanks. Have replied on the original post now!

Thanks Hans Perfect

Hi All,

Does anyone know why my combo box is not doing as I expected. I have a form which was created a few weeks ago, and have now decided to add a combo box to this form, the combo box uses the...