Search results

Awesome! Thanks very much.

After I logged in and showed the message: "Is this something like what you are looking for?" that was it. There was nothing after it. If it is not too much trouble could you resend that code to me? I would very much appreciate it. You mentioned something about needing ASP. Could you expand on...

Yes this is very possible. Make a button to preview your report and then in the code use something like this. DoCmd.OpenReport stDocName, acPreview, , "[OrderID] = Forms![Customer FRM]![F&I Orders FRM].form![OrderID]" This will filter for what you want to see. Hope this helps.

I am wanting to make our database so that customers can access it and see the current status of their home. Here is what I need help with. I want the customers to have to use something to log in so they can't see everyones records. They could log in with their last name as their username and...

Did you set your default to the size of margin that you need? I also have the same setup and haven't encountered the problem. Good Luck.

Try this 00000\-#### "0" are Digits (0-9; entry required) \ Literal character following - the dash "#" are Digits or spaces (entry not required and blanks are auto spaces. Hope this helps

Here is a module that was sent to me when I had the same problem. Good Luck! http://www.anauz.clara.net/access.htm

On your employee table you need to add an OLE Object. On your form you just enter a pic in that spot and it will save in the table with that employee's data.

I created all my forms in 1024x768 and all my users are using 800x600 and they have a hard time seeing all the form. Is there any code that can fix this? Thanks

AlexAA if you find a solution could you pass it on to my e-mail. I am on the same hunt and will pass on any solutions I find to you. Thanks in advance. mrssevans@yahoo.com

Have you tried the Documenter? Tools-Analyze-Documenter. This will allow you to select what you want to see and document.

If you want someone to type the date in you can set the Validation Rule so that the ending date field must be greater than the starting date field. As far as the form setting the date you might try putting the date in the default work with that. Hope that helps!

Sounds like you need to either use subforms on your main form or you need to use a query to make the form and make the query from the tables you need to enter data into.

You need to put that combo box in the table that the form is based on. Because it is an unbound field it does not know to link that selection to only one customer.

If the letters that you enter are permanent and they are not changing history then it might be beneficial to put it in the customer table.

You're a genius. Thanks

It did, I think. I still doesn't add a new line after the user and now(). I don't know if maybe it didn't work on my system. What was the Chr's? (Sorry, just a begginer in VB) Was it supposed to add characters? One more thing- can the cursor go to the new line after the time and user? Thanks

Thanks, I am going to try that. Sorry for posting it in two different places. Won't do it again. Thanks again.

I could use this but I am afraid that with the critical information that we have stored in these fields that it will over right the current information is something messes up. Any other suggestions?

I am needing a date field to go to a table and find the max date for that customer that it is presently showing and display it in this field. The form that this field is on is not a queried form and the information this field needs to find is not on the table the form is made from. Can you help?