Search results

I use the below code to add a record to my database. It works great except I just can't figure out how to move to the newest record added to the form/database. If you don't mind taking a look at it and see if you can find what I am missing? Thanks. If Not Form.NewRecord Then If (Not...

ShaneMan - I want to thank you for helping me first of all. I do like your suggestion and I think I am going to try it. The main reason I don't won't to use a drop down list is that it creates a risk that someone will select the wrong shop and enter data for their shop into it and then loose it...

Yeah, I was thinking of that to.. but to make this easier on my users and be able to open up the shop with all the required data that I need, which is coming from multipule tables, this is the only way I can see doing it. I am very rusty at this so I may be missing on other options available to...

First off I think I got it working the way I want. At least it seems to be working. See the code below. I was using a list box to start with and it works fine, but I wanted to just have a button that is asigned to each Shop. I guess I kind of wanted to have something like a Switchboard but I...

I am starting to get back into access and I am finding out that I am very rusty at it. I am having a hard time figuring out how to open a form from a button on a specific record. What I have is a table that is built like this: Shop Table ShopID Shop What I want to do is have a form that...

I tried to concantenate the field but for some reason I couldn't get it to work with a single field. I have a form for engine information then I have a form that shows all the parts on order for the engine and its pertinate info. I want to be able to see just the part name on order on m form...

Basically I am concantenating the field and it is working great with the code above unless I only have one partonorder. IE Lets say I have only engineid 3 as and that is all I have for engines in my database and then I only order one part for it lets say a intake. When I run the above code it...

One table inputs the data and the other sorts in into on box per the engine id so that I am able to show it on a seperate from. I am really frustrated about this because this is the last thing I need to fix for my database to have it operational for use...

When I order parts for a engine it goes into a seperate table from the engine table EnginePartsOnOrder. I have a couple of query's that make a new table to put the EngineID with the PartName and then this code copies each EngineID and all its parts on order into one cell letting me be able to...

Ok I remarked the error handler out and when I ran it it gave me 3201 for the code. This is the line it stopped at If rsFind.Fields("EngineID") = EngineID Then I don't really understand what is wrong with this code. If I have only one record in my database it errors with the above. If I have...

This is exactly what it says: Either BOF or EOF is True, or the current record has been deleted. Requested opertation requires a current record. I do have at least one record in the table but for some reason it will not work with only one. As soon as I add a second record it works fine. Thanks

Someone here helped me with this code before but I am still having a small problem with it. If I only have one record for the PartName or nothing at all it errors out with something about EOF or BOF. I am not sure what to change to keep it from doing this. On Error GoTo Err_Handler Dim s As...

I am pretty sure I tried that but will give it a shot again. thanks

I want to say thanks for all the help I have recieved from here. This is the best site I have seen of this kind! My statement needs to work basically like this: If order is not null then if status is = "FMC" MsgBox "You still have an order!" end if else msgbox "FMC is now selected" end...

thanks that was it

I have a label I want to change on a subform but ant it to change when data on my main form changes. frmMain frmMainSub and the label name would be label1 which is on frmMainSub. How do a I reference label1? Thanks

Sorry for being annoying... I was really tired when I posted this last nite. Only reason the forms has qry at the beginning is I used autoform to create the form. I know I should change it but this form is just the one I am playing around with to try and get things to work. I guess the website...

found my problem! I have a form that has a subform on it that contains my data I am working with. For the most part the data is based on one table (tblMissile). I am creating another table that uses the ID from tblMissile in tblMPartOnOrderSort. I added both tables to my relationships and set...

Does anyone have a link that will show me how to design my above statement into a sql that will work in VBA. I don't mind reading and would like to know how to do this. Thanks

Don't know if this helps but this is the query I am trying to run DELETE tblMissile.MissileID, tblMissile.MissielTypeID, tblMissile.MLocationID, tblMissile.StatusID, tblMissile.MissileNum, tblMissile.Pri, tblMissile.EngDate, tblMissile.INEDate, tblMissile.DiscA, tblMissile.DiscB...