Search results

I guess I'm confused now. I am still extremely new to all of this, so be gentle! Let me give you a run down of my situation. I am an intern doing a project.....long summer to say the least. Anyway, they have a current system, but want something that is more user-friendly....this is where I...

Hey thanks for your replies! I looked up DMax, and have changed everything to this: Private Sub Form_OnOpen() Dim rstTagID As DAO.Recordset Dim Tag As Long Set rstTagID = DMax("[Tag]", "Clearance Tag List") If IsNull(rstTagID) Then Tag = 1 Else rstTagID.MoveLast Tag = rstTagID!Tag + 1 End...

OK, this is an old post and I thought I would see if anyone could give me some advice. I was given some help on this situation but couldn't get it to work, therefore I lost track of it, and I really need to get it figured out! This is what I've tried so far: Private Sub Form_Open() Dim...

So if I understand this correctly, the ID won't save in the table as the format I want? It will just display on the form? If this is the case, I don't want this to happen. I want to be able to save the ID with the "02-" or "03-" in front of it into the table. This is because there will be a...

I do not need consistent sequential numbers....all I need is a numbering field to display "02-00000". If one is deleted, say 02-00005, and the next one displayed is 02-00006....that is great! I just need a way of having an ID number that displays the current year as the first two digits and...

If I generate this in a BeforeUpdate event how do you suggest I do this? I've searched through the forums and can't find much help. I've been given advice on this same topic and another Access Programer suggested to do what I stated in the first post....so now I'm confused! I ultimately want...

OK. Here is my problem. I need a number/text (I'm pretty sure I need a text) format that does the following: 02-00000. The first two digits are the last two digits of the year and the last five digits are incremented by one each time a new one is needed. This is what I've worked on so far...

Ok, I understand where you are coming from, but I still don't think I can get rid of this second form. The query is user-defined, and the parameter box appears when the second form is opened. But if I get rid of the second form and change the query's criteria, then that message box will appear...

OH, and "YES" to your last question. I need the form to close and populate the first form!!!

AHHHHHH! I know it sounds confusing, but it really isn't....at least I don't think so. OK.....It doesn't matter what you put in the first form. Basically it is blank and the user is prompted to fill in all blanks. If the user knows the equipment ID off the top of their head then they can...

OK.....I'm not sure where I would put this: Forms!Form1.Form!EuipmentID = Me.EquiupmentID. This would be in the On Click event of a button. On the second form? I'm not sure if this would work for me. Secondly, I'm not use to using combo boxes. I have the query set up, so that it asks...

Ok...this is kind of confusing, but I can't seem to find any other helpful posts, so maybe someone will be able to help me! I have two forms. The first form allows user to input information into the database. On this form, there is a button, 'Equip. ?', that opens up another form. This...

I am very new to all of this, but I need some help! Currently I have two forms. These forms are for entering new data into the database. The first form's primary key is the 'Clearance ID' field which has an autonumber format. After all info is filled into the first form then the user is...