Recent content by Marbinski

Thanks, I did some searches on those functions on the forum...they helped a lot!!!!

I have a table that has key dates for a production. Basically I am trying to create a QRY that can produce the actual date or the total amount of days left before the deadline date. But the catch is here: Example: Sales Begin Date (Field) 01/01/05 (Field Value) What I need: Deadline Date =...

I am going to test the suggested implemention. But I am still trying to figure out why at the network level, MS Access does this? Thanks for you help.

I have read previous posts but still am a lil confused on my current set-up. I have a Database that is placed in a network shared folder. For this folder we have a user group who only have "Read" access and we have a user group that has "Update" access to that folder. We are only letting...

Thanks a lot, works fine. This is a great tip for me to use later....

I have a report where I want to place parentheses around a field in my query. I have used concantenation w/ the & and got it working fine. But, my problem comes where the value of the field is null. On the report intead of having my field value w/ parentheses I just have the parentheses...

Perfect....thank you.

Initially, I do not have the Access Database Window open, but I'm creating a button to open or restore it. Can anyone help me with this line of code? Docmd....???? Thanks in advance. =)

Thank you for the reply. The suggestion works!!!

I have a form named FRM_GPI and when the user changes a textbox value to No, I have a form comes up and asks "Are you sure you want to change?" This form is named Confirm_Change and has two buttons: Yes and No. If the user selects Yes On the form named: FRM_GPI, I want TEXTA.Text = "N/A"...

Thank you very much works perfectly....

I am trying to query a number field. My problem is that I want it to have a special format. I want to create a 6 character string for the number. If the number is not 6 characters long I want to be able to query a 6 digit number. Basically I just want to add zeroes to the number until it makes...

I went ahead and create reports for these instead of using the actual form. Thanks for the help Rich.

i played with the solutions and they all work, i also got another solution from another person on this forum: http://www.access-programmers.co.uk/forums/showthread.php?t=75952

That is exactly what I wanted....and works great, my solution was a little off tangent from being efficient. Thank you for all your help.