Search results

Hi there I need so help with the replace function to replace multiple characters in a sting. The replace function syntax is: string1 = replace(sting1, "find", "ReplaceWith") I would like to replace multiple things but I'm not sure of the syntax. string1 = replace(string1...

Hi Does anybody know of a function or sample code that will tell me the last auto increment id from an insert query. I know of a function 'mysql_insert_id' in php but is there something similar in VB?

Hi All Does anybody know is it possible to disable an item in a combo box? I have a combo box with the contents index mapping to primary key records. I don't want to remove any of the contents as this would alter the index. I would like to disable the option when it has been selected to stop...

Hi I'm trying to setup navigation buttons on a form for a user to scroll through the records. I have created a recordset and want these button to be updated when at bof or eof. I have used a data control in VB and put the code in the reposition event. But I don't know how to do this in Access...

Hi Can anyone tell me how you can view links in Excel? We use a large spreadsheet at work that contains cells that link to other excel documents. Some of these links are incorrect and want to be removed. Is there any way of checking which cell links to which document without selecting the...

Hello I have a text box on a report that calculates a total, control source is =Sum([NetWgt]*([nett]/[paywgt])). This works fine but sometime when I run the report I get the error Overflow. I no this error is caused when a variable isn't large enough ie an integer is used instead of a double...

Is is possible to refer to a text box in the group footer part of a report by name. The text box is named Total and shows a total for each weight in a group. There's five groups so the text box is duplicated five times when the report is run, all showing a different weight total on the report...

Can anyone tell me how to print a report in Access Database from VB. something like: dim dbStock as database set dbstock = Opendatabase "C:\stock.mdb" dbStock.DoCmd.OpenReport "rptStock", acViewNormal ????? The DoCmd isn't available, is it possible to print a report this way?

Hi I'm trying to print fields to a text file, I have managed this no problem but I can only seem to print one field and I want more! I have the following code that uses the print statement Print #ArchiveNo, rsTblStudent.Fields("First Name") I would like to be able to add extra fields so I...

I have a parameter query that uses [Enter Name] for user input. If a user enters a name and presses ok the query brings up the required results. If user presses ok without entering anything in box I get wrong results. Anyone know how I can stop users from just pressing ok without entering name?

Hi - Can anyone give me any pointers on how I can check to see if a table exists. I have some code that creates a table but if the table exists already I get an error message. I want to be able to check before the make table code is run.