Search results for query: *

Hi I have some date data that is stored backwards and am correcting it as part of a process. I have written something (below) which should do this. The current date is held as "19860317" under the general format. I can not format in excel as a date. When i run the program it seams to work...

I have a sony laptop and wish to output what is on my screen exactly ( not dual monitor ) . I have a work mate who it works for so the projector is good . The setup is the same , refresh rate, 32 bit of colour and resolution. Is there anything i am missing. On the sony normally you have to...

When inserting null's or blank into a table via VB6 front end into access using ADODB the vb code bombs out and says field'ad.name cannot be a zero length string I have this problem on inserting blank or null into dates, numbers and the above mentioned strings fields in databases. Is this a...

I have a table with lots of information but importantly with a URN (Unique reference number) and a date. I want to take the latest date for each member how can i do this via a query ?

I have an access database with approximately thirty tables in it. A user can have personal Information in some / all of the screens and maybe more than one record in each. I want to print out all the information that relates to each user (each table is related to a main table by a Unique ref...

Hi Is it at all possible to use hrefs in VB6 I want to link to a pdf on a certain page and this can be done using href's. If there is another way to do it with out hrefs then willing to give it a go . Thanks in advance Maverickmonster

Hi all I would like to know if it is possible to run VBA on a Access table like as in Excel with vba ? Thanks Maverickmonster

Hi I have a system where users tick or enter information to filter data on. I currently set all to * at the moment but this will be explained later why. When they have made thier choices they click the run query button . Every critira in the query is set to "Like([forms]![report]![status])"...

I have some tables that once made by a make table query i want to export to a user defined area is there anyway to bring up a popup box to let them save the table where they want ?

I am soon to complete a MDB which will goto two different people which they will both update is there any way i can really easily combine them every month and reissue so they are both up to speed with all current data. As both people are off site i can not do front and backend system like i...

Hi all not protected a db before. How can i lock a db so that users can not access any tables or design view unless they have a password. Thanks

I have following code. Which = "Select * from [BPD] where [BPD].dob = #" & defRsp & "# " RSbpd.Open Which, cn, adOpenKeyset, adLockOptimistic If Not RSbpd.EOF And Not RSbpd.BOF Then 'loading process It seams to be tempermental as it works some times and not others, the dates i try to...

Hi all Does anyone know of a tool to extract msi files from a .exe installer ? Thanks Maverickmonster

Hi all does any one know of any code to open a PDF though a VB6 form and on a selected page ? Thanks Maverickmonster

Hi all Im making a system and just tried to add a new txtbox and a error msg came up saying i have reached the limit for controls !! Is there any way to get round this or do i have populate the rest of the info onto new forms, although currently i was using tabs i could use multiple forms but i...

Hi all I have three types of input boxes in my form either a alpha numeric, number or date. If I enter the wrong type in to the wrong box, i get a error msg and the program crashes, how can i safe guard against these three eventualitys. I was thinking about using a like statement as i have...

I have this code to make a new record in my db though vb6 i wish to reuse this code but updating the records fields the same table, the record that is to be updated is the one selected in lstAdmain. defRsp = lstADmain Which = "Insert INTO AD VALUES ( '" & lastnum & "','" & ad & "','" &...

I have a large amount of tabs and information gets populated in to these tabs, is there anyway to change the apperance of the tabs to alert the user that there is information there

I have the following code in my VB6 form, defRsp takes its information from a txtbox which will contain typed date of birth. When you type a date of birth in the code goes to my error code to say record doesnt exist. the dob typed is in the table is in the database. The dob is formated as a...

I have a excel sheet with addresses in like 123 Way,456 street,newtown,wayaway,xx34 8zz is there an easy to split these in to there individual components.