Recent content by lewds

How do you send email with Lotus Notes from MS Access Can you automate the process as with Outlook?

At this point,this just a concept for a small personal sports site. Would you please steer me towards a resource that could explain the process and give examples of assigning files to radio buttons then playing that file in an embeded media player. Just dipping my fingertips into web pages. I...

Hi.. Try turning the variable into a Function: In a standard module create: Public Function FnUser() FnUser = Ucase(Environ("UserName")) end Function Then for the Query: Field: BUSR_ID_CREATE Table: STSZ_TRANSACTIONS Update To: FnUser() As shown, this will update all the records in the...

Hi.. You could use the Column Property strReportTitle = strReportTitle & " - " & lbo.Column(1, Item)

Hi... Possible choices: 1.In the text box label, instruct the format you wish... Start Date (MM/DD/YY) 2.Use the Input Mask Property of the TextBox to set an Input Format 99/99/99;0 3. Ultimately, don't let the user type the date in, use a Calendar Control to pick the date you want entered...

Hi... pwise: My submission should no way infer that your solution was incorrect or not elegant. My submission is only another way to skin the cat. This is just a Recordset Method as oppose to an Array mentioned by avenuw If I have offended you in some way, Please let me apologize.

Hi.... Assuming a Table for Users and another for Lic Table Users (tblUsers) USER bob carol ted alice Table for Lic (tblLic) LIC L1 L2 L3 L4 Table for Info (tblInfo) USER LIC 'DLookup returns a Variant Dim db As DAO.Database Dim rsUsers As DAO.Recordset Dim rsLic As DAO.Recordset Dim...

Hi... This might be a general outline of what you want.. Do Until UserList.EOF VarUser = [User from UserList] DO Until LicenseList.EOF VarLicense = [License from LicenseList] Use DLookup for a result of VarUser and VarLicense If no result is found, insert into table VarUser and VarLicense...

Hi.. Look at the properties of the combobox and see what column it is displaying.

Hi... Which one is correct? <First posting> If [Building Type] = "Flat" Then [Extension].Enabled = False [Extension age].Enabled = False [Property 3rd floor area].Enabled = False [Extension basement floor area].Enabled = False - "This line now shows the error" [Extension...

Hi... Did you copy a working form and make changes, this can cause unexpected errors sometimes. Look carefully at the names and types of your Controls and make sure you are not trying to ENABLE a label.

Hi... What are we dealing with? A previous version of what? Custom Classes? Controls on a form? Different versions of Access? a little more information would be helpful.

Hi... PHV AS usual, you are correct. The Name Statement can be used to rename external files. I just didn't look closely enough at Help.

Hi .... The Name Statement is not available in VBA Issue a Shell Command like... Dim lRet lRet = Shell("cmd /c ren c:\PAYBR05P227904.txt PAY.BR05.P227904") cmd /c tells the command processor to execute the following string ren is the rename command c:\ is the Drive and path of the file The...

Hi... To update a field in a recordset dim rs as recordset set rs = (to a recordset) rs.movefirst Do until rs.EOF rs.edit rs("fieldname") = (Whatever) rs.udate rs.movenext Loop This is a generic construct for editing a recordset You have a rs.movenext within a For-Next Loop, this is not...