Search results

Hi. I do not realy program in ms dos, but I need to take away the read only attribues for some files in a given directory, as currently only administrators on my network can access them. The read only attributes can only be removed in DOS with the command: attrib <directory>\<filename> I want...

Hi all. I have a database that i use to send emails automatically with the: DoCmd.SendObject acSendNoObject, , , emailto, , , emailsubject, emailmessage I use Morzilla Thunderbird as my email client....and everything worked fine until i installed the new version of Windows Live...

I am struggiling to find the Microsoft Internet OCX file on my machine. The file is found in C:\Windows\System\ or \\System 32\ folder. Could anybody who has it zip it and post it here? I would be most greatful!

Is there anyway to create a password on another external access database in VBA? Im not worries of the security issues just yet, i have a nice little encryption code that will bypass this problem!

Hi. Im trying to add a reference to MSINET.OCX. The problem is, i cannot find the file. It does not appear in \Syetem or \System 32. Anybody any ideas?

Hey guys. I need to be able to update a record when i click a command button. I've figured the best way to do this is with the use of an update query. How would i go about this? Perhaps set a control such as Dim ADOUpdate As ADODB.Command, set the ActiveConnection to the current connection...

Can anyone help me on some code? I cant actually work our how to do it, and nothing on the forums seems to suit. My problem involves checking if a folder exists, and the copying of an entire directory. The psuedo code is: 1. Check if a directory exists. "C:\Test\" as an example 2. (If) the...

Is there a way in VBA to display a certain ascii character by its identifier? For instance, in VB.NET the following would display: Private Sub DispASCII_Click() Dim theval as String theval = Chr(65) & Chr(66) & Chr(67) MsgBox theval End Sub A messagebox displaying "ABC". Is their a VBA...

I need to export a table to an email using the docmd.sendobject method. However! Here's the catch! I need to export that table as the message text in the email. Can anyone help me?

I have a problem! I have a table, tbl_Members. tbl_Members contains many fields, two being SName and RefferedBy. ReferredBy is stored in the table from a lookup from a form that looks up the SName field from tbl_Members. What i want to do is create a query from this table with an extra field...

Hi, im using access 2003, and i have a slight problem. I have a table, tbl_Members. The table contains many fields, of which all other relationships work fine, but on of the fields requires a lookup from the same table, tbl_Members. Is there anyway i can do this?

Hi. I wondered if there was a way to check if an email address is valid, ie. It dosent "bounce" if an email is sent? Thanks for your help.

Hi all. Ive searched the forums but theres nothing that adheres to excatly what i need. What i want to do is create an SQL expression in a VBA enviroment, to create a table, and insert data from a query into that table. I do not wish to use a create table query, this must be done in vba! For...

Hi, i've searched the forums, no look with this one im afraid. What i want is when a button is pressed, i want the following to happen: I want a new blank table to be created. I want records from an SQL query to be added into the table. I want to send that table to an external MS Access...

Hi, just a quick question. Is there any way of exporting say a query, or a range of quieries to another seperate access database file? ie. create a new database in code?

Hi, just a quick question. Is there any way of exporting say a query, or a range of quieries to another seperate access database file? ie. create a new database in code?

Hi. I need help declaring a dimension based upon a selection statement: If selection = "D" Then Dim testpayto as Form_frmCustomers Else If selection = "F" then dim testpayto as Form_frmCustomers[2] End If End If I get an error message saying that that the variable "testpayto" has been...

Hi, this is really puzzleing me! What i want to do is take a field from one table and a field from another and join them together to make a single field. I know this wouldnt work in practice without selection statements etc so only one field is selected, but if you could just help me on this...

Hello. I program in VB.NET, and i prefer not to use access whereever possible, (please dont be offended!), ive been asked to write a program in access, and took to the challenge. This is probably one of the simplest things ever, but i'm having trouble declaring an array. The problem code is as...

Hello. Is they anyway to return the last character of a string? for example: Dim strA as string Dim strB as integer strA = "12345ABC" I need some code to return the "C" in strB.