Go Back   Access World Forums > Search Forums

 
Showing results 1 to 12 of 12
Search took 0.00 seconds.
Search: Posts Made By: NeoZakz
Forum: Modules & VBA 08-15-2002, 03:10 AM
Replies: 5
Views: 1,448
Posted By NeoZakz
I dunno about the above code but I can show you...

I dunno about the above code but I can show you what I put in that finally got it to work in 2000.

Form_NEWTracking
Public Sub Combo119_Change()


If IsNull(Me![Combo119]) Then
txtDateDue...
Forum: Modules & VBA 07-29-2002, 08:24 AM
Replies: 5
Views: 1,448
Posted By NeoZakz
Save variable from Dlookup to field?

Is there a way to save a variable from a Dlookup to a field in the table that is blank maybe? Or can you do a dateadd on a dlookup field?
Forum: Modules & VBA 07-25-2002, 11:21 AM
Replies: 4
Views: 847
Posted By NeoZakz
Hey yea, that should work good. Thanks Ill try...

Hey yea, that should work good. Thanks Ill try it out now. Tell you how it works.
Forum: Modules & VBA 07-25-2002, 11:07 AM
Replies: 4
Views: 847
Posted By NeoZakz
Didnt work

But I did find another way around it but ran into another small problem. Can you make a text box and then have an if statement to choose between 2 sets of dates and if one condition is false it...
Forum: Modules & VBA 07-25-2002, 05:30 AM
Replies: 4
Views: 847
Posted By NeoZakz
Question Re-running a field event on refresh?

Is there a way in a form to re-run a field event on a refresh command or on load maybe? Ive got a field in detail which loads different letter #'s and some info with them and I want to make a way...
Forum: Modules & VBA 07-24-2002, 11:29 AM
Replies: 3
Views: 795
Posted By NeoZakz
Better explanation maybe.

I tried what you suggested didnt like that. I tried to come up with a better explanation of what Im doing here.

Okay here it is, Im using a Form with 2 other subforms inside of it. Im working...
Forum: Modules & VBA 07-24-2002, 05:32 AM
Replies: 3
Views: 795
Posted By NeoZakz
Question Auto Refreshing data?

I have a form with 2 sub forms in it. And I just finished the code to update some dates in there. But what Im having trouble with now is that when I change the dates on the form where it pulls the...
Forum: Modules & VBA 07-23-2002, 09:44 AM
Replies: 5
Views: 730
Posted By NeoZakz
I got it working, what I ended up doing was...

I got it working, what I ended up doing was creating an extra hidden text field and had it read off of the Combo119 that way it took only the word in there at the time an stored it here. Then I had...
Forum: Modules & VBA 07-23-2002, 08:33 AM
Replies: 3
Views: 673
Posted By NeoZakz
Could try this instead of the = null I had a...

Could try this instead of the = null I had a similar problem a little while ago.

If IsNull(Me!ListItemData(0)) Then

That might work for you.
Forum: Modules & VBA 07-23-2002, 03:12 AM
Replies: 5
Views: 730
Posted By NeoZakz
That looks like it might work, but Ill also give...

That looks like it might work, but Ill also give that other idea you suggested a try as well. That might actually work easier then what I've been trying to do.


Thanks alot!
Forum: Modules & VBA 07-22-2002, 12:45 PM
Replies: 5
Views: 730
Posted By NeoZakz
Objective

Oh sorry here let me explain.

The code is supposed to check a combo box for a null value and if it has a blank then it does the dateadd by taking the number input into a date change box. If it is...
Forum: Modules & VBA 07-22-2002, 09:15 AM
Replies: 5
Views: 730
Posted By NeoZakz
Question How do you get a combo box to auto-lookup its value?

I have the following code in VB:

Private Sub days_after_AfterUpdate()
If IsNull(Me![Combo119]) Then
Me![Date Due] = DateAdd("d", Me![Seq], Me![Date Due])
Else

...
Showing results 1 to 12 of 12

 
Forum Jump



All times are GMT -8. The time now is 12:44 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World