Search results for query: *

jamwat, You can set the format of a date field with; hh:nn:ss:ms that is the Hours, Minutes, Seconds and Milliseconds Hope this help UrbaneRove

djmc, How to do it. Look up in the help on the order of events for the report. on the report load write in something like the following reports!MyReport.lblTitle.caption = "My New Title" this will select the label on the form and force it to a new caption Hope it helps

Hey all, A hopefully quick question in regards to file versions. In my office I have just been given a new project to work on with photoshop. The IT staff has put me on the new version (7.0) and the other person working on the images is on 5.5. We have to share some of the files and I was...

Nitrous270 (TechnicalUser) If cmbArtist = "Comp" or "Sndtrk" Then cmbReleaseID control source = CompReleaseID Else cmbReleaseID control source = ReleaseID me. should be Forms!("form name"). but you didn't give teh name. sub cmbArtist_onLostFocus() if...

Sentra52 (TechnicalUser) What you have posted is a limited bit of information. Your form elements... how is the table beign diplayed? How are you currently doing you flashing bit? If each element is part of the recordset the form is based on then reference each record separatly and flash the...

dvetro (IS/IT--Manageme) Just a quick one here. With the boxes that you are disableing the tab stop on. If it is to stop the user from selecting on the element then why don't you set the visible setting or the active setting on the element. The problem as I have found is that once you change...

Hey there lous, I have a question for you. when the app askes you for the input is this done in vba or on the query using the [EnterValue] in the criteria for the input. In the case of the latter one and yoiu don't want to start using vba then use the ...Build command in the criteria area of...

cviars (MIS) First of all how much VBA coding have you done? What needs to happen is the Master table needs to be linked to the Acc97 DB. Either Manually or through code. see docmd.transferdatabase which will work with all odbc compatible db's. Then open the table using db = currentdb...

Chavito21 (Programmer) If you want to run this at two in the morning automatically, Are you planning on leaving the applicaiton running all night. I would suggest using the scheduler in the Windows environment to open your app at 2am and have the app set to run it's code and close. Just an...

Quick addition; Make sure that you have compild your code. Access will not make a MDE file if the code still has errors. To do this in the VBA coding screen Debug - Compile 'AppName' Hope it helps Urbane Rove

Ok, help me before I flip out. Please I have three tables 1 - Dealers - Master 2 - Addresses 3 - Representative Relationships. A dealer can have many Addresses A dealer can have many Reps A Rep can only be assigned to one Dealer A Rep can not be assigned to a Address An Addy can only be...

Hi I also haven't tried this. But a quick idea would be a Shell Ping on the remote address. U. R.

osx99 There is a little reference problem in the way you wrote the code to reference your controls and value boxes. On the parent form the subform box which is the element that has to be referenced has to have a direct name. Irregardless of what form is actually in it. Lets say for this...

If I understand you right the control does not show up in the More Controls Icon on the Toolbox. If the file does exist as you have said you may have to re-register it. In the design view of the form Tools - ActiveX Controls Click the 'Register' button and navigate to the Systen32 folder...

siebel2002 (Programmer) Just checking that you have the ocx registered within the applicaion development environment. It may not be. In the design view of the form Tools - ActiveX Controls Microsoft Date Time picker ..... if you need to register it again it should be located in the sub...

Toby1kenobe Hello there, The problem as you state is not with your array but with the type your array is set to. A Byte has a value of 0 - 255. While a checkbox has one of three values 1) Null - The check box is neither on or off 2) 0 - The check box is not set 3) -1 - the CheckBox is...

SemperFiDownUnda Thanks for your time I got it working. UrbaneRove

SemperFiDownUnda No there is no sub classes. The whole bit is in the Class Modules.

Hello there, I have been writing VBA for 3years and vb for 1. I am starting to write reusable class modules and I would like to set them up into ActiveX dll so that I can load the functionallity with out loading the actual code. My Problem: I have a Encryption class module, I know there is a...

Why is it right after you pose a question you find an answer. Here is an example and answers to my question. http://w3.one.net/~kevinw/VB/l_dll.htm Thanks