Search results for query: *

Hi, When using the Convert to format the Date in a select statement I dot seem to have any change in the display, can someone tell me if I am doing something wrong. If I use convert(datetime, '31-dec-2010', 3) or convert(datetime, '31-dec-2010', 103) all I get for the results is 2010-12-31...

Hi, I am in the process of looking a test upgrade from SQL2000 to SQL2005, once we are happy with the upgrade, we need to be able to turn off the SQL2000 and rename the SQL2005 server to the name of the SQL2000 server. I know from experience with older version of sql server that this can be a...

Does anyone know if there is a limit to the amount of elements you can have in a ENUM, as I have the following ENUM in the declarations area of one of my forms and it is only displaying the first 7 elements when used Enum AddQualType QUAL_GCSE = 1 QUAL_KS = 5 QUAL_AS = 6 QUAL_A...

Hi, On my master form in my project, when a user enters a reference number (StudentRef), I need to be able to check if the record exists in UCI table (PK of StudentRef), and if it exists read the data from UCI field, but if no record exists then to create a record. I have tried playing around...

Hi, I have a Notes table with a notesid field, jobref field & date field where I want to return the record with the earliest date by jobref Notes ID JobRef NotesDate Notes 1 MY-06-014 11/05/06 11:23 test 1 2 MY-06-014 11/05/06 11:27 test 2 3 MY-06-010...

Hi, I am in the process of updating our inhouse Helpdesk system, and need to add a table to the system which will hold attachments of documents (mainly word, excel or jpegs) The files can possibly be a couple of megs in size but will more likly be fairly small files. Can anyone recommend a...

Hi, I am using the ShellLnk.dll Library (comes on VB6 Pro & Enterprise Cd's), but when trying to run the app on the client PC's I get Cannot find file error all the time, through debugging I have isolated it to the ShellLnk library. I have created a install package with the Package and...

Hi, Is it possible to get the UserName of the current user logged onto Windows, as I need this to generate a value for a field in a stored procedure. Thanks, Gavin,

I am trying to convert a Time to a Decimal Value, but I am after rounding it by 5 minutes (so for example if I had 01:31:00, it would give me 1.5). So far I have managed to convert to a number with: format$(CDbl(#01:47:00#) * 24,"0.00") But not to clear on the easiest way to finish this off...

Hi, I am looking at a way to pull data from an email into an Access Memo Field, as some of the emails can have attachments, I will need to be able to store these as well, what I am thinking is extracting the attachments to a directory and storing the path/filename of the attachment in my SQL...

Hi, Does anyone know of an easy way in VBA to select all values in a multiselect(simple) listbox Thanks, Gavin,

Hi, I am fairly new to VB, and am trying to create a small application, which needs to be run though a command prompt or a shortcut with a parameter passed to it. For example you could run it as something like this update.exe /updatefile="c:\myupdate.upd" Can anyone tell me how/if I can...

Hi, I am fairly new to VB, and am trying to create a small application, which needs to be run though a command prompt or a shortcut with a parameter passed to it. For example you could run it as something like this update.exe /updatefile="c:\myupdate.upd" Can anyone tell me how/if I can...

Hi, I have Windows 2000 & Office 2000 Pro installed on several machines, but when I try to install SETUP.exe from Office Developer 2000 I get the various errors messages. The messages are as soon as SETUP.exe tries to run they are either program errors or Application errors for SETUP.exe, they...

Hi, I am trying to create a report in Crystal 9 that has a subreport, the subreport has a formula field called myTotals, which is on the group footer, what I want to do is pass the group footer value of htis back to the main report. Is this possible, I know you can pass values back and forth...

Hi, Does anyone know if it is possible to detect when a user selects a record (clicks the detail area for a particular form) on a continous form and if possible update a hidden value or even better change just the colour of the detail for that particular record and then again when you exit...

I am trying to create a Popup Menu for some of my forms, but I cant seem to find one function I want to add on to the Popup. On the Default Popup you have an option called "Filter For" and then a box where you can enter the filter condition, does anyone know how I can add this to my own Popup...

Hi, Does anyone know If Access 2003 has the standard VBA Addin's (Code Commenter, Source Book Manager etc...), as I could do with the Sourcebook (I know its not FMS Sourcebook, but its better than nothing), but I don't have any of the addin's available, can some one tell me if they still come...

Hi, Can some please help me as I am trying to set some properties when Creating a table (eg cat.Columns("ID").Properties("AutoIncrement")), but MS Help is its normal useless and sending me round in circles, does anyone know how I can get a list of all column Properties availble. In particular...

Hi, I have just wirtten/modified some code to check if a specified user is a member of a specified group, but when I run it I get the following error everytime, does anyone know how to stop this, I have tried logging out and loggin in and running the code before I do anything else...