Search results

Yes Please Ken. I have loads more work to do on the database and all the help I can get will be most welcome. I have 4 major tasks left to do before it will be a in a working state.

I appear to have finaly sorted it out by adding another variable f a = Var1.Text b = Val(Right(a, 4)) b = b + 1 c = CStr(b) f = 4 - Len(b) d = Len(a) a = Left(a, d - 4) For i = 1 To f c = "0" + c Next

The problem with this code is that it only works when there are 2 leading zeros. If the code is ABC0008 the result is ABC09 instead of ABC0009 If the code is ABC0142 the result is ABC000143 instead of ABC0143 Can anyone suggest where this needs tweeking?

Thanks for that Ken No problems with that one and I think I understand how it works too! I have found the different functions in the VB help file although it will be hard to discover which functions will be of use to me.

Yes please Ken As you have probably guessed I am still learning about Access in my 2 month long quest to build a stock control database for my shop/.

I now have it working thanks to the both of you with one problem. The leading zeros are being stripped off. I have 3 calculated fields :- Letters: (Left([ProductID],3)) Returns the 3 letters Digits: (Right([ProductID],4)) Returns the digits NextCode: [Letters] & [Digits]+1 Brings the code...

Thanks Ken, I am trying to split your solution into seperate fields so I get ABC in one field and 0025 in the other. My thinking is that if I then add 1 to the second field the recombine them using & I should end up with the correct data. NoFrills It looks like your solution may be able to...

I think your solution is beyond me :eek: How do I enter a funtion like that into a query? I click on build and can see "functions" in the list but that is about as far as I get. Thanks for helping

Yes AB represents the supplier C represents the type 1234 is the number of ABCs there has been (if you see what I mean)

I have setup a query that gives me the last product code I have used by using criteria, sort by descending and top1. The resulting record is ABC0025 I want to be able to increment this by 1 in a calculated field to give ABC0026 so I know the next available product code to use. The closest I...

Thanks for that Doc. I have a lot to do and think about. Will be back soon with more questions I expect. Sean

Thanks for that Pat. I have downloaded some of the examples and will work through them. Sean

I am using the version of Access that shipped with OfficeXP and it doesn't come with the Orders database. Over the past day or two I have (in my opinion) come on leaps and bounds. I am taking a more structured approach now and am working through each task I need to do step by step. I realise...

Thanks very much Pat and The_Doc_Man. My "threat" to use Excel was really just that - a threat. As a user of spreadsheets since the days of 123Calc (I think that was what it was called) I feel comfortable with a spreadsheet. I am certainly not an expert Excel user but it is relativley straight...

I think maybe I need a break from sitting in front of the computer and give my head time to clear itself. Although I have made some progress from knowing nothing about Access to at least understanding some of the basics I can't see the light at the end of the tunnel.

Thanks for your help Ashfaque. The shop is a cash only business. I managed to set up the 3 tables with no problems and they work as I would expect as they are simple lookup tables. I then set up 2 further tables ORDERS and SALES ORDERS is for storing data of the orders I place with a supplier...

Thanks to all the people who have tried to help over the past few weeks in my quest to build a database for stock control of my shop. I thought Access would have been the tool of choice to do such a thing but it is just too complicated and too time consuming trying to understand how things...

I can't see anything that could be overriding things. It is not the end of the world though, for now I will put a button on the form that has to be clicked to update it.

Progress Report: I have now got the form to update the Query. Many many thanks Wayne! The text box that passes the criteria to the query comes from two other text boxes. =[Text29]+[Text33] (this gives a result in the form of ABC1234) I am now playing with all the possible Events for the text...

Thanks for taking the time to help. I tried putting Me.Requery in the code section of the AfterUpdate for the text box but the form still does not update although ooking at the actual querry itself shows the sorted results as ecpected. Do I need to add anything else apart from Me.Requery such...