Recent content by Puddy

Trying to put together a mailing list from two excel spreadsheets given to me. It's been awhile since I've used access and cannot remember what I'm doing...so the premise is that I have these two tables imported from the xls files...What I need to do is compare the two tables, and if person1 is...

Well, i just about got this working..I am now able to generate the serial number, based on a qty needed by using the following code: Dim rstTableName As Recordset Dim intNewEntries As Integer Dim i As Integer intNewEntries = Forms!Form1!Qty 'You can replace this variable with the field on your...

you're right I'm kicking myself real hard right now, can't believe I missed that..thanks alot for the extra pair of eyes and the help....

argggg....I just recreated the entire database, rewrote the code, and still, same freakin problem...for some reason the Test is still equal to null everytime so it keeps returning the 001... I'm attaching the database to this as like i said, it is not too large, no real data in it yet...if...

anyone have any ideas? This was working like a charm 2 weeks ago and now it's not... I can see where the problem lies, but cannot figure out why it is happening...I put a breakpoint at the beginning of the If statment, and check the Results of the Test= it always comes up Null? Anyone have...

thanks, I'll give that a try, though now I have to figure out why the code isn't working...it was just the other day, but now for some reason, it will not go to 002, just keeps giving me 001...when I try to debug, the Test= part of the code comes back null, which is why it's going to 001, but I...

Here's the exact code I'm using, don't think I'm missing anyting: Private Sub Command11_Click() Dim MyDate, MyYear, MyWeek, MyDay, MyNumber As Integer Dim Ret As String Dim Test As Variant MyDate = Date MyYear = Format(Date, "yy") MyWeek = Format(DatePart("ww", MyDate, vbUseSystemDayOfWeek...

Not sure what happened, I've been working on trying to get the above to generate more then one sn#, but have now gone back to the original and for some reason it is not working anymore...I can generate the number, but it doesn't go to the next number when create a new record

right now all the form is doing is generating one serial# and upon clicking the close button,posts it to the table...I need to somehow use that code I have, as it formats and generates the sn# a certain way, but use a qty driven do loop to create the needed number of sn#'s entered into the qty...

I am using the following code to generate a # on a form. Private Sub Command11_Click() Dim MyDate, MyYear, MyWeek, MyDay, MyNumber As Integer Dim Ret As String Dim Test As Variant MyDate = Date MyYear = Format(Date, "yy") MyWeek = Format(DatePart("ww", MyDate, vbUseSystemDayOfWeek...

Thanks for the help, the above code worked like a charm...I have another question regarding this database and wheter or not it can be done...is it at all possible to generate numerous serial#'s at one time...meaning, right now if the generate serial function is used, it will generate 1 serial #...

Sequential Number Help I have created a command button on my form that when a user clicks it, it generates a serial# and places it into the serial# field on the form....the format for the serial# is Vyyww d ### What I now need this to do is to reset the ### part each day... here is the code I...

Hello. I am trying to find a way to convert a users approach database to access without having to rebuild the entier db. Anyone have any ideas, websites, programs, etc. that I should look at? thanks

That's on my project list, to get this db into SQL...this db was already here when I got here...now I have the chore of building it in SQL...

I'm hoping that this can be done, but from the reading I've done, haven't seen anything that can do it yet. Currently a one of my users has an access db that runs about 7-8 append queries on data that it has brought in from our AS/400 system. There is alot of data and the queries take a long...