Search results

Normally that would work but the record does not all get entered at once, so the only condition for completion is if the number is negative. The field can remain empty while other data is entered at different times. That is what is hanging this whole thing up.

The problem with that is that they do not have to re-enter...they can just continue leaving the field empty. Good idea, though..

Good info! Thanks!

Hi, I am tring to use a msgbox along with a validation rule for a calculated field which does not allow the user to progress until the data is corrected. There are three fields involved: TimeDateStart, TimeDateEnd and TotalTimeUsed. The formula is below: TimeDateEnd-TimeDateStart=...

Worked like a charm! Many thanks!! jake

Hello, I am having a bit of a problem trying to set up a message box. I have a date field and a time field as the last two fields on my form (continuous). I would like a message box to display if the time field (formatted "medium time") is left empty. It must be filled out to complete the...

Hi, I designed a form for other users and it has been running perfect, until last night. Within the code, I used the toolbar method to hide three toolbars, one of which is a menu replacement, along with two other toolbars that I use for maintenance issues. I have the code passworded so that it...

Hi, I am trying to create a query that will show data in a rolling four month period. Example: For September, show June through September; for October, show July through October. I am using a general date format in the field. I can use >DATE() - 120 to get a 120 day period, but that...

Since any user is able to hold the Shift Key then double-click an Access file to open to the object panel and/or code, is there any way to prevent this other than a file password or using Access Security? I can password the code, but the object panel still is available. Thanks in advance, Jake

Right. That is what I have been using. But I still have the question of how to set a mask for that format, so that the "mm/dd h:n ampm" is entered without needing to put the "s". That way, they have to enter both the date and time, not just one or the other. Left without masking, the user can...

That's where I run into the problem. Since I am using a "General Date" format, seconds are part of the format. I am trying not to require the users to enter the seconds, so I am not sure how to set the mask for a two digit month, two digit date, two digit hours, two digit minutes and the am/pm...

Hello, I have two fields (call them field 1 and field 2), which are both formatted for "General Date". Since they are used in a calculation of Date and time, I need both segments to be entered. Is there a way I can create a validation rule that doesn't allow data unless it is mm/dd hh:mm...

In terms of a background on what it is doing, I am pushing the 200 character mark. The first column is a mandatory visible at all times (and long), the job name. The second column is to be visible when selecting the record, because it gives a piece of information on correct data entry for...

I tried the column change, but no helpl To answer your question, I need the first column(0) and third column(2) to be visible. Col 0 is in the combo box and the plan for col 2 was to be in a text box.. Hope that answers the question, or did I misunderstand?

Hi, I have a combobox with three columns, and the bound column is column 1. With the following code, I have tried to make column 3 visible in a text box: Private Sub jobName_AfterUpdate() txtJobDesc.Value = JobName.Column(1) End Sub However, this is not working. Any help will be...

Nope, same thing. I

The form closes...sorry I didn't make that clearer...

Hi, I have a custom toolbar that I want hidden on a form that is not connected to a database; it is serving as a "Splash Screen." Here is the Code: Private Sub Form_Load() DoCmd.ShowToolbar "myToolbar", acToolbarNo End Sub When the form opens, it shows briefly, then closes...

Hi, I have in the Form_Load() event, the following command: Private Sub Form_Load() DoCmd.Maximize End Sub It has been fine for several weeks, and today, when I open the form, it does not maximize. Also, there are a few other commands that are not working, connected to macros, plus an...

re Query to combine a date and a time Got it ... made it too difficult for myself.. Thanks