VB problem...

Similar Threads:

1.Have VB Problem on Access Startup

These values are stored in a table? Use the DLookup function to get them for
your code:

labelversion.Caption = DLookup("Version", "tablename")
DBCS_revised.Caption = DLookup("Revised", "tablename")
DBCS_website.Caption = DLookup("Website", "tablename")

-- 

        Ken Snell
<MS ACCESS MVP>

"Larry" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
> Ok i have a table with the database version, date created, aurthor, last
date
> updated and etc. Well I have that also in a form so i can view and change
the
> info from the form instead of going into the coding each time and changing
> all the forms. My problem is every time i start access the
> form_databasecontrolstatus opens every time and i dont want it to because
i
> dont want any users to see it. In the startup form, logon, motd, and main
> menu i have labels setup to point to this form and to the correct textbox
in
> that form for example the vb code i have setup for startup is
>
> Private Sub Form_Load()
> labelversion.Caption = Form_DatabaseControlStatus.Version.Value
> DBCS_revised.Caption = Form_DatabaseControlStatus.Revised.Value
> DBCS_website.Caption = Form_DatabaseControlStatus.Website.Value
> End Sub
>
> please help

2.VB problem....

Since this auto completes, the person data entering would 
know right away if the numbers pulling are or are not 
correct.  Also, since this is still in testing phase, I 
know that the numbers I'm pulling are correct.  It's kind 
of hard to miss an ID of 1234567.  HA HA.

All I have to type is 123 and it prefills 4567 for me.

I will try your method and let you know if it works.

Thanks.

debbie =}


>-----Original Message-----
>I'm guessing that the times it is not working, there is 
no match found. Try
>changing your code to this:
>
>Private Sub txtSearch_AfterUpdate()
>    'Find the record that matches the control.
>    Me.RecordsetClone.FindFirst "[ProvID] = '" & Me!
>[txtSearch] & "'"
>    If Me.RecordsetClone.NoMatch = False Then _
>        Me.Bookmark = Me.RecordsetClone.Bookmark
>End Sub
>-- 
>       Ken Snell
><MS ACCESS MVP>
>
>"Debbie" < XXXX@XXXXX.COM > wrote in message
>news:1f84301c389f6$bb8f32b0$ XXXX@XXXXX.COM ...
>> Coding having problem with...
>>
>> Private Sub txtSearch_AfterUpdate()
>>     'Find the record that matches the control.
>>     Me.RecordsetClone.FindFirst "[ProvID] = '" & Me!
>> [txtSearch] & "'"
>>     Me.Bookmark = Me.RecordsetClone.Bookmark
>> End Sub
>>
>> Problem...
>> Coding above is supposed to pull up a search in an 
unbound
>> text field.  It works find for a couple of times, but if
>> you try the search again, it comes up with an Action
>> Failed Window...  saying
>>
>> Macro Name:
>> cmdSAVE:Updated
>> Condition:
>> True
>> Action Name:
>> Set Value
>> Arguments:
>> [Forms]![frmMainScreen]![Date], Now()
>>
>>
>
>
>.
>

3.VB problem with copied form

Hi, I am using Access 2002 and I copied one of my forms, 
changed the buttons and code, and saved.  

Now the original form uses the code from the second, 
copied form.  I can tell because I am still working on the 
code for the second form and an error brings up the code. 
However, when I go into design view and look at the code, 
the old code is still there.  

When I replace the code through the error screen with the 
old code, it switches the whole preocess arround; now my 
new copy uses the code from the original.  Could anyone 
help with this?

Jessica Wunsch
AU Counseling Center Graduate Student for Web and Database

4.vb problem

hi all
this is my question
in Visual Basic 6 i have created a project that takes data from a MS access 
Data base.
my data base has a table that contains a table with tree fields.
id,name,comments
now in the VB i have a form with a text field that takes  the data from the 
field "comments" from access and display them in the text box.
the problem is that if  the field's content in comments field  is too 
long,in the VB text box , the data appears in "one line" and not in the frame 
of the text box...
i dont know if this is understendable but i need a help on that..

many thanks..
  

5.VB problem in Access 2007

Hello everyone

Lately I'm having a little problem with the VB in my forms...
When I start the mdb file, made in Access 2003 or 2000 can't recall, it 
doesn't load the VB code behind the forms.
I've got to punch F11 and then quit, for it to load the VB, otherwise I get 
an error message:

"The expression On Click you entered as the event property setting produced 
the following error: Object or class does not support the set of events."

The help on this error: 
"This error occurs when an event has failed to run because Microsoft Office 
Access cannot evaluate the location of the logic for the event. For example, 
if the OnOpen property of a form is set to =[Field], this error occurs 
because Access expects a macro or event name to run when the event is fired."

Can someone help please??????

Thanks in advanced...

6. SQL and Access VB Problem

7. Access 2003 Report & VB Problem

8. pass thru query & VB problem