Search results

I have attached a database that has only one form in it. The form has borderstyle of None, but it can be Maximized which will cover the ENTIRE screen, because the form is a pop-up form. I have used it to blacken the whole screen. This form has no header, no close button (but if you press the...

Smile, Is the code working now?

You need to be sure you have all your bases covered here. For example, are you going to erase the data from this txtUpdate field after you have processed it with the user clicking on the pop-up? Or will you set another field in the table that is a Yes/No field named "UpdateProcessed"? Which...

Jon, showing us the SQL being used to supply the records for this form that is not showing you all the records would be most helpful. In the meantime, try looking at including all records from the orders table, and include records from the customer table only if they are present. If you double...

The print preview has the line of DoCmd.OpenReport stDocName, acPreview, therefore the preview of the report works. But, in the code you show for the actual printing of the report, there is no line to open the report. You can add a line that is like this: DoCmd.OpenReport stDocName, acNormal...

I don't know of any way to hide a control except to set the focus elsewhere. But after looking at your year calendar, I put together two forms and one table that might make this whole project much easier to maintain. I have put them into your database and have attached that to this message...

AirForceRuss, What Moniker has outlined sounds right to me. I had a database 10 years ago that did sort of what you are asking. The database sent out e-mails to get managment approval for capital improvement projects, then received the approval/disapproval back from each managment person and...

If you are doing this in a multiuser environment, I would suggest that as soon as you determine what the next sequencial number is that you add that record to the file BEFORE you return that number to the caller. This is to prevent two people getting the same number. If you have more fields...

Are you looking for a pop-up to happen whenever the field is changed, or do you want a pop-up for each changed field when the database is opened on the LAN? And if there have been 15 records changed, do you want 15 pop-ups, or one pop-up with 15 lines on it?

Thank you very much. It works great! Even though the Access table does not show that 0 is the default, the field itself has a 0 in it after it is added to the table. Thank you!

I am trying to set a default to a new Yes/No field to 0/False in code. I can not find the syntax that will work for a BIT data type. I have tried everything I can think of, plus I can not find any documentation for Jet SQL. Any Ideas? So far I have tried this statement: ALTER TABLE...

Rather than just testing for Null, use an IIf test for null, if so, do not keep the record, otherwise test to see if the data will match your criteria. Something like: IIf(IsNull(Payment_Mth),False, IIf(Payment_Mth<>"DoesNotApply" AND NBReferral.Payment_Mth<>"" AND...

Would you type this into the immediate window, then copy the results and put those results into your reply. ?timetodec(#6:30:00#) Thanks,

Are you saying that the coding itself is so sensitive that it must be done in private? I really find that one hard to believe. I would think if it really is that sensitive, you should hire a consultant and have the consultant sign a non-disclosure agreement.

Try adding "As Double" to the Function statement like this:Public Function timetodec(Time1) As Double timetodec = CDbl(Time1) * 24 End Function

this code might help you find the folder you are looking for on your network drive. Within the For Each objFolders ... loop, you can look for the first 5 (or 7) characters that you know should be there, and therefore find the whole folder name.Function mFSO() Dim fso As FileSystemObject Set fso...

Actually, it is the 6th parameter, not the 2nd parameter. DoCmd.OpenForm "Remarks",,,,,acDialog

Sorry Mitch, but you are right, that is "a bit tricky." Actually, it's more than just a bit tricky. The first time I ever tried something like this it took at least a couple of days. There are quite a few things to learn, understand, and then a lot of trial and error. Now it would only take...

Sorry about that, I really felt it would not be too difficult. I DO stand corrected. I'm sorry I don't have the time to help more, as this is something I think is a great idea, and now I really want to help you conquer it! But I have a ton of stuff to do today, and I've already spent an hour...

And if the form is still open, please show us what is in that field on the form.