Search results

Your a star and a gentleman! I think you have done more than enough for me today. Pat yourself on the back and get down the pub! Thanks once again! :)

Your right. Looking in detail, the way you have done it looks a lot better in the long run. I think I was getting in a little over my head eh? Your code: Private Sub Form_Current() If stt.Value = "0" Then Command8.ForeColor = vbRed Command8.Caption = "Out Of Stock" Else Command8.ForeColor =...

That is excellent! I will incorporate that into my other Spares Stock controls Db. With regard to the one originally posted. I wonder if you would take a very quick look at this attachment. The form has a module (a free download from http://www.peterssoftware.com/index.htm ). This solution...

Thanks for you help. Like this? (see attached(sorry still using A97)).

Hi, thanks for the quick reply. Not sure if it is required as there will only be approx 20 records.

Hi all, I have a very simple form that details loan machines for customers. What I need is a very obvious sign on each record to see if the machine is in our stock or not. A normal check box is an ovious answer but they are too small and my users complain (bigger glasses were an option :) )...

All: Great thread for beginners like myself. Thanks for the info on the books. Will order one this week. SJ McAbney: Thank you for the A97 ver. If only MS could of provided such a db!

George, I know just how you feel! Our company db's are all built on samples supplied with Access 97. Over the years they have become really fragmented with dozens of meanless and repeated fields/information. Trouble is we have approx 6 db's, all doing different things. I am now in the process...

Hi, Can anyone point me in the direction of building a knowledgebase? are there any tutorials/pdf's that anyone knows of? I am only assuming that Access is the program to use and that many people run this on their internal/external website with the assistance of ASP. Are there any examples...

I have a very simple macro that runs a query and copy/pastes the result into my form. The problem I have is: If there is no matching result, I get a couple of errors telling me the copy function cannot be used (as there is no data to copy), the action has failed and the macro grinds to a halt...

Thank you! Thats great! thank you! Your points regarding my coding practice is welcomed. I am learning (slowly) Thanks again. :)

This is the code that runs when a button on form 1 is pressed to open form 2(form 2 is called Replacement Unit): Private Sub Command80_Click() On Error GoTo Err_Command80_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Replacement Unit"...

Thats fantastic! Thank you.

Thanks, An idea I thought about, but have too many customers for a combo box really. Simply enter the post code, click the button and the result appears. The process works well. The only problem is the two messages when the postal code does not exist on the system. Can't it have a mssg box...

Thank you, but forgive my ignorance. how would I use this? As I said, I am new to all of this. Would I put this before the "is null" condition or does it replace it? Thanks again!

I am new to all this and require a little help if I may. I am slowly learning Access and ulitmately want to learn to build a DB relying on VB rather than macros. (VB... yet another thing to learn!) I have a search post code macro running a select query (see attached) I need to know what...

Thanks. I have a pretty good understanding of database design and ensuring normalisation. I am only trying to polish this old thing (origanally designed by my predecessor). I will be designing a new one when I have the time. At the momont this works for what we use it for. I just need a bit...

Hi, I am only a mere amateur when it comes to this stuff. A little more help if I may? Please see the attached Db sample with dummy data. If I type the postal code "AJ1 1AJ" (an existing customer) and click "Search P/Code" it will copy and paste from Table1. If the postal code does not exist...

Hi, We re-enter existing customer details for job sheets to repair customer equipment. A job number is issued (auto number) each time we create a new record.

Hi there, On my form, the user types in the customers postal code in to a field, clicks the "search address" button. This in turn runs a macro based on a query that finds the previous customer details and copies them to the latest record on the form (saving much time re-entering existing...