Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 103
Search took 0.01 seconds.
Search: Posts Made By: Lkwdmntr
Forum: Forms Today, 10:51 AM
Replies: 3
Views: 25
Posted By Lkwdmntr
Hiding checkboxes depending on the value of another field.

Hi Guys,

I just wanted to put this one out there again. I have daily forms for the week and they have actions that need to be marked off with checkboxes. Depending on the value of one of my...
Forum: Forms Today, 10:08 AM
Replies: 6
Views: 86
Posted By Lkwdmntr
Re: Scrollbar appears a record early

I decided to just make the subform a little bigger and changing my record count. The scrollbar only shows up when I need it now. I'd rather have the extra space at the bottom instead of the...
Forum: Forms Yesterday, 10:52 PM
Replies: 6
Views: 86
Posted By Lkwdmntr
Re: Scrollbar appears a record early

I don't think it would matter if it was zero-based seeing as it is going by the height of the subform. It just shows up when there are just enough records to fill the box. I don't need it until...
Forum: Forms Yesterday, 09:49 AM
Replies: 6
Views: 86
Posted By Lkwdmntr
Scrollbar appears a record early

Hi Guys,

I have a subform that will increase in width when the number of records reaches 8. When it gets wider the scrollbar also appears.

This problem is that I don't actually need it to get...
Forum: Forms 11-10-2019, 11:36 AM
Replies: 5
Views: 115
Posted By Lkwdmntr
Re: Accessing and manipulating sub-form information with VBA

I tried this, but it doesn't work, but I think something like this might. Maybe some pro's out there can help tweak this to work. If I can get it to work in one subform, then I should be able to...
Forum: Forms 11-10-2019, 11:27 AM
Replies: 11
Views: 168
Posted By Lkwdmntr
Re: Using an If statement for every record in a subform

dogs - Thanks, but I don't think I can use this. My checkboxes are linked to tables and need to be visible and able to check and uncheck. Interesting stuff though. Maybe I can use it in the...
Forum: Forms 11-10-2019, 11:24 AM
Replies: 11
Views: 168
Posted By Lkwdmntr
Re: Using an If statement for every record in a subform

J7 - That is just the way my form is set up. My pointing system gives them achievement points just for checking the box. This is why I have to have a Yes and a No box. Not to mention I need the...
Forum: Forms 11-10-2019, 12:00 AM
Replies: 11
Views: 168
Posted By Lkwdmntr
Re: Using an If statement for every record in a subform

Yes, they are Checkboxes, which makes it hard to conditionally format them. Maybe I can loop through the records? Not sure how I would do that. I read somewhere about using "Expression is", but...
Forum: Forms 11-09-2019, 11:22 PM
Replies: 11
Views: 168
Posted By Lkwdmntr
Using an If statement for every record in a subform

I used the following code and It locked my field, but for whole subform, not each record. How would I go about doing this.

If IsNull(Me.Tab1.Value) Then
Me.StartTimeChallengeYes.Locked = True
...
Forum: Forms 11-09-2019, 10:29 PM
Replies: 5
Views: 115
Posted By Lkwdmntr
Accessing and manipulating sub-form information with VBA

Hello again,

I am working on a point system for items that are checked off in a form. I have five separate subforms within the one daily form and point totals on the bottom. What would be ideal...
Forum: Modules & VBA 11-09-2019, 09:32 PM
Replies: 5
Views: 125
Posted By Lkwdmntr
Re: DLookup in VBA code

Thanks, that did it.
Forum: Modules & VBA 11-09-2019, 08:46 PM
Replies: 5
Views: 125
Posted By Lkwdmntr
DLookup in VBA code

Hi Guys,

I am working on a point system and made several queries to count items for the points. I tried this VBA code and am getting a syntax error. DLookup is a little different in the code...
Forum: Forms 11-01-2019, 07:39 AM
Replies: 5
Views: 144
Posted By Lkwdmntr
Re: Don't want to "Have to" enter a zero in a time value

If I use the one zero in the input mask, it won't let me put in a two-digit hour, lie 12:00 PM comes in as 1:20 PM.
Forum: Forms 11-01-2019, 06:54 AM
Replies: 5
Views: 144
Posted By Lkwdmntr
Don't want to "Have to" enter a zero in a time value

Hello everyone,

I'm hoping this is an easy one.

I have several forms and subforms that call for a time. Currently, the mask is
\99:"00 ">LL;0;" "
If I have a time value with a one-digit...
Forum: Forms 10-26-2019, 09:39 PM
Replies: 1
Views: 93
Posted By Lkwdmntr
Comparing data and locking a field on a form

Hello, I have one more issue and its a confusing one. My boss is wanting a field in a separate subform to determine whether or not you can enter data into another field in another subform.

If a...
Forum: Forms 10-26-2019, 08:13 PM
Replies: 11
Views: 189
Posted By Lkwdmntr
Re: Resize sub-forms when scorllbar appears

Ok, so I got it to work, but ran into another problem. I am using the same subform in two separate forms. One form is Form_FRM_Wed_Challenges and the other is Form_FRM_Wed_Challenges1. How do I...
Forum: Forms 10-26-2019, 07:05 PM
Replies: 11
Views: 189
Posted By Lkwdmntr
Re: Resize sub-forms when scorllbar appears

I stoped the code when loading and the CountWED variable is only at 1. It should be 22 if it is getting the number from the CountSAWED query.
Forum: Forms 10-26-2019, 07:01 PM
Replies: 11
Views: 189
Posted By Lkwdmntr
Re: Resize sub-forms when scorllbar appears

I took your advice, but it is still not working. No error, just not making the subform smaller.

Private Sub Form_Load()

Dim CountWED As Integer

CountWED = DCount("*", "CountSAWED")

If...
Forum: Forms 10-26-2019, 06:25 PM
Replies: 11
Views: 189
Posted By Lkwdmntr
Re: Resize sub-forms when scorllbar appears

I thought about doing that, but want to try to resize on the record size. I made a query called CountSAWED. I added code in the onload event and am getting a type mismatch error. Not sure what I...
Forum: Forms 10-26-2019, 05:40 PM
Replies: 11
Views: 189
Posted By Lkwdmntr
Re: Resize sub-forms when scorllbar appears

When the subform has more the 7 or eight records the scrollbar appears and it needs to be wider then the other subforms or the data will be cut off. When there is only a few records in the subform,...
Forum: Forms 10-26-2019, 05:08 PM
Replies: 11
Views: 189
Posted By Lkwdmntr
Resize sub-forms when scorllbar appears

Hi guys,

I was wondering if anyone has a nice easy solution to this problem I am facing.

I have a subform that when needed a scrollbar appears. I need to have the width of the subform wider...
Forum: Reports 10-25-2019, 12:23 PM
Replies: 10
Views: 146
Posted By Lkwdmntr
Re: Print and Print Preview

Just went over this with my boss and she agrees with the short cut. Thanks, nice solution.
Forum: Reports 10-25-2019, 09:51 AM
Replies: 10
Views: 146
Posted By Lkwdmntr
Re: Print and Print Preview

So the big boss wants all the forms and report views to be "Full Screen", that means, she doesn't want to see the behind the scenes work being done. It is like she is simply running an application,...
Forum: Reports 10-25-2019, 08:26 AM
Replies: 10
Views: 146
Posted By Lkwdmntr
Re: Print and Print Preview

Nice tip, but I don't think I'm using this properly. This is where I put the code and I still get the error box.

Private Sub Print_Click()

DoCmd.OpenReport "WeekataGlance_RPT",...
Forum: Reports 10-25-2019, 07:45 AM
Replies: 10
Views: 146
Posted By Lkwdmntr
Print and Print Preview

Hello,
I'm running into a problem when I pull up a report to print. I want to view it first and then have the option to print the report. This is the code I am using right now.
...
Showing results 1 to 25 of 103

 
Forum Jump



All times are GMT -8. The time now is 12:40 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