Search results

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.

Thanks for the suggestion, but I just found a way to do it by code. But I did use that default property set to 0. =) I've been playing with this as a field in my query: Field1Value: IIf([Field1] Is Null,0,[Field1]) I am going to do this with all the the three fields then sum from there...

I have a query that has a field that sums the total of 3 other fields. My problem is whenever one of the 3 values is null, the subtotal does not work, but when all fields have a value it works perfectly fine. Is there a way to properly code this so that the field(s) that are null are given the...

Thanks for the suggestion... I have tried placing a 0 (zero) in the default value property, but it seems to only work when you create new records. I already have data in the some, but not all fields. I need to populated the null fields with 0. Im thinking that I need VB code to do...

I have a form with number fields. I am trying to do this with my form: When the form is loaded it checks the number fields and if they are null I want to populate their value as 0 (zero). Can someone help me with the proper coding in a generic format: Field names: Number1, Number2, Number3...

try pressing the F11 key when your database opens. i use that when i need to edit my database after i remove the startup menu from initial load.