Search results

Umm. I see what you did there, clever. Nice, yes that should lower flickering. Thanks for the idea.

Here is another Solution The problem of using the, DoCmd.RunCommand acCmdCopy, statement is that my default setting for the “Behavior Entering Field” property of the database is set to “Go to start of field” and not “Select entire field”, (Options). The solution is to select the entire field...

This is my approach: 1. Insert a picture 2. Program the MouseMove event of the picture to show a different picture like so: Private Sub imgReport_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Me.imgReport.Picture = "report-go" End Sub 3. Program the MouseMove...

Old thread, I know, but its OK. This is the link to the file mentioned Howzit. http://www.access-programmers.co.uk/forums/showthread.php?t=170380

Good point Brianwarnock. laxster did this solve the challenge?

I might be able to help but I need a sample file to work on. Please could you upload it?

The agony... that is how I originally envisioned it, I just did not want to go to all that hassle. I tough there was a better, faster, painless, easy way :) Thanks for replying.

Hey GregRun, yes it would seem so, but I just did not remove or update the default MZ-Tools header -I was in a hurry. I have corrected the code. Thanks for bringing it up. :o

Nice. Now, here is something to puzzles me. How do I go about adding additional data to existing records? For instance if I have the following table: ID | DataField1 | DataField2 | DataField3 1 | Somte Data | More data| xcetera 2 | Somte Data | ________ | xcetera 3 | Somte Data | More...

I might be using this but I have made a (small) improvement. Check out the error handler. Option Compare Database Option Explicit '--------------------------------------------------------------------------------------- ' Module : XXModuleNameXX ' Author : GregRun , Error handler...

If anyone is interested please see this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=73739

How about a few years later, hello and thanks from 2013 :-)

DavidAtWork Thank you very much for your suggestion, I saw it after I had already began implementing the previous one although I will not use it now I will definitely archive this for future reference. jdraw Seen your work and creative approach was inspiring I took your code and suggestions and...

Yes, Excel... that's another dimension to the problem, see Excel is wonderful when you need to calculates stuff but it falls short when it comes to relate information :-) . We are moving stuff to Microsoft Access to be able to get the information quickly, currently we have over 200 Excel files...

Hello jdraw :), Please find my comments to your reply below, in green. That really is not the purpose of a serial number. -I know, but that is what my company requires. It is the way they have this setup If you have a parts table, you can count the number pf parts manufactured...

I am at lost here (Access 2003). This is what I am trying to accomplish I need to be able to create a serial number which automatically resets every month so I may use it to easily know how many records were created per month, without running a report. This number will be saved in the...

This is related to your question, maybe you can adapt it: http://www.accessmvp.com/JConrad/accessjunkie/kickoff.html Do let us know if it helped.

Did you try reading the Help section? It points to error 3022, I found and easy solution to this problem here: msdn.microsoft.com/en-us/library/office/aa211376(v=office.11).aspx (I know, old thread, yet it remains relevant. I had the same problem today). The following example shows how you can...

I took some inspiration from this thread and here is my approach to this task. With creativity you can use it in fields for unique identifiers (my case) or ... who knows, be creative. Hopefully someone can use it some how: Sub Generate_Random_Serial() Dim...

Paul, all I can say is that when you are good at something there is not discussion about it. Thank you very much for staying and guiding me to fix this. It works perfectly. :D *-*-*-* If anyone is interested in the solution I have added a final version of the database with the working code...