Search results for query: *

Got a table with primary key ranging from 1 to 3000 Need to find unused numbers between 1 to 3000. How?

Developed a system using access. with vb front-end. Come against a problem where sql query is coming up with :- Function is not available in expressions What seems to be the problem is access is not recognizing basic expressions of left, mid, right, trim, date Have attempted various versions...

I wish to incorporate a licencing scheme. (already done this but using computer name) is there some way of getting the computer serial number to incorporate into the licence key

I am binding textboxes to a recordset and everyting is ok using this method Except when it comes to the DTPicker which doesn't bind it gives Run-time error 545 "Unable to bind to Field or Datamember 'Expiry_Date' I use the Tag field to set the Field_Name of the control to bind i.e...

I have a routine to set some object to another object. set a = b How can i check that the returned object is NOTHING ie.e if isNothing(a) then There are isNull, isEmpty etc for variants but no isnothing. I have got round this before but could do with a more elegant solution cheers

Run-time error '3075': SQL within VB6 project IIf([Selected]![Product]=0,"?",IIf([Selected].[Ext_Product]="",Left([Products].[Name],3),[Selected].[Ext_Product])) & IIf('XX' Like 'X*','*','%') AS ProductX This error first came to light when being installed on an XP machine...

Hi All, This is a nutty one. We have developed an application which up until now works on all operating systems with no problems. Windows me, 98, 2000 and xp. Recently got a sony vaio portable and installed microsoft office 2000 profressional on it. Trouble is the queries were not working and...

Visual Basic's MSChart is unappealing to the eye. Are there any third-party graphing solutions (all I really need are basic line/bar charts nothing too fancy) out there that don't require licences (i.e. freebies) I tried using microsofts office graph.dll but could not find much in the way of...

I am using system colours for all forms. What i need to do now is change the backdrop of a chart to the same colour as the backdrop to the form. The chart can only be set using RGB colours, so how do i find the RGB colour of the form, when the colour returned (me.backcolor) is a system colour...

Hi All, I have a standard library of functions which is in library.dll. I recently changed a logevent Routine to check a public global variable DEBUG_ON and exit if not set else write a logging event to a file.log. The problem is my main program checks for /debug on the command line and then...

I have created a ProgressBar form. Which raises a Process event. I have tested it and it works fine. Next stage is to place this form within a Global Multiuse DLL (where I have all standard functions/forms that are to be shared across applications). So I placed the form in the dll and wrapped a...

How do you add items to an already existing menu via runtime. For instance I have created a mnuHistoryItem menu at design time. When a Site is chosen I wish to :- for i= 0 to mnuHistoryItem.ubound if mnuHistoryItem(I).tag = site then exit for next if I > mnuHistoryItem.ubound then 'create...

Problem I have is I wish to secure both the frontend/backend databases with a database password. This enables me to open them using VB6 and not let the users mess around with the tables queries. Problem I have is that all reports are done via activex access. i.e access.opencurrentdatabase xxxx...

Have a front end (reports queries)/ Back end (tables) access databases. Would like to give the user ability to create their own reports. Trouble is I have an automated update procedure where i send out new frontend with new queries/reports to replace the current one (links are refreshed via...

I have a class with Private mErrors() as String Public SomeProc() if ubound(mErrors)=0 then fill array end if do something end sub The problem is the array is not initialized. so get subscript out of range error. if I do private mErrors(0) then i cannot redim the array. What is...

Have various ActiveX DLL's that are shared across applications. The reason for developing the DLL's was so that if any erors were found then instead of packaging and redeploying the application, we could just transmit the DLL which had been corrected. Yet although a minor change within a...

When a user presses ENTER in a text box, I want it to respond as though the user pressed TAB. How is this possible?

In MsAccess trying to do an append query. but getting cannot do due to duplicates. The table I am selecting into has no records. It has no validation rules except primary key. The table I am selecting from is only indexed on the primary key. The weird and wonderful nature of the beast is that...